Top » Catalog » All Products My Account  |  Cart Contents  |  Checkout   
Catalog
Cufflinks
Fuel/Flints
Gift Sets
Zippo->

 

View All Products
What's New?  more
Black Leather 6oz Deluxe Flask Gift Set
Black Leather 6oz Deluxe Flask Gift Set
$39.99
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
Downloadable catalog
Printable Catalog
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
All Products
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 Model Manufacturer Price