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` = 112) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Bar Runners
Colourful Promotional Bar Runners To Promote Your Brand
If you are going to spend your hard earned marketing pound on a promotional item, shouldn't it be on something that is going to get your message in front of the largest segment of your target market? Of course it should. So if your target market is in the growing beverage and hospitality industry, you can't do better than buying these colourful promotional bar runners. These custom printed bar runners are large and come in bold colours with your company name, logo, message, or motto printed in big letters to be seen by everyone that comes into the bar.
The hospitality industry is very competitive, so you have to keep your name in front of the customer and that is exactly what these promo imprinted bar runners are good for. Stretched across the front of the bar where everyone can see them, these bar runners are perfect promotional items for the bar trade. Don't waste your money on disposable products. These bar runners will stay in place for years promoting your brand and advertising message, so buy them today.