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

Promotional Letter Openers

Promotional Letter Openers Smart & Effective Business Promotion

Letter openers are a promotional item that will be used countless times. Everyone uses a letter opener. The alternatives to a good letter opener are scissors: hard-to-find and a hassle to use; or your fingers: totally clumsy and ruinous. A letter opener is by far the best alternative, and what better letter opener to use than one bearing your company name and logo?

Promotional items come in a variety of forms and sizes, but using your logo on something as unobtrusive and simple as a letter opener is a savvy choice. People find themselves reaching for the letter opener on a daily basis. It's used over and over again to open letters, open bills, and every other option. Doing this daily routine with a letter opener that bears your name is a perfect way to keep the presence of your business always at the fore. Letter openers are not a pricey investment. At pennies each, they are a gift that can be used en masse, and is timeless enough to disregard the occasion for giving it. Custom printed letter openers are a smart and effective way to promote your brand.