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` = 180) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Pen Pots Get Your Logo Up Front On Your Customer's Desktop
Looking for a promotional gift that will really catch your customer's eye? Why not consider the promotional pen pot. Available in a vast array of styles and bright primary colours, promotional pen pots are sure to be the best promotional gift to draw eyes to your logo and slogan. Always needed on a desk to prevent your pens being scattered about your desk in disarray, why not print your logo on pots that will become a prominent feature on your customer's desk! Check out our range of promotional pens and fill your pen pots with your own branded pens for maximum exposure.
Your message imprint will stay in view a long time on these promotional pen pots. You can distribute them at the office, or use them for advertising gifts at trade shows, conferences, or meetings. Imprinted pen pots help organize the office and keep track of pens and pencils, which is always a good thing to have at the office or home office but also act as a great vehicle for promoting any business or organisation.