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

Promotional Umbrellas

Why Choose Promotional Umbrellas For Your Outdoor Business

If you're considering different advertising methods and you have an outdoor business, why not take a look at our extensive range of promotional umbrellas to help advertise your company's products or services. With the use of custom printed items, your business can grow in different ways and entice new clientele - when you put the word out about your company's products or services, you will bring in new business and increase company growth.

An outdoor business can especially benefit from the use of promotional umbrellas; give them out as sales incentives or as part of a promotional campaign. Distribute umbrellas complete with your logo to your clients or at local charities or events your company helps sponsor to get the word out about your products or services. When you give promotional gifts that are useful, clientele or potential clientele appreciate the gesture and remember your company as you have shown your care about their needs.

Of all the promotional gifts available, a printed umbrella probably gains the most appreciation, especially in England! So get ready for the inevitable downpour of business with printed promotional umbrellas.