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

Promotional T-Shirts

Promotional T-Shirts Really Do Move Your Message

Custom imprinted t-shirts are without doubt one of the most popular promotional items of all time. Unlike the masses of other giveaways such as pens, mouse mats and desktop gifts; t-shirts are always on the move - literally. There is no doubt though that pens, mugs and similar product lines provide excellent exposure for your business but if you are looking for a product that provides a greater exposure then printed t-shirts are clear winners.?

Another advantage to choosing promotional t-shirts as your promotional giveaway is the lower minimum quantities that they can be ordered in. They are also available in a massive array of colour choices and styles so there will definitely be one to compliment your company. The ultimate reason for purchasing t-shirts is that once branded and distributed the recipients act as a walking billboard for your advertising message. There are few promotional items that create such value simply from being worn. Custom printed t-shirts will never stop providing excellent promotion on your behalf until they are, quite literally, worn-out!