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` = 40) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Recycled Plastic Mugs
Promotional Recycled Mugs To Get Your Eco-Friendly Message Noticed
You can trust that custom imprinted recycled promotional mugs are a great way to get your eco-friendly message across. Not only are you giving customers something that they will be able to use, but you are doing so in a way that says that you care about the environment as well. Environmental issues are one of the hot-button topics of the day and are quickly becoming commonplace. By showing you care, you are allowing your customers to trust you more wholeheartedly. Plus, every time they use the recycled printed mugs in the morning, they will view your company's name and phone number making the chance that they will choose to use you eventually very high.
Businesses are looking at what works and what doesn't in marketing. Now, more than ever, the main accomplishment will be reaching out to people in a way that is real. Billboards and television commercials are not real. Go down on the street with your promotional recycled mugs and start talking to people today.