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

Memo Holders

Incorporate Promotional Memo Holders Into Your Next Marketing Campaign

For a successful promotional campaign, it's important to choose a product that is both useful and visible. Custom printed memo holders are a great choice because they embody both of these qualities. Anyone with a desk will have a use for a memo holder, and their placement on the desk top means your company logo stays clearly in the public eye.

Memo holders also have the advantage of being highly customizable, so that you can be sure that the product you design is an accurate reflection of your company's aesthetic. You can choose from a range materials in a wide range of colours. Your company logo can be printed directly on to the holder. You also have the option of expanding your promotional memo holder to hold pens or other desk objects, and have the option of imprinting the paper with your corporate logo as well. With all the options available in this category, there is a choice to fit any budget, however, even the fanciest choices are very affordable. At these prices, you can't afford not to incorporate memo holders into your marketing campaign!