#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1MzR8fG1kZl9pZD09MV45ODcwfHxzcGFyZV9pZD09MjAwMTM1&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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "9870" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15072300" AND av.ProductID IN (572)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15105800" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "090.510" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "152.320" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "904.820" AND av.ProductID IN (572)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "40532" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P93261-01" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77749-01" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77750-01" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319620-00" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5471" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5300" AND av.ProductID IN (572)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "041.147" AND av.ProductID IN (572)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-01377-SX" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-10445-00" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-35996-00" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-35997-00" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1379822" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1195673" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250274" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1151028" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250275" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1151030" AND av.ProductID IN (572)) ) 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 = "15072300") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15105800") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "090.510") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "152.320") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "904.820") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "40532") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P93261-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77749-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77750-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319620-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5471") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5300") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "041.147") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-01377-SX") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-10445-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35996-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35997-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1379822") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1195673") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250274") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1151028") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250275") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1151030") ) 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 = "15072300") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15105800") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "090.510") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "152.320") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "904.820") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "40532") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P93261-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77749-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77750-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319620-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5471") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5300") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "041.147") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-01377-SX") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-10445-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35996-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35997-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1379822") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1195673") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250274") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1151028") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250275") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1151030") ) AND aa.Language = "ru" Продажа автозапчастей типа Сальник / комплект сальников вала для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 15072300 Уплотняющее кольцо, коленчатый вал
15105800 Уплотняющее кольцо, коленчатый вал
ELRING 090.510 Уплотняющее кольцо, коленчатый вал
152.320 Уплотняющее кольцо, коленчатый вал
904.820 Уплотняющее кольцо, коленчатый вал
FEBI BILSTEIN 40532 Уплотняющее кольцо, коленчатый вал
GLASER P93261-01 Уплотняющее кольцо, коленчатый вал
P77749-01 Уплотняющее кольцо, коленчатый вал
P77750-01 Уплотняющее кольцо, коленчатый вал
GOETZE 50-319620-00 Уплотняющее кольцо, коленчатый вал
PAYEN NA5471 Уплотняющее кольцо, коленчатый вал
NA5300 Уплотняющее кольцо, коленчатый вал
SAMPA 041.147 Уплотняющее кольцо, коленчатый вал
STELLOX 81-01377-SX Уплотняющее кольцо, коленчатый вал
VICTOR REINZ 81-10445-00 Уплотняющее кольцо, коленчатый вал
81-35996-00 Уплотняющее кольцо, коленчатый вал
81-35997-00 Уплотняющее кольцо, коленчатый вал
WILMINK GROUP WG1379822 Уплотняющее кольцо, коленчатый вал
WG1195673 Уплотняющее кольцо, коленчатый вал
WG1250274 Уплотняющее кольцо, коленчатый вал
WG1151028 Уплотняющее кольцо, коленчатый вал
WG1250275 Уплотняющее кольцо, коленчатый вал
WG1151030 Уплотняющее кольцо, коленчатый вал
2026 CATCAR.INFO (v 2.0)