Welcome Guest! Would you like to log yourself in? Or would you prefer to create an account?
northtexascopier.com www.NorthTexasCopier.com
1423 Stagecoach Dr. - Richardson, TX 75080
Email: jestep@NorthTexasCopier.com
 US: 1-800-719-4736
Local: 214-725-3393
Fax: 972-803-4107
 AMDG
Categories
Manufacturers
What's New? more
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information

Canon

 Canon
Mid-Production B&W Printers
Mid-Production B&W Printers		 Desktop Laser Beam Printers
Desktop Laser Beam Printers		 Home/Small Office Desktop Printe
Home/Small Office Desktop Printe
Large Format Printers
Large Format Printers		 Specialty Printers
Specialty Printers
1054 - Unknown column 'p.products_id' in 'on clause'

SELECT distinct p.products_id, pd.products_name, p.products_image, p.products_tax_class_id, pd.products_description, pd.products_short, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '474' and p.products_status = '1' and p.products_featured = '1' order by rand() DESC limit 3

[TEP STOP]