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` = 93) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC

Promotional Cooler Bags

Promotional Cooler Bags Are One Of The Most Useful Leisure Gifts

When it comes to leisure promo giveaways, nothing comes close to the utility and cost effectiveness of promotional cooler bags. Visit any leisure or outdoor activity centre and you will come across many people carrying custom imprinted cooler bags. The shear practicality and usability of these bags has given businesses in all sectors a unique opportunity to get their brand noticed among the wider population. The process is quite simple to follow; select stylish promo cooler bags which meet your budget requirements, custom imprint them with your corporate business branding and then distribute them to your customers and staff. Within a short period of time your brand will have wider recognition within your target market.

Available in multiple varieties, from a traditional approach to contemporary designs, cooler bags can be a brilliant promotional gift. With options to suit every budget and every marketing campaign, get in contact with one of our friendly account managers to discuss how these practical promotional products will help your campaign.