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` = 127) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC

Promotional Golf Balls

Golf Balls - The Ideal Gift for Corporate Golf Days

Custom printed promotional golf balls are an absolute must for any golf day, and they remain the best selling golf gift on the market. Why let your clients and guests use their own balls when they could be shooting a round with balls with your logo on? And if they're any good, they might even have some left at the end of the round!

As a promotional item, it is hard to find a more cost effective promotional golf gift, as the re-use value is so high. If you give someone a pack of Titleist or Callaway balls with your logo on, you can guarantee they'll be considered in high esteem by your client and re-used for future rounds. More importantly, when they are re-used it'll be your logo or promotional message that will be used as the differentiating factor, so you'll get some extra publicity with every round!

High quality promotional golf balls represent a gift that, to the golf enthusiast, will never be fogotten. Along with golf course branding and prize table items, they are an essential part of marketing kit for your corporate gof day. As a standalone gift to select clients, they offer a dozen great ways to remember your brand.