£199.20 inc. 20% VAT

£199.20 inc. 20% VAT

Quick Overview:
The new and updated dual stage boost controller, now featuring a billet aluminium housing and bullet valve technology for ultra fast boost response with two adjustable boost levels. Toggle between ...



£199.20 inc. 20% VAT

1327 - Undeclared variable: RELATED_PRODUCTS_MAX_DISP

select r.slave_id, pd.products_name, p.products_model, p.products_price, p.products_quantity, p.manufacturers_id, m.manufacturers_name, IF(s.status, s.specials_new_products_price, NULL) as special_price, p.products_tax_class_id, p.products_image from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id , products_description pd, products_related_cross r where r.slave_id = p.products_id AND pd.products_id = p.products_id AND pd.language_id = '1' AND r.master_id = '14908' AND p.products_status='1' order by r.sort_order, relation_id limit RELATED_PRODUCTS_MAX_DISP