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

Memo Blocks

Promotional Memo Blocks Fun Advertising For Around The Office

Promotional memo blocks are a fun item to present to customers and clients, and to use within the home offices, and everyone needs one. These are just right for adding your imprinted message to, either on the top, sides, or both. There are die cut imprinted memo pads that come in various shapes, spiral blocks and wedge blocks, in addition to the standard square memo blocks.

Imprint on the top of the papers in the block to keep your message visible for the life of the block. Add your message or image on the sides for colourful and attractive advertising that is within an arm's length of the user at the desk. Quantity of sheets in each block will vary according to block height, but many are 750 to 1000 pages deep. It is a novel and very fun way to get your advertising message into the public eye and keep it there. Promotional memo blocks are always in demand, and people will grab one if they have a chance. It's a great way to advertise!