#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNHx8bW9kZWxfaWQ9PTIwNDJ8fG1kZl9pZD09MF44OTU3fHxzcGFyZV9pZD09MTAyODAw&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 = "8957" AND ( (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "419.970" AND av.ProductID IN (3966)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "118.559" AND av.ProductID IN (4051)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1190586" AND av.ProductID IN (4051)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1192588" AND av.ProductID IN (3966)) ) 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 = 10 AND aa.DataSupplierArticleNumber = "419.970") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "118.559") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190586") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192588") ) 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 = 10 AND aa.DataSupplierArticleNumber = "419.970") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "118.559") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190586") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192588") ) AND aa.Language = "ru" Продажа автозапчастей типа Составляющие эмульсионной трубки / распылитель для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ELRING 419.970 Шайба тепловой защиты, система впрыска
118.559 Прокладка, корпус форсунки
WILMINK GROUP WG1190586 Прокладка, корпус форсунки
WG1192588 Шайба тепловой защиты, система впрыска
2026 CATCAR.INFO (v 2.0)