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` = 49) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Multi Function Pens
Multi-Function Pens Are Practical Promotional Gifts & Great For Branding
Promotional pens are quite probably the most popular business gift of all time, yet sometimes a standard promo pen just won't cut the mustard for a special campaign. For example, teachers and doctors often have to make use of multiple pens to ensure they document everything with the right colour ink; this is where the multi-function pen comes in! Why not use your marketing or advertising budget to target these particular people and provide them with a useful product that will be brilliant for their circumstances.
Custom imprinted and emblazoned with your logo and corporate branding, multi-function promo pens featuring a number of different ink colours will go down a storm. Such writing instruments are practical utility items which serve the purpose perfectly of the recipient and as such your message will receive far more attention