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

FotoSmart Umbrellas

Create A Show-Stopper of A Promotional Campaign With A Total Print Covered Umbrella!

Are you looking for a vibrant, exciting promotional gift for you latest campaign? Look no further than a total print covered umbrella! The huge print area afforded by promotional umbrellas provides an exciting canvas for printing and a platform to really showcase a brand to its full potential. Apply print to the entirety of your brolley and watch your logo come alive with our vivid printing technology!

A total print covered umbrella is not only a brilliant show stopping, vibrant promotional gift, it is also a practical and long lasting option. Everyone needs a good umbrella and your customers will be forever grateful to a company that has provided them with sturdy and attractive brolley. The eye-catching nature of a total print umbrella will also draw attention from anyone who walks by, meaning maximum exposure for your brand message.