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` = 185) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Organic Clothing
Eco Friendly Organic Promotional Clothing Creates A Greener Message
So, how would you go about taking clothing one step further, making it even better? Make it eco friendly and organic promotional clothing. For instance, get t-shirts make out of eco friendly organic material with your company's name and number on the front. Get a designer to come up with an interesting and original design and suddenly you have your customers doing your advertising for you. This type of promotion literally pays for itself because every time a person wears the shirt you gave away, they are encountering hundreds of potential customers. It really is marketing at its finest.
Eco friendly and organic promotional clothing is also a great way to send a message to people that you care about the state of the environment. People, especially now, will appreciate this view and see your company as more trustworthy than others who simply spend millions of pounds on television advertising. Make your mark by reaching people in a real way. Stop wasting your marketing budget and make it work for you.