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` = 121) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Candles Will Light Up Your Marketing Campaign
Promotional candles and incense gifts can create interest in an event, and can be a real traffic builder when presented in conjunction with a sales event. Scented, fragrant candles and incense have their own aura of romance and mystery. They make a nice little gift that is very affordable in quantity; they can be used at large events as well as smaller affairs.
Colourful and sweet smelling, our candle range includes best sellers such as cinnamon and vanilla. These promotional candles and incense gifts can be given as appreciation gifts, or as incentive rewards for employee motivation programs. Add a snappy slogan and sell them for profit in your store or boutique. Everyone enjoys a lightly scented candle to perfume the air, therefore promotional candles are one of the best loved items on the market. Take advantage this popularity and use them to promote your company as well.