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` = 38) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Glass Tumblers
Promotional Glass Tumblers Break The Ice
Here's a great idea for how to shake up your next investment dinner meeting. Have a whole bunch of promotional glass tumblers created and as everyone is making their way to the table, give it to them. Then have the waitress bring ice and present a fine bottle of liquor for everyone to pass around. What better way is there to break the ice?
Businesses are slowly realising that in order to succeed in this tough economic landscape, you've got to invest more money into pleasing your customers. They must get the feeling that you are essentially taking care of them like you would do with family. This makes all the difference when all is said and done. They wouldn't sell family stock, so why would they sell yours? Custom printed glass tumblers are a great giveaway to let people know that you understand them on a more personal level and you appreciate who they are. You will quickly win your way into the hearts and minds of investors and customers everywhere, and you'll have a good time doing it!