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

Promotional Luggage Tags

Let Your Brand Travel With Promotional Luggage Tags

When choosing a marketing product to get your name in front of clients and potential customers, you need something that is inexpensive, yet effective. Most important, you need something the client will keep and use. In addition, if the product not only gets your name in front of your clients, but is exposed to other people as well, this makes the product even more attractive. And no product does all this as well as promotional luggage tags. Luggage tags are something everyone needs and uses, not only on their suitcases and garment bags, but carry-ons, computer cases, briefcases, and sample bags.

Giving out custom printed luggage tags with your company name imprinted on them, will put the name of your business or organisation in front of a lot of people for a minimum of cost. And because of the nature of who does the most travelling, it gets your name in front of business people, executives, and decision makers. And isn't that who you want to market to? For the most marketing bang for the pound, you need to buy promotional luggage tags.