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` = 51) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Paper Mate Pens
Paper Mate Pens Offer Quality & Smooth Performance As Standard
Renowned throughout the world as one of the leading manufacturers of quality promotional pens, Paper Mate have a enviable reputation for producing innovative and high quality writing instruments at affordable prices.
If you're is looking to buy promotional printed pens to help you promote your business the Paper Mate pens may just be the product for you. Avaliable in a wide range of options, the Paper Mate promotional pen may just lift you above your competitors with this renowned brand. IdeasByNet can provide you with ball pens, gel pens, mechanical pencils, stick pens and innovative multi-function designs matching any budget and business vision.
By associating your logo with such a powerful player as Paper Mate, your brand and corporate message is bound to automatically attract additional recognition and status with the recipients of the pens.