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` = 189) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Polo Shirts
Promotional Polo Shirts Make an Impression
Promotional Polo shirts are one of the most popular promotional gifts available. Regularly used at exhibitions, promotional events or sent out to customers as a durable and useful gift. Why not purchase promotional polo shirts for all of your staff members? They will be grateful for the gift and your company will receive great exposure. Polo shirts can be embroidered or imprinted and come in a number of colours and designs.?
IdeasByNet is the UK's leading supplier of promotional polo shirts and other items of clothing and we have a high quality range of polo shirts on which you can apply your advertising message. Our polo shirts have been manufactured by leading brands such as Slazenger and US Basic therefore your company will also be linked with these high quality names and hence gain prestige through this association. Get in contact and one of our specialist clothing account managers will be able to help you find the best quality polo shirts to suit your budget and brand.?