DECLARE @__GetValueOrDefault_1 int = 12; SELECT [t0].[CollectionProductId], [t0].[CollectionId], [t0].[ProductId] FROM ( SELECT DISTINCT [c].[CollectionId] FROM [CollectionProduct] AS [c] WHERE [c].[CollectionId] IN (34, 16, 23, 103, 108, 41, 94, 106, 104, 26, 40, 2, 8, 42, 12, 110, 107, 1, 39, 7, 29, 25, 109, 11, 83, 105, 115, 45, 35, 17, 24, 28, 93, 27, 92, 224, 112, 19, 264, 114, 46, 47, 90, 227, 55, 30, 91, 254, 300, 113, 219, 18, 56, 38, 111, 4, 52, 44, 232, 206, 226, 223, 53, 225, 43, 21, 51, 253, 63, 233, 89, 221, 20, 6, 32, 217, 229, 61, 50, 84, 48, 222, 57, 37, 64, 59, 60, 62, 58, 218, 14, 220, 36, 10, 33, 88, 13, 49, 3, 298, 85, 54) ) AS [t] INNER JOIN ( SELECT [t1].[CollectionProductId], [t1].[CollectionId], [t1].[ProductId] FROM ( SELECT [c0].[CollectionProductId], [c0].[CollectionId], [c0].[ProductId], ROW_NUMBER() OVER(PARTITION BY [c0].[CollectionId] ORDER BY NEWID()) AS [row] FROM [CollectionProduct] AS [c0] ) AS [t1] WHERE [t1].[row] <= @__GetValueOrDefault_1 ) AS [t0] ON [t].[CollectionId] = [t0].[CollectionId]