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` = 192) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Work Shirts
The Benefits Of Promotional Shirts
Corporate promotional work wear is an important part of any company or organisations image. From every interaction with customers that meet your employees they will be able to gauge in an instant the type of business you are. Today, the majority of companies do provide their staff with some form of corporate apparel, either in the form of a full uniform or with work shirts or polo shirts. Promotional shirts represent an excellent way in which to get your company's brand message out there in a high quality, professional manner.
Promotional shirts can be custom imprinted with your logo or alternatively embroidered to create a high quality lasting impression with anyone who receives a shirt or sees the shirt. They represent one of the best ways to ensure your employees look and feel part of something special and at the same time act as a walking billboard for your business. Check out our extensive range of promotional clothing online or contact one of our specialists for further advice and information.