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` = 90) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Build Brand Visibility With Promotional Backpacks
Distributing backpacks as an advertising medium is a high effective way of increasing brand awareness. There are many promotional items on the market, however, there are few which offer the kind of visibility that backpacks do. Simply, because backpacks are mobile utility giveaways that are not static and restricted to one area, they continually act as a mobile billboard for your message. Additionally, the more the original recipient travels with their backpack the more exposure your branding receives and as such it makes them more and more cost effective.
Compared with other advertising methods that offer a similar return in terms of brand exposure, custom imprinted backpacks work out to be highly cost effective. A quality backpack may cost in the region of ?5, yet for that relatively modest sum, your backpack could be travelling around for months if not years acting as a mobile billboard for your business. This is why many companies are opting for backpacks to promote and advertise their products and services.