Top » Catalog » All Products Log In |  Cart Contents  |  Checkout |  Categories Amino Acids -> Creatine -> EFAs and Dietary Oils -> Fitness Accessories -> Health and Nutrition -> Health Concerns -> Herbs & Other Blends -> Nutrition Bars -> Protein -> Shakes & Drinks -> Sports Nutrition -> Vitamins & Minerals -> Weight Loss -> View All Products -> All Products sorted by Categories -> All Products sorted by Manufacturers -> 1054 - Unknown column 'p.products_id' in 'on clause' SELECT s.status, s.specials_new_products_price, p.products_id, p.products_model, p.products_price, p.products_tax_class_id, pd.products_name FROM products p, products_description pd LEFT JOIN specials s ON p.products_id=s.products_id WHERE p.products_id = pd.products_id AND p.products_status = 1 AND pd.language_id = 1 ORDER BY pd.products_name [TEP STOP] Product Name Model Price