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

Plastic Keyrings

Promotional Keyrings Are Tremendous Marketing Tools

Promotional keyrings are a classic promotional item and not without reason. Affordable and practical, a promotional plastic keyring featuring your promotional message will travel far and wide on your customers keys. From traditional styles to new creations keyrings will always be a favourite promotional product whatever variety you choose. From traditional square keyrings to a variety of newer innovative keyring designs, including carabiner clips and funky stress toys, IdeasByNet has the lot!

Add your imprint, ad or company name to the keyring, and pass them out by the hundreds at shows or conferences. Sports events, meetings, and other large gatherings are all places you can take advantage of promotional keyrings.. Plastic keyrings will last, and your ad will be seen every time someone picks up their keys. What more important accessory is there for the active person than a nice, attractive keyring? Everybody hates losing their keys so a good keyring has become a necessity. It is fun to have a new keyring sometimes, so promotional keyrings are always a good marketing choice