#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTM3ODA3fHxtZGZfaWQ9PTBeMTI2NjE2fHxzcGFyZV9pZD09MTAyNzQ3&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 = "126616" AND ( (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "XSP9000" AND av.ProductID IN (2062)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LSP5000" AND av.ProductID IN (2062)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70699434" AND av.ProductID IN (2232)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70699443" AND av.ProductID IN (2232)) OR (av.SupplierID = 4662 AND av.DataSupplierArticleNumber = "45.934.000" AND av.ProductID IN (2232)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "WS1277" AND av.ProductID IN (3944)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LWS136" AND av.ProductID IN (3944)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "CS1895" AND av.ProductID IN (833)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "55592" AND av.ProductID IN (3944)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "16970" AND av.ProductID IN (4272)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "27273" AND av.ProductID IN (3938)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LCS664" AND av.ProductID IN (3946)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "17295" AND av.ProductID IN (3946)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LWS150" AND av.ProductID IN (3944)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "EPS782" AND av.ProductID IN (833)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "ECS158" AND av.ProductID IN (3944)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "EXP022" AND av.ProductID IN (4272)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "EXT275" AND av.ProductID IN (3938)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "CS1896" AND av.ProductID IN (3946)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "WS1260" AND av.ProductID IN (3944)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LCS663" AND av.ProductID IN (833)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "ECS179" AND av.ProductID IN (3944)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "17294" AND av.ProductID IN (833)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "55494" AND av.ProductID IN (3944)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LXP022" AND av.ProductID IN (4272)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LXT276" AND av.ProductID IN (3938)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "EPS783" AND av.ProductID IN (3946)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1408597" AND av.ProductID IN (833)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1494218" AND av.ProductID IN (4272)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1494238" AND av.ProductID IN (3938)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1494044" AND av.ProductID IN (833)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1748885" AND av.ProductID IN (4272)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1748783" AND av.ProductID IN (3938)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1755890" AND av.ProductID IN (3946)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1756217" AND av.ProductID IN (4272)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1777539" AND av.ProductID IN (3946)) ) 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 = 4344 AND aa.DataSupplierArticleNumber = "XSP9000") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LSP5000") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70699434") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70699443") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "45.934.000") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "WS1277") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LWS136") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "CS1895") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "55592") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "16970") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "27273") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LCS664") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "17295") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LWS150") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EPS782") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ECS158") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EXP022") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EXT275") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "CS1896") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "WS1260") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LCS663") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ECS179") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "17294") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "55494") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LXP022") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LXT276") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EPS783") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1408597") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1494218") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1494238") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1494044") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1748885") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1748783") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1755890") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1756217") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1777539") ) 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 = 4344 AND aa.DataSupplierArticleNumber = "XSP9000") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LSP5000") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70699434") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70699443") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "45.934.000") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "WS1277") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LWS136") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "CS1895") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "55592") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "16970") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "27273") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LCS664") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "17295") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LWS150") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EPS782") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ECS158") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EXP022") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EXT275") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "CS1896") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "WS1260") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LCS663") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ECS179") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "17294") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "55494") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LXP022") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LXT276") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EPS783") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1408597") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1494218") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1494238") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1494044") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1748885") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1748783") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1755890") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1756217") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1777539") ) AND aa.Language = "ru" Продажа автозапчастей типа Датчики для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ELTA AUTOMOTIVE XSP9000 Датчик положения педали, педаль тормоза
LSP5000 Датчик положения педали, педаль тормоза
HERTH+BUSS ELPARTS 70699434 Датчик частоты вращения колеса, контроль давления в шинах
70699443 Датчик частоты вращения колеса, контроль давления в шинах
HUF 45.934.000 Датчик частоты вращения колеса, контроль давления в шинах
SMPE WS1277 Датчик, температура охлаждающей жидкости
LWS136 Датчик, температура охлаждающей жидкости
CS1895 Датчик импульсов
55592 Датчик, температура охлаждающей жидкости
16970 Датчик, давление выхлопных газов
27273 Датчик, температура выхлопных газов
LCS664 Датчик, положение распределительного вала
17295 Датчик, положение распределительного вала
LWS150 Датчик, температура охлаждающей жидкости
EPS782 Датчик импульсов
ECS158 Датчик, температура охлаждающей жидкости
EXP022 Датчик, давление выхлопных газов
EXT275 Датчик, температура выхлопных газов
CS1896 Датчик, положение распределительного вала
WS1260 Датчик, температура охлаждающей жидкости
LCS663 Датчик импульсов
ECS179 Датчик, температура охлаждающей жидкости
17294 Датчик импульсов
55494 Датчик, температура охлаждающей жидкости
LXP022 Датчик, давление выхлопных газов
LXT276 Датчик, температура выхлопных газов
EPS783 Датчик, положение распределительного вала
WILMINK GROUP WG1408597 Датчик импульсов
WG1494218 Датчик, давление выхлопных газов
WG1494238 Датчик, температура выхлопных газов
WG1494044 Датчик импульсов
WG1748885 Датчик, давление выхлопных газов
WG1748783 Датчик, температура выхлопных газов
WG1755890 Датчик, положение распределительного вала
WG1756217 Датчик, давление выхлопных газов
WG1777539 Датчик, положение распределительного вала
2026 CATCAR.INFO (v 2.0)