989757 VOLVO Лампа накаливания

Характеристики

Применимость

SELECT p.id, m.*, m.name, p.* FROM tecdoc_new.passanger_cars p INNER JOIN tecdoc_new.article_li al ON al.linkageId=p.id INNER JOIN tcd_models m ON m.mod_id=p.modelid AND m.display=1 WHERE (al.supplierid=183 AND al.DataSupplierArticleNumber='V99-84-0003') OR (al.supplierid=183 AND al.DataSupplierArticleNumber='V99-84-0003') ORDER BY m.man_id, m.name