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` = 130) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Heat Packs
Give Your Customers A Warm Feeling With Promotional HeatPacks
Looking for a creative alternative to the usual promotional gifts? Are you sick of the standard same old gifts that every company uses? It's time to consider a creative alternative. Try promotional heat packs. Although it sounds bizarre at first, heat packs are actually a very strategic means of promoting your brand. Custom printed heatpacks are extremely useful and are the perfect solution for an aching muscle or for a sore spot on your body. Warm the heat pack in the microwave to a comfortable temperature, and carefully press the heat pack against your sore spot. The localized heat virtually dissolves sore backs and soothes sore and aching feet.
The fact that a heat pack can bear your company name and logo makes it an appealing alternative to the customary cadre of promotional items that are so prevalent in offices and business. This is one promotional gift that is sure to make your business stand out, an give your customers a warm feeling about your company.