Duke City Cigars
Home » Catalog » All Products My Account | Cart Contents | Checkout
Product Categories
Cigars (Singles) (557)
Cigars (Boxes) (566)
Cigars (Bundles and 2nds) (85)
Cigars (Small) (93)
Cigars (Sampler Packs) (15)
Humidors (24)
Lighters-> (8)
Cigar Accessories (47)
Pipe Tobacco (29)
Pipes (3)
View All Products
Cigar and Accessory Brands
What's New? more

Oliva Serie "V" Lancero, 7 x 38, box/36
$162.99
Quick Search
 
Find products using keywords or try an
advanced search.
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Gift Voucher FAQ
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 Price