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