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` = 35) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC

Promotional China Mugs

Why Use China Mugs To Promote Your Business Or Organisation?

Custom printed promotional china mugs are without doubt a cut above your normal promo mug. Manufactured to exacting standards they are the perfect way in which to portray a quality reflection of your business. Corporate blue chip organisations, big or small, and across all vertical markets use such mugs at some point or other to push their latest products, services or simply to raise that all important additional brand awareness.

Why should you use china mugs? Simple, it is because of the various benefits offered by these mugs over other such items. Unlike other promotional products, a mug can be distributed for a small budget, yet due to their very nature they continue to promote your logo, brand and advertising message for months if not years to come. Not only do Ideasbynet offer the high end fine bone china mugs but we also supply a massive range of other options including ceramic earthenware, plastic, travel and glass, so with us you are assured of sourcing the right product for the right budget.