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` = 33) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Beer Glasses
Promotional Beer Glasses Connect With Your Customers
If there's one thing that potential customers would enjoy receiving, it would have to be promotional beer glasses. Many people collect beer glasses and are always looking to expand on that collection. In this way, beer glasses with your company's logo on them are a perfect giveaway. The way to find new customers is to really connect with them on an individual basis. You want to go out and market yourself because your company is worth it. Plus, you will spend a fraction of the money it takes to put out a television ad, but you will be twice as successful at reaching new customers.
Custom printed beer glasses are quickly becoming one of the favourites of companies all over the nation. Give your company the edge you've been looking for by creating and handing out this wonderful keepsake that people will keep for years to come. As far as advertising goes, this is a sure thing. Gather your employees and let them know that you are going to do something more effective this year and hand out imprinted beer glasses.