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` = 162) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Balloons Are One Of The Best Marketing Tools
Promotional balloons can be an excellent marketing tool, especially when used in conjunction with other promotional items. You can use custom printed promotional balloons as giveaways during special events, business conferences, during an "open house", at a trade fair... there are so many ways you can use them to convey your marketing message!
Personalised balloons are inexpensive, yet effective advertising tools. Primarily, this is due to the eye-catching nature of them; most balloons are brightly-coloured, so when printed with your business name, logo or product name they will make you stand out in a potential customer or client's mind. If you have an event planned, and you will be hosting a stall or stand, why not invest in some low cost bright balloons to make your company really stand out?
Promotional balloons are fun, eye-catching and nostalgic, and, because they are inexpensive,