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

Promotional Appointment Card Holders

Why Printed Promotional Appointment Card Holders Make Good Business Sense

In the current economic climate, price is a key factor in every purchasing decision. However, price cannot continue to dominate in the long term as companies seek to differentiate themselves from the pack. Forward thinking businesses will realise that a focus on customer service is crucial to any long term goals. Emerging social media platforms such as Facebook and Twitter will help businesses engage with their customers more readily on a day-to-day basis, and customers will begin to expect the sort of 'local' service that our grandparents used to provide.

Simply launching an ad campaign, ramming your message down people's throats through direct marketing and push messages, will no longer be sufficient. It will become imperative to listen to your customers, to respond and engage in a much more traditional manner. Customers will need to feel special, and delight at receiving the perfect promotional gift. But further to this, it will no longer be suitable to simply phone or email clients - the expectation will be to go and see your clients, and that is where promotional card holders come in. If businesses are going out there trying to get new clients, why not do it with your logo sat in front of them?