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

Promotional Sports Bags

Spreading Brand Awareness With Promotional Travel & Sports Bags

Promotional travel and sports bags are one advertising medium that will carry your message all around town and beyond. When you imprint your company or product name or logo onto these promotional bags it will be carried to endless destinations. It's a great way to gain visibility, and the imprinted bags make a top quality gift or incentive prize. They are built from sturdy materials, have handles, come in many styles and they look good and are highly durable.

Use within your company for motivation and sales rewards, or give as executive and corporate gift items. You can pack one filled with other promotional items for a deluxe gift package for special clients. There is plenty of advertising space on any of the bags. There are sports bags, travel bags, city sling bags, and all occasion bags. Choose from a number of popular styles, and start planning your promotional event. Custom printed promotional travel and promotional sports bags will be number one on the want list for anyone who sees them!