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