SELECT SQL_CALC_FOUND_ROWS * ,LEAST(IF(price1_1 > 0, (price1_1 * (1-(discount/100))),9999), IF(price2_1 > 0, (price2_1 * (1-(discount/100))),9999), IF(price3_1 > 0, (price3_1 * (1-(discount/100))),9999), IF(price4_1 > 0, (price4_1 * (1-(discount/100))),9999), IF(price5_1 > 0, (price5_1 * (1-(discount/100))),9999), IF(price6_1 > 0, (price6_1 * (1-(discount/100))),9999)) AS priceMin FROM `jos_virtuemart_products_en_gb` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `jos_productPrices` ON p.`virtuemart_product_id` = `jos_productPrices`.`product_id` LEFT JOIN `jos_productDetails` ON p.`virtuemart_product_id` = `jos_productDetails`.`product_id` LEFT JOIN `jos_virtuemart_product_categories` ON p.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `jos_virtuemart_product_categories`.`virtuemart_category_id` WHERE ( p.`published`="1" AND `jos_virtuemart_product_categories`.`virtuemart_category_id` = 136) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC

Promotional Maglites

Promotional Maglites - The Torch Of Choice

Maglites have taken over the world as the torch of choice. They are ultra-light, they are unbelievably watertight, coated with a hard metal finish, boast incredible power, totally shock-proof, shockingly durable, nearly everlasting, and they are plain cool to have. For these reasons (and more) promotional maglites are a perfect item on which to promote your brand identity. Any logo goes perfectly with the and appealing feel of the Maglite.

Custom printed maglites also come in a variety of sizes. Based on your budget and need, you can select a Maglite that is as long as your forearm or small enough to go on your keychain. Using a torch to promote your brand identity is a smart move, regardless of how you look at it. The torch is one of those ultimately practical items that you need in your car, in your office, at your home, besides your bed - nearly anywhere. The pure functionality of the item, coupled with the fact that it makes a great gift makes it an ideal candidate for a promotional item.