#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4Nnx8bW9kZWxfaWQ9PTExODY5fHxtZGZfaWQ9PTFeMTc0MzV8fHNwYXJlX2lkPT0yMDAxMzU%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 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 = "17435" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15099300" AND av.ProductID IN (572)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15091000" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "000.270" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "081.460" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "453.851" AND av.ProductID IN (572)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39948" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77476-01" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77805-01" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319609-00" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5461" AND av.ProductID IN (572)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "031.287" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-38651-00" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-35206-10" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1190417" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250194" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250357" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1087483" 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 = "15099300") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15091000") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "000.270") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "081.460") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "453.851") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39948") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77476-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77805-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319609-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5461") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "031.287") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-38651-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35206-10") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190417") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250194") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250357") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087483") ) 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 = "15099300") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15091000") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "000.270") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "081.460") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "453.851") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39948") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77476-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77805-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319609-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5461") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "031.287") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-38651-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35206-10") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190417") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250194") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250357") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087483") ) AND aa.Language = "ru" Продажа автозапчастей типа Сальник / комплект сальников вала для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 15099300 Уплотняющее кольцо, коленчатый вал
15091000 Уплотняющее кольцо, коленчатый вал
ELRING 000.270 Уплотняющее кольцо, коленчатый вал
081.460 Уплотняющее кольцо, коленчатый вал
453.851 Уплотняющее кольцо, коленчатый вал
FEBI BILSTEIN 39948 Уплотняющее кольцо, коленчатый вал
GLASER P77476-01 Уплотняющее кольцо, коленчатый вал
P77805-01 Уплотняющее кольцо, коленчатый вал
GOETZE 50-319609-00 Уплотняющее кольцо, коленчатый вал
PAYEN NA5461 Уплотняющее кольцо, коленчатый вал
SAMPA 031.287 Уплотняющее кольцо, коленчатый вал
VICTOR REINZ 81-38651-00 Уплотняющее кольцо, коленчатый вал
81-35206-10 Уплотняющее кольцо, коленчатый вал
WILMINK GROUP WG1190417 Уплотняющее кольцо, коленчатый вал
WG1250194 Уплотняющее кольцо, коленчатый вал
WG1250357 Уплотняющее кольцо, коленчатый вал
WG1087483 Уплотняющее кольцо, коленчатый вал
2026 CATCAR.INFO (v 2.0)