#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTY0Mzd8fG1kZl9pZD09MF4yMzQwOHx8c3BhcmVfaWQ9PTEwMjgwMA%3D%3D&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 = "23408" AND ( (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "1 987 972 076" AND av.ProductID IN (4051)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "9109-929" AND av.ProductID IN (3963)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "924.867" AND av.ProductID IN (4051)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "199.340" AND av.ProductID IN (4051)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "199.360" AND av.ProductID IN (4051)) OR (av.SupplierID = 367 AND av.DataSupplierArticleNumber = "642.695.010" AND av.ProductID IN (3966)) OR (av.SupplierID = 367 AND av.DataSupplierArticleNumber = "642.695.100" AND av.ProductID IN (3966)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "29140" AND av.ProductID IN (3892)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0840073" AND av.ProductID IN (3937)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "KG5339" AND av.ProductID IN (3966)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 92 9140" AND av.ProductID IN (3892)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "401 502" AND av.ProductID IN (3966)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.10.079" AND av.ProductID IN (3966)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.10.080" AND av.ProductID IN (3966)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.10.078" AND av.ProductID IN (3966)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.13.086" AND av.ProductID IN (3937)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1145442" AND av.ProductID IN (3892)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1086812" AND av.ProductID IN (4051)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1086813" AND av.ProductID IN (4051)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1085953" AND av.ProductID IN (4051)) ) 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 = 30 AND aa.DataSupplierArticleNumber = "1 987 972 076") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "9109-929") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "924.867") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "199.340") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "199.360") OR (aa.SupplierID = 367 AND aa.DataSupplierArticleNumber = "642.695.010") OR (aa.SupplierID = 367 AND aa.DataSupplierArticleNumber = "642.695.100") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29140") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0840073") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "KG5339") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 92 9140") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "401 502") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.10.079") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.10.080") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.10.078") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.086") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1145442") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086812") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086813") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085953") ) 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 = 30 AND aa.DataSupplierArticleNumber = "1 987 972 076") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "9109-929") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "924.867") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "199.340") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "199.360") OR (aa.SupplierID = 367 AND aa.DataSupplierArticleNumber = "642.695.010") OR (aa.SupplierID = 367 AND aa.DataSupplierArticleNumber = "642.695.100") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29140") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0840073") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "KG5339") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 92 9140") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "401 502") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.10.079") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.10.080") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.10.078") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.13.086") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1145442") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086812") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086813") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085953") ) AND aa.Language = "ru" Продажа автозапчастей типа Составляющие эмульсионной трубки / распылитель для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BOSCH 1 987 972 076 Прокладка, корпус форсунки
DELPHI 9109-929 Колпачок, утечка топлива
ELRING 924.867 Прокладка, корпус форсунки
199.340 Прокладка, корпус форсунки
199.360 Прокладка, корпус форсунки
FA1 642.695.010 Шайба тепловой защиты, система впрыска
642.695.100 Шайба тепловой защиты, система впрыска
FEBI BILSTEIN 29140 Прокладка, корпус форсунки
METZGER 0840073 Шланг, утечка топлива
PAYEN KG5339 Шайба тепловой защиты, система впрыска
SWAG 10 92 9140 Прокладка, корпус форсунки
TOPRAN 401 502 Шайба тепловой защиты, система впрыска
TRUCKTEC AUTOMOTIVE 02.10.079 Шайба тепловой защиты, система впрыска
02.10.080 Шайба тепловой защиты, система впрыска
02.10.078 Шайба тепловой защиты, система впрыска
02.13.086 Шланг, утечка топлива
WILMINK GROUP WG1145442 Прокладка, корпус форсунки
WG1086812 Прокладка, корпус форсунки
WG1086813 Прокладка, корпус форсунки
WG1085953 Прокладка, корпус форсунки
2026 CATCAR.INFO (v 2.0)