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` = 39) group by p.`virtuemart_product_id` ORDER BY `ordering` ASC
Promotional Plastic Mugs
Plastic Mugs: More Popular Than Ever?
Our promotional plastic mugs are crying out for you to emblazon your brand across them. With the selection of vibrant colours avaliable and the versitility of their use, why not use promotional plastic mugs in your next marketing campaign? An acyrlic plastic mug is much more durable than a traditional pot mug, meaning they can be used by children and adults alike. Perfect for a school or youth charity giveaway, these mugs are less likely to break and the vibrancy of the colours avaliable withh be exciting for a younger audience and ensure your brand name is seen.
Plastic mugs are available in a fanstastic array of colour choices and styles, including metallic and glitter options and now our all new non chip recycled options, and at Ideasbynet we are constantly working hard to provide you with the best possible prices. So, why not give your business or organisations marketing a turbo boost and get your logo branded and personalised onto promo plastic mugs today!