» Home » All Products Categories Art/Media/Performance -> Auto -> Business/Services -> Computer -> Electronics -> Fashion -> Food/Beverage -> Gifts/Specialty -> Home/Family -> Personal Care -> Sports/Outdoors -> Toys/Games -> View All Products -> All Products sorted by Categories -> All Products sorted by Manufacturers -> Information Privacy Policy Terms of use Gift Voucher FAQ Links Contact Us Quick Find   Use keywords to find the product you are looking for. Advanced Search New Arrivals US Air Force Gold Plated Money Clip $7.80 All Products 1054 - Unknown column 'p.products_id' in 'on clause' SELECT s.specials_new_products_price, p.products_id, p.products_model, p.products_price, 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