SELECT Product.*, Category.CategoryName, Category.CategoryID, Category.CategorySID, Category.ParentID, CONCAT(ProductBrand,' ',ProductName) as PFullName FROM Product LEFT JOIN Category ON Product.CategoryID = Category.CategoryID where Product.ProductBrand>'' and Product.CategoryID=49 and ((Product.ProductRetail>0) or (Product.ProductPrice>0)) order by CONCAT(ProductBrand,' ',ProductName)
VINTAGE PURSES AND ACCESSORIES > Vintage Belts
Sorry, no products found in this category. Please check back later.
