Cart Contents (2)
Checkout
My Account
Tel: +44 (0)1903 767 800
Search
Home
»
Products by Type
»
Equipment
»
Compressors
»
Sparmax Compressors
»
C-AR-VIZ
Products
Accessories
Cleaning
Maintenance
Tools
Eraser brushes
Electric Erasers
Image transfer
Light boxes
Stencil Burner
Knives
Pipettes
Rules
Sanders/Files
Screwdrivers
Sugarcraft
Tweezers
All...
Hoses/Connectors
Bottles/Cups
Handles
Hangers
Surface/Prep
Mixing
Paintbrushes
Shirts
All...
Applications
Brands
Educational
Courses
Art
Beauty
Cake/Crafts
Custom Auto
Scale Models
Textiles
Info...
DVDs
Books
Tutorials
Equipment
-------->
Airbrushes
Iwata
NEO for Iwata
Paasche
Sparmax
Badger
All...
Compressors
Neo Air
Freestyle Air
Iwata Studio
Sparmax
Badger
Fittings
Propellant
All...
Dehumidifiers
Easels, Rigs & Jigs
Guns
Iwata
Paasche
Badger
Flake King
Metal Flakes
Abrasives
All...
Health & Safety
Extractors
Respirators
Face masks
Kits / Systems
Lighting / Lamps
All
equipment
...
Masking/Stencils
Stencils
Artool
Createx/B-Fast
Cake/Craft
Zazzo Make-up
Nail Art
All...
Films/Tapes
Masking Film
Frisket Film
Masking Tapes
Knives/Blades
ModelCraftX-Acto
X-Acto
Stencil Burner
Paints
Food/Cake
Squires Kitchen
Kopykake
All...
Scale Models
Lifecolor
NuWorlds
Darkstar
HR Hobbies
Com-Art
Bloodline
All...
Art/Graphics
Com-Art
Createx Wicked
Illustration
Bloodline
All...
Automotive
Auto-Borne
Candy2O
Createx Wicked
Flake King
All...
Craft/Textile
Createx Colors
Createx Wicked
All...
Beauty
Nail Art
Make-Up
Body Art
Prosthetic
Spare Parts
Iwata
NEO for Iwata
Revolution
Eclipse
HP & HP Plus
Hi-Line
Custom Micron
Kustom Series
Iwata guns
Paasche
Badger
Premi-Air
Sparmax
Compressor
VsionAir
SALE / Offers
ORDER HISTORY
How-To
Tutorials
Courses
Art
Beauty
Cake/Crafts
Custom Auto
Scale Models
Textiles
Info...
Instructors
DVDs
Books
Info
Buying Guides
-->
Kit Builder
Airbrushes
Choosing
Iwata
Features
Applications
Buyer Beware
Glossary
Compressors
Choosing
Iwata
Features
Applications
Compatibility
Glossary
Paints
Iwata
Studio Series
Buyer Beware
Service/Repair
Shipping
Terms
Security
Charity
About Us
News / SALE
SALE / Offers
New Products
Course Dates
Contact
Enquiry
Course Enquiry
Address
Map
Opening Times
Facebook
Twitter
Sparmax ARISM Viz Compressor with Smart-Stop
[C-AR-VIZ]
£225.00
£198.00
inc.VAT
(
£187.50
£165.00
ex.VAT)
0 in cart
1 - Can't create/write to file '/var/tmp/#sql_548_1.MAI' (Errcode: 28 "No space left on device")
SELECT products_id FROM (select distinct p.products_model, m.manufacturers_name, p.products_image, p.products_weight, m.manufacturers_id, p.products_id, pd.products_name, pd.products_url, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, d.discount_price, d.duty_cycle_text from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd INNER JOIN (SELECT p.products_model, kb.session_time_mins, kb.duty_cycle_running, kb.duty_cycle_resting, kb.switch, kb.tank_size_litre, kb.duty_cycle_text, IF(s.status AND p.products_price*(1-kb.kit_discount/100) > s.specials_new_products_price, s.specials_new_products_price, p.products_price*(1-kb.kit_discount/100)) as discount_price FROM products p LEFT JOIN specials s USING (products_id) INNER JOIN kit_builder_compressor kb ON p.products_model = kb.products_model) d where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' AND p.products_model = d.products_model ORDER BY products_price DESC, products_model ASC) T WHERE products_id = '22567'
[TEP STOP]