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

Promotional Business Card Holders

The Advantages of Promotional Business Card Holders

As giveaway products go, promotional business card holders are both a cost effective and efficient way of saturating key demographics with your company message. While some promotional products advertise only to the direct recipients of your products, business card holders and wallets are displayed in prominent places and have the potential to advertise to a large number of prospective customers.

Distribute your promotional business card holders, complete with your brand message, to prospective and current customers and see how they can help your business grow. You can have your company logo and contact information printed clearly on your business card holders, so that any interested parties can contact you for more information. As these business card holders are a brilliantly functional gift, the recipients are likely to be exceptionally grateful for the gift which will increase their loyalty to your brand.