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` = 94) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Cosmetic Bags
The Perfect Beauty Giveaway Product - Promotional Cosmetic Bags
If you are in search of a classy way to promote your brand, and your target market is the female audience, then take a look at our range of promotional cosmetic bags. These bags are the perfect way to carry your brand advertising message to a wider audience. There are a couple of key reasons why you should consider using custom printed cosmetic bags for your next beauty related promotion.
Due to the nature of these products they are practical, mobile utility promo items and as such they are not a static giveaway which is restricted to one particular area, they will continually act a a mobile advertising billboard for your brand as they are carrier around and used on a regular daily basis. Moreover, if you pick a suitable quality promotional bag, the original recipient is more likely to use it frequently thus creating a wider exposure for your brand and making the initial purchase a far more cost effective one.