Used Computers and Services » Shop Downtown Toronto » All Products   Shopping Cart   0 Items  My Account     Cart Contents     Checkout    Currencies US DollarCND Dollar Information   Map & Directions   Services     Contact Us     Home Accessories Cables Cameras Cases Controller Cards CPUs Fans Flash Memory Floppy Drives Games Hard Drives Headphones Keyboards Media Memory Modem Monitors/LCD Motherboards Mouse Multimedia/MP3 Network Device Notebooks Optical Drive Power Supply Projector Removable Drive Removable Media Software Sound Cards Speakers Systems/Barebones Tape Back-up UPS VGA Cards Zip Drive    View All Items   Advanced Search 0 items 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, 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 = 2 ORDER BY pd.products_name [TEP STOP] Product Name Model Price