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` = 118) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Bottle Openers
Promotional Bottle Openers Practical Low Cost Business Promoters
An ideal gift to help promote your business has to be the promotional bottle opener. A handy and useful tool, everyone will be happy to receive one of your promotional bottle openers and will definitely make use of such a useful product.
The bottle openers we supply have enough space to highlight your business inexpensively compared to alternative advertising campaigns. Keep your business in front of your customer's nose with a promotional bottle opener and whenever your customer opens a beverage, be it at work or home, your company will be the first thing they see.
A campaign with promotional bottle openers can take many forms, from giving them to your employees as an incentive to mailing them to customers or potential customers to encourage brand loyalty. Whenever you give out a promotional bottle opener you are spreading your brand message and creating an exciting and innovative brand image.