Warning  Warning: I am able to write to the configuration file: /home/buttbego/public_html/store/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.
  Top » Catalog » Cigarette Disposal Units » Publisher -Disposal/ Advertiser » PUB8220 My Account  |  Cart Contents  |  Checkout   
Call Toll Free
1-888-863-2888
USA and Canada
Categories
Cigarette Disposal Units (28)
   Cigarazzi (2)
   Infinity Smoking Management (4)
   Butt Stop (2)
   Colonade Wall (1)
   Executive (4)
   Colonade Floor (1)
   Publisher -Disposal/ Advertiser (1)
   smokers outpost (5)
   GroundsKeeper Management (8)
Recycling Containers (37)
Litter Containers (204)
Benches (7)
Tables (8)
Cleaning (243)
Plastic Adirondack Chairs (4)
Material Handling (198)
Safety (33)
Syringe Disposal Unit (1)
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Shopping Cart more
0 items
Login

Email Address

Password



Forgot Password?
New Customer

What's New? more
Infinity Wall-Mount Smoking Receptacle
Infinity Wall-Mount Smoking Receptacle
$249.00USD
Tell A Friend
 
Tell someone you know about this product.
Reviews more
Write Review Write a review on this product!
Information
Shipping & Returns
Links
Privacy Notice
Contact Us
Affiliate Program
Affiliate Information
Affiliate Program FAQ
Affiliate Log In
1054 - Unknown column 'p.products_id' in 'on clause'

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price5,p.products_price6,p.products_price7,p.products_price8, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_price4_qty, p.products_price5_qty,p.products_price6_qty,p.products_price7_qty,p.products_price8_qty, p.products_qty_blocks, p.products_ship_price,p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship,p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = '915' and pd.products_id = '915' and pd.language_id = '1'

[TEP STOP]