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` = 154) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Vacuum Flasks
Promotional Vacuum Flasks Are Classy Executive Corporate Gifts
Vacuum flasks should be on your list of prizes in any employee incentive program. They make classy executive or corporate gifts, and you can have your company name and logo, or product identification engraved on the metal flasks. These are heavy duty promotional vacuum flasks, from reliable manufacturers like Langley, Aztec, Boston and others. Custom printed stainless steel flasks are the best way to keep hot drinks hot for a lengthy period of time, making them ideal for work or play, especially driving or camping. They are easy to clean and there is ample room for your engraved logo or name. Some include a durable carrying handle.
Promotional flasks are another great item to add to your marketing itinerary. Use them inside the company for rewards, and appreciation, or present them to new clients or valued customers as a thank you gift. They can be imprinted with your logo and are good looking and durable, so everyone will enjoy using them at home, work, or for travel and play.