#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTY0Mzd8fG1kZl9pZD09MF45ODkxfHxzcGFyZV9pZD09MTAyODA0&st=50 SELECT CONCAT(av.SupplierID, "^", av.DataSupplierArticleNumber) AS article_id, d.`Description` AS crit_designation, dv.`DisplayValue` AS crit_value, "" crit_unit, 2 criteria_art, "articletypes" as source FROM articlepassengercars av JOIN passengercarlinkageattributes_ru vla ON av.Idx = vla.Idx JOIN linkageattributedescriptions d ON vla.DescriptionIdx = d.Idx JOIN linkageattributedisplayvalues dv ON vla.DisplayValueIdx = dv.Idx WHERE av.VehicleID = "9891" AND ( (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "9144A240A" AND av.ProductID IN (3916)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "9144A240A-DNR" AND av.ProductID IN (3916)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0840009" AND av.ProductID IN (3937)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.13.030" AND av.ProductID IN (3916)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.13.090" AND av.ProductID IN (3937)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.13.031" AND av.ProductID IN (3916)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.13.029" AND av.ProductID IN (3916)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.13.089" AND av.ProductID IN (3937)) ) UNION ALL SELECT CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber) as article_id, if (aa.Description = "", aa.DisplayTitle, aa.Description) as crit_designation, aa.DisplayValue as crit_value, "" crit_unit, 1 criteria_art, "articleattributes" as source FROM articleattributes aa WHERE ( (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "9144A240A") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "9144A240A-DNR") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0840009") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.030") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.090") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.031") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.029") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.089") ) AND aa.Language = "ru" UNION ALL SELECT CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber) as article_id, if (aa.Description = "", aa.DisplayTitle, aa.Description) as crit_designation, aa.DisplayValue as crit_value, "" crit_unit, 1 criteria_art, "articleattributes_2018_2" as source FROM articleattributes_2018_2 aa WHERE ( (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "9144A240A") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "9144A240A-DNR") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0840009") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.030") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.090") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.031") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.029") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.089") ) AND aa.Language = "ru" Продажа автозапчастей типа Топливопровод / распределение / соединение для автомобилей

Выбор автозапчасти

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DELPHI 9144A240A Трубопровод высокого давления, система впрыска
9144A240A-DNR Трубопровод высокого давления, система впрыска
METZGER 0840009 Шланг, утечка топлива
TRUCKTEC AUTOMOTIVE 02.13.030 Трубопровод высокого давления, система впрыска
02.13.090 Шланг, утечка топлива
02.13.031 Трубопровод высокого давления, система впрыска
02.13.029 Трубопровод высокого давления, система впрыска
02.13.089 Шланг, утечка топлива
2026 CATCAR.INFO (v 2.0)