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` = 74) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
How To Use Promotional Drinks To Promote Your Company
Nothing's worse than investing marketing money in a promotional product that the consumer has no use for: that's why promotional drinks are a great choice! Your branded bottles of water, sports drink, or energy drink are sure to be used and appreciated no matter how you distribute them.
Personalised bottled drinks are an individual and unique promotional gift, and you can use them as a fantastic marketing tool. Hand them out at events for refreshments, keep them stocked up in your office or send them out in a hamper. People will always be happy to have a bottle of water or drink and this is a great way to get your brand message out there.
Ideasbynet.com offers many choices to customise your promotional drinks. Choose from several sizes, a variety of beverages and flavours, different cap types, and even eco-friendly bottles. The labels are fully customisable and sealed for durability!