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` = 208) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Erasers Don't Overlook The Power Of The Small
Your company is a big deal. Yet more often than not, the smaller the promotional item, the bigger a statement it can make. This is true in the case of promotional erasers and rubbers. When a company utilizes its brand or logo on small items, it speaks of their attention to detail. The impression it gives is, "Wow, this company is detail-oriented and professional, so much so that even these erasers have their logo imprinted on them." Don't overlook the power of the small.
Custom printed erasers are perfect for companies that use erasers on a routine basis. Some ideas are waiting areas where customers, patients, applicants, etc., fill out forms. For example, they can be put to good use in a travel agency, a doctor's office, or anywhere that customers are using pencils. Erasers are also easily distributable to employees, and clients. Using imprinted erasers and rubbers to make a statement about your company, and doing so with a bit of style or flair, is a low cost, value way to make a big advertising statement.