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 (11, 24, 16, 29, 17, 83, 41, 23, 106, 35, 103, 28, 93, 115, 108, 105, 94, 39, 2, 12, 27, 26, 107, 42, 109, 7, 45, 8, 110, 34, 25, 1, 40, 104, 113, 32, 63, 112, 217, 13, 62, 19, 300, 60, 254, 20, 89, 114, 206, 223, 225, 88, 219, 92, 55, 47, 222, 227, 91, 111, 232, 3, 220, 85, 218, 229, 49, 53, 33, 18, 221, 226, 6, 52, 61, 38, 54, 58, 59, 14, 4, 44, 51, 264, 233, 10, 253, 56, 30, 36, 50, 37, 84, 224, 43, 64, 57, 90, 46, 21, 298, 48) ) 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]