Home » Catalog » All Products

My Account  |  Cart Contents  |  Checkout

Categories DREAMCAST GAMEBOY GAMECUBE NEOGEO POCKET NINTENDO 64 PLAYSTATION 1 PLAYSTATION 2 SEGA GENESIS Wii XBOX SNES All Prices Recently Viewed 01. Kelly Slater's Pro Surfer 02. 2002 FIFA World Cup Quick Find   Search our store Advanced Search What's New? Star Wars Trilogy: Apprentice of the Force [GBA] $21.47 Information Shipping & Returns Privacy Notice Conditions of Use Contact Us Gift Voucher FAQ Affiliate Program

All Products 1054 - Unknown column 'p.manufacturers_id' in 'on clause' select p.products_id, p.products_model ,pd.products_name, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p , categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name [TEP STOP] Product Name Manufacturer Price