Average Rating:  5.0/5 Stars


Product Name: GM MDI
Weight: 4.00 Kg
Market Price: $1,700.00
Our Price: $800.00
You Saved: $900.00 (53%)

Shipping: $49.00 to United States via Express Shipping Click to check the shipping fee
Estimated delivery time: 3-5 Days. Read details »
GM MDI is a new GM Diagnostic tool. It is not only work for the new gm car, but also for the old kind of car. It covers GM car from 1990 to now.
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 = '388' and p.products_status = '1' order by sort_order asc limit 6