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` = 50) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Novelty Pens
Novelty Promotional Pens Make Your Brand Stand Out
If you are looking to get your logo and brand noticed in a cost effective way then why not take a peek at our wide range of novelty promotional pens all of which can be custom printed with your details. Novelty pens emblazoned with your logo are a cost effective form of marketing and advertising that is guaranteed to get noticed easily. Manufactured in a wide range of bright colours and unique shapes they attract instant interest with anyone coming into contact with them. Pens are a great addition to any marketing strategy, low cost and efficient, they provide for a practical medium of advertising that virtually writes new orders for your business.
Whether it be promotional pens with an integrated tape measure, bottle opener or ones which feature a carabiner or scrolling message area, with our expansive selection, budget busting low prices and unparalleled customer service at Ideasbynet you have found the perfect partner.