SELECT DISTINCT ShellProduct.uid, ShellProduct.brand, ShellProduct.itemName, ShellProduct.topprice,ShellProduct.bottomprice,ShellProduct.topname,ShellProduct.bottomname, ShellProduct.[2x2], ShellProduct.[3x3], ShellProduct.[6x6], ShellProduct.child1, ShellProduct.child2, Products.uid, Products.Code,33 as catID,Collection, ShellProduct.orderby, collections.orderby , [Products].IsOnSale as topIsOnSale, [Products].SalePrice as topSalePrice, p2.IsOnSale as bottomIsOnSale, p2.SalePrice as bottomSalePrice FROM ShellProduct INNER JOIN Products ON ShellProduct.child1 = Products.uid INNER JOIN collections ON ShellProduct.collection = collections.uid LEFT JOIN [Swimspot].[dbo].[Products] As p2 ON ShellProduct.child2 = p2.uid Where ShellProduct.IsActive = 1 AND ShellProduct.isBuilderItem =0 AND ShellProduct.uid IN(Select ShellID From ShellCategory Where CategoryID=33) ORDER BY collections.orderby,ShellProduct.orderby ,ShellProduct.itemName
START Page_Load new=cBSSearch
NOT Page.IsPostBack brand=
request querystring category=33
brand_count=0