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

Promotional Tote Bags

Promotional Tote Bags Allow Your Message To Travel

Custom imprinted tote bags are one of the best ways to promote your business or organisation. These low cost bags provide exceptional brand visibility, everywhere and anywhere. They are also a versatile product which you can hand out free of charge to your customers at conferences or trade shows. This may seem initially as a loss in profit, however think of how much it would cost to advertise everywhere that these bags are likely to travel. You could alternatively sell them and make a profit, either way you are on to a winner with these forms of promo items.

Utilising promotional tote bags creates a branding and marketing opportunity that can be fabulous for raising brand awareness. In today's society, people are always traveling around and with a promotional tote bag wherever they travel you brand gets a promotional boost. The benefits to a marketing campaign comprising of promotional tote bags are multiple; low cost in comparison to other marketing strategies and far reaching by the nature of the bag the use of a promotional tote bag can do wonders for your business.