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` = 56) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Prodir Pens - Swiss Made Writing Instruments With A Personality
Prodir pens are one of the most recognised brands in their class when it comes to promotional pens and for good reason these stylish pens are both dynamic, clearly functional and cost-effective. For under a pound, you can have a high quality pen customised in terms of colour and your logo and brand message imprinted on the pen. Not only that, Prodir personalised pens from Ideasbynet exclusively, are also available with a high-gloss, full process colour printed presentation box to hand out your pens in to your customers and business associates.
So, if your business or organisation is in search of a stylish and cost effective way of promoting your message you need not look any further than custom printed Prodir pens. Our dedicated team of corporate gift specialists will assist you in every step of the way, and with highly skilled graphic designers we will help you to create a promotional pen which will serve you well and advertise your company in a truly eye catching and memorable way.