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