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