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

Promotional Leather Keyrings

Promotional Leather Keyrings As Corporate Gifts

Having contented and happy customers is a key desire for any business whether small or large. The majority of businesses always aim to portray a good impression and leather keyrings can go a long way in helping to achieve this. Imprinted leather keyrings are one of the most favoured choices amongst the wide range of corporate gifts that are available on the market. They are highly practical, come in a vast range of options, easy to handle and best of all used on a daily basis.

The impact printed leather keyrings is not only from the variety but primarily from the corporate details that are printed or engraved onto them. With an excellent imprint area you can have a range of corporate details such as your logo, telephone number and web address printed or laser engraved on them. At Ideasbynet we have a wide selection of keyrings to choose from including low cost plastic, promo metal and high quality leather keyrings - so what are you waiting for, give us a call or drop us an email, and get promoting your brand in this highly cost effective way today!