» Home » All Products Categories AC Adapters -> Batteries -> Batteries-Accessories -> CD-Floppies -> Chargers -> Docking Stations -> Hard Disks -> Keyboards -> Kits -> Lamps -> Other -> PCMCIA -> Power Supplies -> Toner Cartridges -> USB Accessories -> 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 IBM Thinkpad CD-ROM Drive $79.00 Featured Adapter Compatible with Dell $0.00 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