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` = 117) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Bottle Chillers
Make Your Event The Hit Of The Season With Promotional Bottle Chillers
For a new and novel sales edge, use promotional bottle chillers at your next marketing or sales event and watch the people come running! Bottle chillers are a fantastic way in which to chill up a nice bottle of wine or liquor. They are insulated, and filled with gel that you can pop into the fridge freezer to get them ready for use. Once frozen, they are still flexible, and you take them out and slide over the bottle to keep the bottled liquid nice and chilly. You can reuse the chiller by freezing them again and again.
These custom printed bottle chillers are tastefully cute, and almost look like little shirt covers, and they offer a great big space upon which to place your advertising message. Imprint your logo, product information or company advertising message and it will be seen over and over, as the bottle chiller is reused. Choose a solid background shirt style, or a clear fluted cover. Order by the 100s; printed bottle chillers are very affordable. Your event will be the hit of the season!