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