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

Promotional Ice Scrapers

Nothing Gets It Clearer Than Promotional Ice Scrapers

When it comes to cold, hard commonsense, nothing gets it clearer than promotional ice scrapers. These powerful and handy tools quickly become your best friend when nasty winter weather hits. In fact, you may have been in one of those unfortunate circumstances where you didn't have an ice scraper, and you squeaked through the situation with a mangled credit card. An ice scraper is a far better alternative, not only for the convenience of getting your car ready, but also for the advertising opportunity that it provides for your company. These essential tools are perfect for displaying your logo.

Custom printed ice scrapers can be used very strategically. For example, perhaps your company provides car-weathering services. If a customer is using a free ice scraper you gave away, chances are, they will be thinking about getting their car weatherised. As a potential customer scrapes a layer of snow off of his windscreen, the scraper may make them yearn to be playing in the snow rather than scraping it off their car. Use the gift in a smart way, to target potential customers.