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

Get Quote fixed at Live Price

  • Product: Budget Sparta Mugs

Live price deal
£ 1.61 each
Min. 1008 per order
For info or to order call 0844 8117 566 or email: sales@ideasbynet.com

Product Information

Our best seller, Sparta Mugs are the ideal gift for your clients, customers and colleagues alike. As one of the most popular standard mugs, the traditional Sparta has been available in the UK for many years, there must be millions of these in circulation right now. To make sure that you stand out amongst the crowd: upgrade to the new style now! Find out more about our mug family and get mug sizes explained here.

spartabanner-newsparta-4sparta-1sparta-2sparta-3
                                                		
Quantity 721082525041008
1 Colour Screen Print£2.41£2.20£1.92£1.63£1.61
1 Colour Transfer Print£4.00£3.63£3.11£2.74£2.61
2 Colour Screen Print£2.53£2.33£2.05£1.72£1.68
2 Colour Transfer Print£4.13£3.76£3.24£2.87£2.74

There is a screen setup cost of £34.75 per position/ imprint type.

Technical Specification
Product size: (W) 80 x (H) 93 - Capacity - 300ml
Print area: 220 x 80mm
Product colours: White