Iwata Smart Jet Plus Tubular Compressor
[C-IW-SMART-HT]

 £439.00 inc.VAT
(£365.83 ex.VAT)
1 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 = '20845'

[TEP STOP]