SELECT Distinct(products.ID), products.ProductTitle, products.CardLayout, products.SyncID, Products.IsOwnDesign, Products.ProductSize, Products.Page_Number, case when products.IsOwnDesign = 1 then 9999 else [products_links].DisplayOrder end as DisplayOrder FROM [products_links] INNER JOIN products ON ([products_links].BackTemplateID = products.ID) LEFT OUTER JOIN [products_membership_links] PML ON ((PML.ProductID = [products_links].BackTemplateID) AND (PML.MembershipType = @MembershipType)) LEFT OUTER JOIN [products_user_links] PUL ON ((PUL.ProductID = [products_links].BackTemplateID) AND (PUL.USER_ID = @UserID)) WHERE products.FLAG_ACTIVE = 1 AND (PML.MembershipType = @MembershipType OR PUL.USER_ID = @UserID) AND products.ProductSize in (100103,100105,100001,100018,100010,100127) AND products.Page_Number = 2 AND (products_links.FrontTemplateID = @FrontTemplateID OR products.IsOwnDesign = 1) AND ((PML.Disabled IS NULL) OR (PML.Disabled = 0)) group by products.id,products.ProductTitle, products.CardLayout, Products.IsOwnDesign, Products.ProductSize, Products.Page_Number, products_links.DisplayOrder, PUL.displayOrder, Products.SyncID ORDER BY DisplayOrder, products.ID;
MembershipType: 100024
UserID: 0
Upload Your Own



Back