 |
|
|
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=63 and ((Product.ProductRetail>0) or (Product.ProductPrice>0)) order by CONCAT(ProductBrand,' ',ProductName)
VINTAGE BAGS > Vintage Ostrich Skin BagsSorry, no products found in this category. Please check back later.
|
||
