#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTE0ODd8fG1kZl9pZD09MF41MzM5fHxzcGFyZV9pZD09MTAwMjM0&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 = "5339" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "21012700" AND av.ProductID IN (135)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "14044200" AND av.ProductID IN (455)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "M001-50" AND av.ProductID IN (135)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OP2339" AND av.ProductID IN (455)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADA100105" AND av.ProductID IN (135)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "028059P" AND av.ProductID IN (455)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "423979P" AND av.ProductID IN (455)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "423983P" AND av.ProductID IN (455)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "005565S" AND av.ProductID IN (135)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "115.100" AND av.ProductID IN (135)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "175.142" AND av.ProductID IN (455)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "5256009" AND av.ProductID IN (135)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "1022017" AND av.ProductID IN (455)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SG493" AND av.ProductID IN (455)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "07215" AND av.ProductID IN (135)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "03014" AND av.ProductID IN (135)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "X54083-01" AND av.ProductID IN (455)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "W72119-02" AND av.ProductID IN (135)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "X54488-01" AND av.ProductID IN (455)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "31-026923-00" AND av.ProductID IN (455)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1130980" AND av.ProductID IN (135)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PG4-0029" AND av.ProductID IN (455)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "JH5082" AND av.ProductID IN (455)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "JJ498" AND av.ProductID IN (455)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 90 3014" AND av.ProductID IN (135)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "99 90 7215" AND av.ProductID IN (135)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.10.043" AND av.ProductID IN (455)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.10.100" AND av.ProductID IN (455)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V30-2104" AND av.ProductID IN (455)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-3327" AND av.ProductID IN (135)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "71-26204-10" AND av.ProductID IN (455)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "71-34037-00" AND av.ProductID IN (455)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "41-70089-00" AND av.ProductID IN (135)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1182308" AND av.ProductID IN (455)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1146145" AND av.ProductID IN (455)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1007507" AND av.ProductID IN (455)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1084960" AND av.ProductID IN (135)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1246745" AND av.ProductID IN (455)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1162661" AND av.ProductID IN (455)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1007562" AND av.ProductID IN (455)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1103286" AND av.ProductID IN (135)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1177162" AND av.ProductID IN (455)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1087569" AND av.ProductID IN (455)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1163712" AND av.ProductID IN (135)) ) 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 = 139 AND aa.DataSupplierArticleNumber = "21012700") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "14044200") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "M001-50") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OP2339") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADA100105") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "028059P") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "423979P") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "423983P") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "005565S") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "115.100") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "175.142") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "5256009") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "1022017") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SG493") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "07215") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "03014") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "X54083-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "W72119-02") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "X54488-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "31-026923-00") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1130980") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PG4-0029") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "JH5082") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "JJ498") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 90 3014") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 7215") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.10.043") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.10.100") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-2104") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3327") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "71-26204-10") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "71-34037-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "41-70089-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1182308") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1146145") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1007507") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1084960") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1246745") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1162661") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1007562") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103286") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177162") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087569") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163712") ) 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 = 139 AND aa.DataSupplierArticleNumber = "21012700") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "14044200") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "M001-50") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OP2339") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADA100105") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "028059P") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "423979P") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "423983P") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "005565S") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "115.100") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "175.142") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "5256009") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "1022017") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SG493") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "07215") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "03014") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "X54083-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "W72119-02") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "X54488-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "31-026923-00") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1130980") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PG4-0029") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "JH5082") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "JJ498") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 90 3014") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "99 90 7215") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.10.043") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.10.100") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-2104") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3327") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "71-26204-10") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "71-34037-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "41-70089-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1182308") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1146145") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1007507") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1084960") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1246745") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1162661") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1007562") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103286") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177162") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087569") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163712") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка масляного поддона для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 21012700 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
14044200 Прокладка, масляный поддон
ASHUKI M001-50 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
BGA OP2339 Прокладка, масляный поддон
BLUE PRINT ADA100105 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
CORTECO 028059P Прокладка, масляный поддон
423979P Прокладка, масляный поддон
423983P Прокладка, масляный поддон
005565S Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
ELRING 115.100 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
175.142 Прокладка, масляный поддон
ELWIS ROYAL 5256009 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
1022017 Прокладка, масляный поддон
FAI AutoParts SG493 Прокладка, масляный поддон
FEBI BILSTEIN 07215 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
03014 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
GLASER X54083-01 Прокладка, масляный поддон
W72119-02 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
X54488-01 Прокладка, масляный поддон
GOETZE 31-026923-00 Прокладка, масляный поддон
KRAFT AUTOMOTIVE 1130980 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
PATRON PG4-0029 Прокладка, масляный поддон
PAYEN JH5082 Прокладка, масляный поддон
JJ498 Прокладка, масляный поддон
SWAG 10 90 3014 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
99 90 7215 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
TRUCKTEC AUTOMOTIVE 02.10.043 Прокладка, масляный поддон
02.10.100 Прокладка, масляный поддон
VAICO V30-2104 Прокладка, масляный поддон
V10-3327 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
VICTOR REINZ 71-26204-10 Прокладка, масляный поддон
71-34037-00 Прокладка, масляный поддон
41-70089-00 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
WILMINK GROUP WG1182308 Прокладка, масляный поддон
WG1146145 Прокладка, масляный поддон
WG1007507 Прокладка, масляный поддон
WG1084960 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
WG1246745 Прокладка, масляный поддон
WG1162661 Прокладка, масляный поддон
WG1007562 Прокладка, масляный поддон
WG1103286 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
WG1177162 Прокладка, масляный поддон
WG1087569 Прокладка, масляный поддон
WG1163712 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
2026 CATCAR.INFO (v 2.0)