» Home » All Products Categories Close Outs Engraved Items Gadgets Groomsmen Gifts Kitchen Cutlery More Categories -> Other Knife Brands Swiss Army Knives -> Zippo Lighters Repair and Parts -> View All Products -> All Products sorted by Categories -> All Products sorted by Manufacturers -> Information Privacy Policy Terms of use Gift Voucher FAQ Links Contact Us Quick Find   Use keywords to find the product you are looking for. Advanced Search New Arrivals Zippo Street Chrome $12.95 Who's Online There currently is 1 guest online. All Products 1054 - Unknown column 'p.products_id' in 'on clause' SELECT s.specials_new_products_price, p.products_id, p.products_model, p.products_price, pd.products_name FROM products p, products_description pd LEFT JOIN specials s ON p.products_id=s.products_id WHERE p.products_id = pd.products_id AND p.products_status = 1 AND pd.language_id = 1 ORDER BY pd.products_name [TEP STOP] Product Name Model Price