#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTUyMDl8fG1kZl9pZD09MF4yMjY4MHx8c3BhcmVfaWQ9PTEwMDQ3OA%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 = "22680" AND ( (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BOP1010" AND av.ProductID IN (805)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "OS3592" AND av.ProductID IN (805)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "OS3573" AND av.ProductID IN (805)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "SW90013" AND av.ProductID IN (805)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "SW90015" AND av.ProductID IN (805)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.800.141" AND av.ProductID IN (805)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "330366" AND av.ProductID IN (805)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.0141" AND av.ProductID IN (805)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "12445" AND av.ProductID IN (805)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "12436" AND av.ProductID IN (805)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "40489" AND av.ProductID IN (1289)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FOP1010" AND av.ProductID IN (805)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "82.014" AND av.ProductID IN (805)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6ZL 003 259-211" AND av.ProductID IN (805)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6ZL 008 780-011" AND av.ProductID IN (805)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7532014" AND av.ProductID IN (805)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "500 141" AND av.ProductID IN (805)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "510050010300" AND av.ProductID IN (805)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "72014" AND av.ProductID IN (805)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0910018" AND av.ProductID IN (805)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0901093" AND av.ProductID IN (1289)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "614 820 0001" AND av.ProductID IN (805)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVRP274" AND av.ProductID IN (805)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVRP283" AND av.ProductID IN (805)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVRP168" AND av.ProductID IN (805)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PE70047" AND av.ProductID IN (805)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XOPS204" AND av.ProductID IN (805)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XOPS109" AND av.ProductID IN (805)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XOPS203" AND av.ProductID IN (805)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "82.014" AND av.ProductID IN (805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LOPS034" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "SOP068" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "51153" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "SOP066" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "50938" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "OPS2137" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "OPS2136" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LOPS083" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LOPS082" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "51152" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "SOP001" AND av.ProductID IN (805,805)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "OPS2079" AND av.ProductID IN (805,805)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 94 0489" AND av.ProductID IN (1289)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "205 691" AND av.ProductID IN (805)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V40-73-0006" AND av.ProductID IN (805)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V40-72-0493" AND av.ProductID IN (1289)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V40-73-0014" AND av.ProductID IN (805)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1499698" AND av.ProductID IN (805)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1795657" AND av.ProductID IN (1289)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1492502" AND av.ProductID IN (805)) ) 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 = "BOP1010") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "OS3592") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "OS3573") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90013") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90015") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.800.141") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "330366") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.0141") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "12445") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "12436") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "40489") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FOP1010") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "82.014") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 003 259-211") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 008 780-011") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7532014") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "500 141") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "510050010300") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "72014") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0910018") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0901093") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 820 0001") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP274") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP283") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP168") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PE70047") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS204") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS109") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS203") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "82.014") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS034") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP068") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51153") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP066") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "50938") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2137") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2136") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS083") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS082") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51152") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP001") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2079") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 94 0489") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "205 691") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-73-0006") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-72-0493") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-73-0014") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1499698") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795657") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1492502") ) 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 = "BOP1010") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "OS3592") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "OS3573") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90013") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "SW90015") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.800.141") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "330366") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.0141") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "12445") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "12436") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "40489") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FOP1010") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "82.014") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 003 259-211") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZL 008 780-011") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7532014") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "500 141") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "510050010300") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "72014") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0910018") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0901093") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 820 0001") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP274") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP283") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVRP168") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PE70047") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS204") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS109") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XOPS203") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "82.014") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS034") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP068") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51153") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP066") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "50938") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2137") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2136") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS083") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LOPS082") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "51152") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "SOP001") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "OPS2079") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 94 0489") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "205 691") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-73-0006") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-72-0493") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-73-0014") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1499698") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795657") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1492502") ) AND aa.Language = "ru" Продажа автозапчастей типа Датчик давления масла / клапан для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BORG & BECK BOP1010 Датчик давления масла
CALORSTAT by Vernet OS3592 Датчик давления масла
OS3573 Датчик давления масла
DELPHI SW90013 Датчик давления масла
SW90015 Датчик давления масла
EPS 1.800.141 Датчик давления масла
ERA 330366 Датчик давления масла
FACET 7.0141 Датчик давления масла
FAE 12445 Датчик давления масла
12436 Датчик давления масла
FEBI BILSTEIN 40489 Датчик, уровень моторного масла
FIRST LINE FOP1010 Датчик давления масла
FISPA 82.014 Датчик давления масла
HELLA 6ZL 003 259-211 Датчик давления масла
6ZL 008 780-011 Датчик давления масла
HOFFER 7532014 Датчик давления масла
KW 500 141 Датчик давления масла
MAGNETI MARELLI 510050010300 Датчик давления масла
MEAT & DORIA 72014 Датчик давления масла
METZGER 0910018 Датчик давления масла
0901093 Датчик, уровень моторного масла
MEYLE 614 820 0001 Датчик давления масла
MOTAQUIP LVRP274 Датчик давления масла
LVRP283 Датчик давления масла
LVRP168 Датчик давления масла
PATRON PE70047 Датчик давления масла
QUINTON HAZELL XOPS204 Датчик давления масла
XOPS109 Датчик давления масла
XOPS203 Датчик давления масла
SIDAT 82.014 Датчик давления масла
SMPE LOPS034 Датчик давления масла
SOP068 Датчик давления масла
51153 Датчик давления масла
SOP066 Датчик давления масла
50938 Датчик давления масла
OPS2137 Датчик давления масла
OPS2136 Датчик давления масла
LOPS083 Датчик давления масла
LOPS082 Датчик давления масла
51152 Датчик давления масла
SOP001 Датчик давления масла
OPS2079 Датчик давления масла
SWAG 40 94 0489 Датчик, уровень моторного масла
TOPRAN 205 691 Датчик давления масла
VEMO V40-73-0006 Датчик давления масла
V40-72-0493 Датчик, уровень моторного масла
V40-73-0014 Датчик давления масла
WILMINK GROUP WG1499698 Датчик давления масла
WG1795657 Датчик, уровень моторного масла
WG1492502 Датчик давления масла
2026 CATCAR.INFO (v 2.0)