1864221008N HYUNDAI-KIA Лампа накаливания

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

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

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=4595 AND al.DataSupplierArticleNumber='99-39038-SX') OR (al.supplierid=4595 AND al.DataSupplierArticleNumber='99-39038-SX') ORDER BY m.man_id, m.name