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` = 110) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Air Fresheners
Promotional Air Fresheners Blow Fresh Air Into Any Marketing Campaign
Do you need a cost-effective promotional gift for a future marketing campaign? Promotional air fresheners are a versatile and low cost option, perfect for any marketing campaign. Cheap to buy, you could mail them out to your customers or include them in goodie bags at trade shows, exhibitions or even on street giveaways; personalised air fresheners are great for any company with a smaller budget that really wants to pack a punch with their promotional gifts.
We offer an array of shapes and sizes; choose from our standard designs and colours or create a completely bespoke design that will really capture the essence of your company. Our friendly account managers are available and ready to help you find the right promotional air fresheners for your brand. Get in touch and we will get the ball rolling on your next promotional campaign!