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

Promotional Pencils

Reasons To Use Promotional Pencils

Why should you use the promotional pencil? Well, there are countless reasons that a promotional pencil could be the best gift to promote your business. Custom promotional printed pencils are proven to be brilliant for numerous promotions, creating lots of brand awareness and they could very well do the same for your campaign. We have seen a definite increase in the popularity of the promotional pencil as a promo product. Pencils are not only cost effective but are extremely widespread in their potential advertising reach, from children scribbling a few words or drawing to top level executives jotting down notes in a board room meeting.

The cost-effectiveness of the promotional pencil means they are possibly one of the ultimate promotional gifts. Like the promotional pen, any writing instrument will be used consistently by your customers ensuring you will receive maximum exposure. At IdeasByNet we have an extensive range of printed promotional pencils have a browse through our online catalogue or speak to one of our expert advisors for more info.