#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3M3x8bW9kZWxfaWQ9PTg2MDl8fG1kZl9pZD09MF4zMzMyOHx8c3BhcmVfaWQ9PTEwMDQ3OA%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 = "33328" AND ( (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BOP1004" AND av.ProductID IN (805)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B13138" AND av.ProductID IN (805)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B13137" AND av.ProductID IN (805)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "OS3572" AND av.ProductID IN (805)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "OS3606" AND av.ProductID IN (805)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "OS3636" AND av.ProductID IN (805)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "SW90024" AND av.ProductID IN (805)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "351.210" AND av.ProductID IN (4176)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.800.139" AND av.ProductID IN (805)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.0139" AND av.ProductID IN (805)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FOP1004" AND av.ProductID IN (805)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6ZL 008 280-051" AND av.ProductID IN (805)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6ZL 003 259-971" AND av.ProductID IN (805)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6ZL 008 280-001" AND av.ProductID IN (805)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70684001" AND av.ProductID IN (1289)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1193500600" AND av.ProductID IN (805)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1193500800" AND av.ProductID IN (805)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "500 139" AND av.ProductID IN (805)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "510050010500" AND av.ProductID IN (805)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "114 820 0003" AND av.ProductID IN (805)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "114 820 0001" AND av.ProductID IN (805)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVRP105" AND av.ProductID IN (805)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVRP296" AND av.ProductID IN (805)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PE70055" AND av.ProductID IN (805)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XOPS121" AND av.ProductID IN (805)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XOPS225" AND av.ProductID IN (805)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "3706001" AND av.ProductID IN (805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "OPS2116" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LOPS094" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LOPS053" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "51120" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "SOP104" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "OPS2112" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "51166" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "SOP015" AND av.ProductID IN (805,805)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "108 891" AND av.ProductID IN (805)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-99-1999" AND av.ProductID IN (805)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99190071201" AND av.ProductID IN (805)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "19070731001" AND av.ProductID IN (1289)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1499706" AND av.ProductID IN (805)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1380171" AND av.ProductID IN (4176)) ) 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 = 475 AND aa.DataSupplierArticleNumber = "BOP1004") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B13138") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B13137") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "OS3572") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "OS3606") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "OS3636") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90024") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "351.210") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.800.139") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.0139") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FOP1004") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 008 280-051") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 003 259-971") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 008 280-001") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70684001") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193500600") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193500800") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "500 139") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "510050010500") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 820 0003") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 820 0001") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP105") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP296") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PE70055") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS121") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS225") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "3706001") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2116") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS094") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS053") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51120") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP104") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2112") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51166") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP015") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "108 891") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-99-1999") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190071201") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "19070731001") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1499706") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1380171") ) 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 = 475 AND aa.DataSupplierArticleNumber = "BOP1004") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B13138") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B13137") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "OS3572") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "OS3606") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "OS3636") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90024") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "351.210") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.800.139") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.0139") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FOP1004") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 008 280-051") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 003 259-971") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 008 280-001") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70684001") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193500600") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193500800") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "500 139") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "510050010500") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 820 0003") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 820 0001") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP105") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP296") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PE70055") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS121") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS225") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "3706001") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2116") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS094") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS053") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51120") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP104") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2112") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51166") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP015") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "108 891") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-99-1999") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99190071201") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "19070731001") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1499706") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1380171") ) AND aa.Language = "ru" Продажа автозапчастей типа Датчик давления масла / клапан для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BORG & BECK BOP1004 Датчик давления масла
Borsehung B13138 Датчик давления масла
B13137 Датчик давления масла
CALORSTAT by Vernet OS3572 Датчик давления масла
OS3606 Датчик давления масла
OS3636 Датчик давления масла
DELPHI SW90024 Датчик давления масла
ELRING 351.210 Уплотнительное кольцо, датчик уровня моторного масла
EPS 1.800.139 Датчик давления масла
FACET 7.0139 Датчик давления масла
FIRST LINE FOP1004 Датчик давления масла
HELLA 6ZL 008 280-051 Датчик давления масла
6ZL 003 259-971 Датчик давления масла
6ZL 008 280-001 Датчик давления масла
HERTH+BUSS ELPARTS 70684001 Датчик, уровень моторного масла
JP GROUP 1193500600 Датчик давления масла
1193500800 Датчик давления масла
KW 500 139 Датчик давления масла
MAGNETI MARELLI 510050010500 Датчик давления масла
MEYLE 114 820 0003 Датчик давления масла
114 820 0001 Датчик давления масла
MOTAQUIP LVRP105 Датчик давления масла
LVRP296 Датчик давления масла
PATRON PE70055 Датчик давления масла
QUINTON HAZELL XOPS121 Датчик давления масла
XOPS225 Датчик давления масла
SASIC 3706001 Датчик давления масла
SMPE OPS2116 Датчик давления масла
LOPS094 Датчик давления масла
LOPS053 Датчик давления масла
51120 Датчик давления масла
SOP104 Датчик давления масла
OPS2112 Датчик давления масла
51166 Датчик давления масла
SOP015 Датчик давления масла
TOPRAN 108 891 Датчик давления масла
VEMO V15-99-1999 Датчик давления масла
vika 99190071201 Датчик давления масла
19070731001 Датчик, уровень моторного масла
WILMINK GROUP WG1499706 Датчик давления масла
WG1380171 Уплотнительное кольцо, датчик уровня моторного масла
2026 CATCAR.INFO (v 2.0)