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` = 115) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Focus Attention On Your Brand With Promotional Binoculars
When deciding where to spend your marketing or advertising budget, it is not about what is cheapest, it is about what is the most cost effective and what will get you the most return on your investment. So instead of buying a lot of cheap items that will just end up in a junk drawer, you want to spend it on something that will get your name in front of the right person and make sure you are remembered. That means, spending it on high quality items such as our selection of custom printed promotional binoculars.
These stylish and trendy imprinted binoculars will be kept handy and used by whoever is lucky enough to receive them. They come in a variety of styles and prices to fit any advertising budget. You can buy them in quantities as few as fifty, but once you see how effective they are as marketing items, you will want to buy many more of these binoculars. The next time you are looking for a great marketing or giveaway item, take a look at these fantastic high quality binoculars.