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` = 229) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Who doesn't use a stapler? The answer is everybody. That's why promotional staplers imprinted with your company name and logo are one of the finest promotional tools you'll ever use. The goal of a promotional product is to advertise, and the goal of advertising is to create a good association between your product and your customer. Staplers are useful items that have prominent visibility on a busy desk. If there's not a stapler right on the desktop then it'll be someplace else in the office where everyone can find it. A printed stapler is guaranteed to keep your name, phone number, logo, or web address right where your customer can see it. Advertising agencies charge millions to accomplish what a simple stapler can do.
Buy staplers in bulk and have your name imprinted in colourful contrast to the body of the stapler. Give the staplers away as small office-to-office Christmas gifts, included in shipped orders, or drop one off when you visit a supplier or customer. These are useful little promo items that can play a big role in your marketing plans.