Browse by category
Browse all products
DECLARE @collectionIds1 int = 227;
DECLARE @collectionIds2 int = 55;
DECLARE @collectionIds3 int = 1;
DECLARE @collectionIds4 int = 264;
DECLARE @collectionIds5 int = 35;
DECLARE @collectionIds6 int = 36;
DECLARE @collectionIds7 int = 114;
DECLARE @collectionIds8 int = 2;
DECLARE @collectionIds9 int = 57;
DECLARE @collectionIds10 int = 52;
DECLARE @collectionIds11 int = 53;
DECLARE @collectionIds12 int = 42;
DECLARE @collectionIds13 int = 43;
DECLARE @collectionIds14 int = 49;
DECLARE @collectionIds15 int = 56;
DECLARE @collectionIds16 int = 58;
DECLARE @collectionIds17 int = 60;
DECLARE @collectionIds18 int = 59;
DECLARE @collectionIds19 int = 50;
DECLARE @collectionIds20 int = 54;
DECLARE @collectionIds21 int = 48;
DECLARE @collectionIds22 int = 61;
DECLARE @collectionIds23 int = 64;
DECLARE @collectionIds24 int = 47;
DECLARE @collectionIds25 int = 62;
DECLARE @collectionIds26 int = 51;
DECLARE @collectionIds27 int = 63;
DECLARE @collectionIds28 int = 44;
DECLARE @collectionIds29 int = 3;
DECLARE @collectionIds30 int = 254;
DECLARE @collectionIds31 int = 253;
DECLARE @collectionIds32 int = 232;
DECLARE @collectionIds33 int = 37;
DECLARE @collectionIds34 int = 226;
DECLARE @collectionIds35 int = 105;
DECLARE @collectionIds36 int = 4;
DECLARE @collectionIds37 int = 111;
DECLARE @collectionIds38 int = 110;
DECLARE @collectionIds39 int = 113;
DECLARE @collectionIds40 int = 40;
DECLARE @collectionIds41 int = 6;
DECLARE @collectionIds42 int = 7;
DECLARE @collectionIds43 int = 107;
DECLARE @collectionIds44 int = 41;
DECLARE @collectionIds45 int = 112;
DECLARE @collectionIds46 int = 221;
DECLARE @collectionIds47 int = 206;
DECLARE @collectionIds48 int = 225;
DECLARE @collectionIds49 int = 8;
DECLARE @collectionIds50 int = 28;
DECLARE @collectionIds51 int = 45;
DECLARE @collectionIds52 int = 10;
DECLARE @collectionIds53 int = 94;
DECLARE @collectionIds54 int = 11;
DECLARE @collectionIds55 int = 217;
DECLARE @collectionIds56 int = 218;
DECLARE @collectionIds57 int = 32;
DECLARE @collectionIds58 int = 12;
DECLARE @collectionIds59 int = 13;
DECLARE @collectionIds60 int = 14;
DECLARE @collectionIds61 int = 38;
DECLARE @collectionIds62 int = 300;
DECLARE @collectionIds63 int = 29;
DECLARE @collectionIds64 int = 27;
DECLARE @collectionIds65 int = 106;
DECLARE @collectionIds66 int = 16;
DECLARE @collectionIds67 int = 224;
DECLARE @collectionIds68 int = 17;
DECLARE @collectionIds69 int = 18;
DECLARE @collectionIds70 int = 19;
DECLARE @collectionIds71 int = 20;
DECLARE @collectionIds72 int = 21;
DECLARE @collectionIds73 int = 220;
DECLARE @collectionIds74 int = 109;
DECLARE @collectionIds75 int = 39;
DECLARE @collectionIds76 int = 233;
DECLARE @collectionIds77 int = 104;
DECLARE @collectionIds78 int = 298;
DECLARE @collectionIds79 int = 23;
DECLARE @collectionIds80 int = 219;
DECLARE @collectionIds81 int = 24;
DECLARE @collectionIds82 int = 103;
DECLARE @collectionIds83 int = 25;
DECLARE @collectionIds84 int = 222;
DECLARE @collectionIds85 int = 93;
DECLARE @collectionIds86 int = 46;
DECLARE @collectionIds87 int = 92;
DECLARE @collectionIds88 int = 83;
DECLARE @collectionIds89 int = 90;
DECLARE @collectionIds90 int = 85;
DECLARE @collectionIds91 int = 84;
DECLARE @collectionIds92 int = 89;
DECLARE @collectionIds93 int = 91;
DECLARE @collectionIds94 int = 88;
DECLARE @collectionIds95 int = 108;
DECLARE @collectionIds96 int = 115;
DECLARE @collectionIds97 int = 34;
DECLARE @collectionIds98 int = 223;
DECLARE @collectionIds99 int = 26;
DECLARE @collectionIds100 int = 30;
DECLARE @collectionIds101 int = 229;
DECLARE @collectionIds102 int = 33;
DECLARE @collectionIds103 int = 33;
DECLARE @collectionIds104 int = 33;
DECLARE @collectionIds105 int = 33;
DECLARE @collectionIds106 int = 33;
DECLARE @collectionIds107 int = 33;
DECLARE @collectionIds108 int = 33;
DECLARE @collectionIds109 int = 33;
DECLARE @collectionIds110 int = 33;
DECLARE @siteId int = 1;
DECLARE @GetValueOrDefault int = 10000;
SELECT [s1].[CollectionProductId], [s1].[CollectionId], [s1].[ProductId]
FROM (
SELECT DISTINCT [c].[CollectionId]
FROM [CollectionProduct] AS [c]
INNER JOIN [Collection] AS [c0] ON [c].[CollectionId] = [c0].[CollectionId]
INNER JOIN [Product] AS [p] ON [c].[ProductId] = [p].[ProductId]
WHERE [c].[CollectionId] IN (@collectionIds1, @collectionIds2, @collectionIds3, @collectionIds4, @collectionIds5, @collectionIds6, @collectionIds7, @collectionIds8, @collectionIds9, @collectionIds10, @collectionIds11, @collectionIds12, @collectionIds13, @collectionIds14, @collectionIds15, @collectionIds16, @collectionIds17, @collectionIds18, @collectionIds19, @collectionIds20, @collectionIds21, @collectionIds22, @collectionIds23, @collectionIds24, @collectionIds25, @collectionIds26, @collectionIds27, @collectionIds28, @collectionIds29, @collectionIds30, @collectionIds31, @collectionIds32, @collectionIds33, @collectionIds34, @collectionIds35, @collectionIds36, @collectionIds37, @collectionIds38, @collectionIds39, @collectionIds40, @collectionIds41, @collectionIds42, @collectionIds43, @collectionIds44, @collectionIds45, @collectionIds46, @collectionIds47, @collectionIds48, @collectionIds49, @collectionIds50, @collectionIds51, @collectionIds52, @collectionIds53, @collectionIds54, @collectionIds55, @collectionIds56, @collectionIds57, @collectionIds58, @collectionIds59, @collectionIds60, @collectionIds61, @collectionIds62, @collectionIds63, @collectionIds64, @collectionIds65, @collectionIds66, @collectionIds67, @collectionIds68, @collectionIds69, @collectionIds70, @collectionIds71, @collectionIds72, @collectionIds73, @collectionIds74, @collectionIds75, @collectionIds76, @collectionIds77, @collectionIds78, @collectionIds79, @collectionIds80, @collectionIds81, @collectionIds82, @collectionIds83, @collectionIds84, @collectionIds85, @collectionIds86, @collectionIds87, @collectionIds88, @collectionIds89, @collectionIds90, @collectionIds91, @collectionIds92, @collectionIds93, @collectionIds94, @collectionIds95, @collectionIds96, @collectionIds97, @collectionIds98, @collectionIds99, @collectionIds100, @collectionIds101, @collectionIds102, @collectionIds103, @collectionIds104, @collectionIds105, @collectionIds106, @collectionIds107, @collectionIds108, @collectionIds109, @collectionIds110) AND [c0].[SiteId] = @siteId AND [p].[SiteId] = @siteId AND [p].[IsDeleted] = CAST(0 AS bit)
) AS [s0]
INNER JOIN (
SELECT [s].[CollectionProductId], [s].[CollectionId], [s].[ProductId]
FROM (
SELECT [c1].[CollectionProductId], [c1].[CollectionId], [c1].[ProductId], ROW_NUMBER() OVER(PARTITION BY [c1].[CollectionId] ORDER BY CASE
WHEN [p0].[SiteId] = 1 AND [p0].[ProductType] = 'mn' THEN CAST(1 AS bit)
ELSE CAST(0 AS bit)
END DESC, [p0].[IsInStock] DESC, [p0].[DateTimeUpdated] DESC) AS [row]
FROM [CollectionProduct] AS [c1]
INNER JOIN [Collection] AS [c2] ON [c1].[CollectionId] = [c2].[CollectionId]
INNER JOIN [Product] AS [p0] ON [c1].[ProductId] = [p0].[ProductId]
WHERE [c2].[SiteId] = @siteId AND [p0].[SiteId] = @siteId AND [p0].[IsDeleted] = CAST(0 AS bit)
) AS [s]
WHERE [s].[row] <= @GetValueOrDefault
) AS [s1] ON [s0].[CollectionId] = [s1].[CollectionId]
