Kiln Shelves

strProdListSQL: WHERE ProductCategories.CategoryID = '356' AND (Products.ParentID IS NULL OR Products.ParentID = SKU OR Products.ParentID ='') AND Products.Display = 1 AND Products.Site1 = 1 AND Products.GlCode <> ''
varProductsTotalCount: 0
lastProdID: 0
rsPsql: SELECT Products.ProductID, SKU, ProductName, Products.LongDescription, Products.SupplierID, Products.CategoryID, OnSpecial, SpecialPrice, PromoText, BandA AS UnitPrice, LineItemTax, UnitsInStock, ProductPicture, ProductThumb, Specifications, UnitWeight, Keywords, Products.ColID, BandA AS TradePrice, Products.RestockDate, Products.PriceOptions, Products.Display, Products.BuyButton, Products.UnitSize, Products.UnitColour, Products.BandA, Products.BandB, Products.BandC, Products.BandD, Products.BandE, Products.BandF, Products.BandG, Products.BandH, UnitsInStock AS wh1_stock, 0 AS wh2_stock, CostPrice, ProductNameCustom, ProductDescriptionCustom, Products.Fragile, Products.TaxCode, Products.NonStockItem, Products.SampleAvailable, Products.ProductPicture AS ProdPic, Products.ParentID, Products.ExternalCatID, Products.QuantityPerUnit, Products.stUser3,Products.Barcode, Products.ShortDescription, Products.stUser2,Products.stUser5,Products.stUser6,Products.ProcessType, Products.stUser10,Products.ShowImgOverlay,Products.ImgOverlayText,Products.OnSpecial_Cat, (SELECT OfferPercent FROM SpecialOffers WHERE SpecialOffers.ID = Products.OnSpecial_cat) AS OnSpecial_Cat_Percent, (SELECT OfferText FROM SpecialOffers WHERE SpecialOffers.ID = Products.OnSpecial_cat) AS OnSpecial_Cat_Text, (SELECT Active FROM SpecialOffers WHERE SpecialOffers.ID = Products.OnSpecial_cat) AS OnSpecial_Cat_Active, Products.ShowProductGroups, Products.stStockType FROM dbo.ProductCategories INNER JOIN Products ON Products.SKU COLLATE Latin1_General_CS_AS = ProductCategories.ProductID COLLATE Latin1_General_CS_AS WHERE ProductCategories.CategoryID = '356' AND (Products.ParentID IS NULL OR Products.ParentID = SKU OR Products.ParentID ='') AND Products.Display = 1 AND Products.Site1 = 1 AND Products.GlCode <> '' AND Products.ProductID > 0 ORDER BY Products.DisplayOrder, Products.SKU