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` = 137) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Make Up Mirrors
Promotional Make-Up Mirrors Are The Fairest Gift of Them All
Promotional make up mirrors are a brilliant promotional item that you can use for advertising. They appeal to all people, but especially to the ladies who like to carry a small mirror in their bag. There are several styles, including one with an inset LED light which is a very handy little product! Others are nestled in velvet pouches, and some are available in bright colors. All affordable and excellent presentation gifts with your company name or logo printed on the cover.
There are many items that you can choose for sales promotions, and personal care products are a good alternative to the standard pens and pencils or other choices one usually sees at events. A mirror reflects upon the giver also, and quality promotional make up mirrors with your design or message printed on them shows that your company can go beyond the normal steps to do something special for their customers. The thoughtfulness should result in goodwill and more sales. Make your company the fairest of them all with this unique gift item.