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

Promotional Weather Stations

Turn Your Marketing Campaign Up A Notch With Our Promotional Weather Stations

When you're looking for winds of change in your promotional strategy, why not turn up the heat with a promotional weather station? Weather stations are ideal business gifts for their innovation and usefulness. People are always curious about the inside temperature, about the outside temperature, and other tidbits of weather facts. Satisfy the curiosity, meet the need, and obtain a strikingly expressive way of promoting your brand.

Custom printed weather stations are effective for any company, but in particular they are brilliant for companies involved in anything outdoors; clothing or apparel companies, and recreational outdoors businesses in particular. Since weather is a global concern, any company will benefit from a promotional weather station. A key thing to think about when choosing promotional items is to pick something that people will look at on a regular basis. This is most definitely the case with a promotional weather station. People will constantly find themselves checking the temperature and inadvertantly catching sight of your logo.