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` = 43) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Stemmed Glasses
Promotional Stemmed Glasses Make For Quality Business Giveaways
Promotional stemmed glasses are a great promotional gift for your clients and customers. These custom imprinted glasses will be useful for many years, meaning your advertising pound will be hard at work for a long time to come. Wine glasses are an item that won't be tossed into the bin as soon as you leave your client's office. On the contrary, if they don't end up at home they'll certainly be tucked away in the office for those special occasions. You can have your name and logo beautifully and tastefully imprinted and keep your business exposed ensuring that every time they are used your client will rememberyour business; whether conscious or not, you'll be getting name recognition.
Custom printed stemmed glasses will make a great Christmas giveaway when accompanied by a high quality bottle of wine or champagne. Special occasions can be remembered as well. It's entirely appropriate to present your gifts at a business or social gathering where you're entertaining.