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