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

Senator Pens

Why Use Promotional Senator Pens?

Senator are one of the world's leading manufacturers of promotional pens and quality writing instruments. Each pen is mould ed and assembled to exacting tolerances to ensure that they perform to the highest of standards. With state of the art printing facilities, your logo and brand message is imprinted using the finest quality inks. This combination ensures that your customers receive a truly exceptional marketing promotional gift and what's more at a great value price.

Senator also lead the way in terms of award winning patented designs and offer a variety of additional options including full 360? barrel printing, mix and match barrel, clip and grip choices and a fast turnaround to meet the demands of modern business. Quality of workmanship is also guaranteed so if for any reason you are unhappy any defective products are immediately replaced or repaired. To find out more about our range of promotional Senator pens, simply call one of our expert product advisors who are on hand to assist you every step of the way.