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

Balmain Pens

Balmain Pens A Distinctive Corporate Gift

If you are looking for a high quality corporate giveaway for your customers, business associates or employees then look no further than a Balmain pen. These pens are amongst the highest quality we have to offer. If your aim is to impress, then this brand should definitely be your first choice for a superior promotional pen. They are manufactured to the highest of tolerances, and can be either screen printed or precision laser engraved with your brand logo. These pens represent the ultimate in form and function.

Balmain are recognised throughout the world as one of the market leaders when it comes to high quality, sophisticated writing instruments and our range represents the most favoured selection. Promotional pens that score high on quality speak volumes about the class and superior taste of your company and a Balmain pen represents this perfectly. When given as a corporate gift, these high quality promotional pens are sure to get the recipient talking about the generosity and sophistication of your business or organisation.

For additional information, simply contact one of our products advisors who are on standby ready to assist you.