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` = 307) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Headphones - Advertising On The Go
An often overlooked promotional gift, Promotional Headphones can be a major brand booster for your next campaign. A promotional gift that everyone uses, and in this techological age, an accessory everyone needs. Choose from our selection above, which ranges from simple branded earphones, perfect for noise reduction, easily transportable and light, to full colour over-ear headphones, perfect for outdoor use, and which posses a huge print area for your logo.
Now that practically everyone has a iPod, or MP3 player, the offer of a new, well designed, beautifully branded promotional gift like this will be too good an offer for people to refuse, and what better way can you think of for getting your branding seen by thousands of people each day. Simply look around in the London Underground or busy city streets and you will see the reach your advertising could have. With branded headphones and personalised earphones, you could have your logo seen around the world.