SELECT [Category].[Name], [ProductList].[ID], [ProductList].[SKU], [ProductList].[ProductName], [ProductList].[Description], [ProductList].[Quantity], [ProductList].[Size], [ProductList].[Price], [ProductList].[Active], [ProductList].[SalePrice], [ProductList].[Discount], [ProductList].[CategoryID], [ProductList].[Color] FROM Category INNER JOIN ProductList ON [Category].[CategoryID] =[ProductList].[CategoryID] where ProductList.CategoryID = #url.categoryid# and ProductList.Active = true and ProductList.Outfit = 0
SELECT [Category].[Name], [ProductList].[ID], [ProductList].[SKU], [ProductList].[ProductName], [ProductList].[Description], [ProductList].[Quantity], [ProductList].[Size], [ProductList].[Price], [ProductList].[Active], [ProductList].[CategoryID], [ProductList].[Color] FROM Category INNER JOIN ProductList ON [Category].[CategoryID] =[ProductList].[CategoryID] where ProductList.OutfitID = #Outfits.OutfitID# and ProductList.Active = 1 and ProductList.Outfit = 1
#Outfits.Name#
BUY WHOLE OUTFIT
  --->
Products
Sale Price : $#Products.SalePrice#
Price : $#Products.Price#
#Products.ProductName#