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` = 89) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Trolley Bags
Let Your Brand Message Fly With Promotional Trolley Bags
If you are in search of a truly high quality business gift for your customers or employees especially if they are the globe trotting type, then why not consider our promotional trolley bags. These gifts are hugely practical, and the appreciation and loyalty that your brand will receive makes these bags worth careful consideration. Not only will you have highly satisfied customers or employees, having your logo and company message clearly visible on these bags make them a globe trotting mini billboard.
At Ideasbynet, we have put together a wide variety of promotional trolley bags all of which are manufactured by market leaders to exacting standards. The quality and durability of these bags means that your logo will be visible for years rather than months. Our range varies from traditional business class options through to modern and exciting designs. Whatever your message, your company will reach