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