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` = 146) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Sunglasses - A Walking Billboard For Your Logo
If you want a fun way to get the name out about a company, then you need to invest in promotional sunglasses. You can choose from a variety of styles and designs and can have everything from a company's logo to their name printed on the product. Promotional sunglasses come in a host of colour options and in classic shapes or even more creative shapes like stars and hearts. Custom printed sunglasses are not only a fun product to invest in, but they are also useful. If an organisation gives out thee accessories, they are something people of all ages and backgrounds can invest in. You can go with sleek shades or with more modern and bright ones. The key, of course, is to consider the image you want for your company and the kinds of people you want to target.
If you want a fun way to thank everyone from customers to employees, then promotional sunglasses are fun and creative way to do it. Once a person uses the sunglasses, the user becomes a walking billboard.