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` = 244) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Recycled Mouse Mats
Get The Word Out About Your Business With Recycled Promotional Mouse Mats
Recycled mouse mats are a great way to get the word out about your business. Mouse mats are something everyone uses and if you use mats made from recycled materials, you're not only giving a useful gift but one that is eco-friendly as well. Regardless of how important you think the ecological welfare of the planet is, many of your clients and customers will undoubtedly see the subject as one that demands attention. Recycled printed mouse mats are one small step towards ecological responsibility and your clients know it. They'll appreciate your sensitivity as well as receiving recycled promotional mouse mats that will be right in front of them on a daily basis.
Promotional items are designed to get your name, website and logo into the spotlight. How much closer can you get than your customer's desk? Every time they use the computer they'll think of you. Have your information imprinted on the mats and give them to your customers as gifts. When it's time to do business, your name will be first on the list.