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