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