Rating: Not rated yet

MaxiTPMS TS601

MaxiTPMS TS601
MaxiTPMS TS601MaxiTPMS TS601MaxiTPMS TS601
Product Name: MaxiTPMS TS601
Weight: 2.25 Kg
Market Price: $1,050.00
Our Price: $990.00
You Saved: $60.00 (6%)

Shipping: $49.00 to United States via Express Shipping Click to check the shipping fee
Estimated delivery time: 3-5 Days. Read details »
MaxiTPMS® TS601 is the most powerful TPMS diagnostic & service tool in the world capable of fully diagnosing TPMS problems as well as activating TPMS sensors and reprogramming the vehicle's ECU. It is the best solution for tire shops and automotive workshops to perform TPMS service!
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'ats.xp.sort_order' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, pd.products_name, pd.products_description, pd.products_short, p.products_tax_class_id, products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price from products_xsell xp left join products p on xp.xsell_id = p.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where xp.products_id = '540' and p.products_status = '1' order by sort_order asc limit 6