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` = 41) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Shot Glasses
Promotional Shot Glasses Tip The Glass Of Success Your Way
Promotional shot glasses are one way to put your ad message out there in a big fashion. Use Boston small or large shot glasses or Vodka glasses with your company imprint as gifts for employees, clients, new customers, or general audiences at shows or conventions. These are unique and useful gifts that will be snapped up immediately as you put them out.
Shot glasses come in range of sizes and are sparkling clear, and can carry your brand or imprint easily. Put your name in your customer's hand, and as they use the shot or vodka glasses, they will absorb your name or message just by looking at the glasses. The custom printed shot glasses are as affordable as any other promotional item. If you are looking to find a new and different promotional item, consider using imprinted shot glasses. Tip the glass of success your way with imprinted promotional items at your next marketing event. Use shot glasses and better the competition with your foresight and creativity. People will love them!