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

Promotional Travel Accessories

Promotional Travel Accessories The Welcome Giveaway

If you are looking for a unique promotional giveaway, promotional travel accessories are a fantastic way to go. Enjoyed by students, executives, men or women these gifts are brilliant to raise your brand awareness. Complete your gifts with you company name and logo and you will receive brilliant exposure. There is always a need for promotional travel accessories, even if someone's travel is just across town to a friend's house for an impromptu visit.

You can brand for added name exposure, and bring in new customers with these gift items. There are custom printed travel kits, hair brushes, shoe shine kits, travel toothbrushes, reflectors, personal travel kits, travel fans, and electrical adapters. If possible, tie in your promotional gifts with a special occasion, for example the new opening of a hotel or a conference that people will have traveled for and be staying overnight; that extra touch will really endear your company to your clientele.