#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTQ2ODh8fG1kZl9pZD09MF4xNTEyN3x8c3BhcmVfaWQ9PTEwMDUyMQ%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 = "15127" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15012600" AND av.ProductID IN (572)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15033800" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS5317" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS5376" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS3371" AND av.ProductID IN (572)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "N10002BTA" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "19027853B" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12016300B" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "289128" AND av.ProductID IN (3874)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "702.269" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "034.530" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS2188" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS006" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS1205" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319161-00" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NJ006" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NF678" AND av.ProductID IN (572)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "820 222" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1183532" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1085457" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1755322" AND av.ProductID IN (3874)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1183601" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1163050" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1190104" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1163208" 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 = "15012600") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15033800") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5317") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5376") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS3371") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "N10002BTA") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19027853B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12016300B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "289128") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "702.269") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "034.530") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS2188") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS006") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1205") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319161-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NJ006") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NF678") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "820 222") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183532") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085457") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1755322") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183601") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163050") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190104") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163208") ) 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 = "15012600") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15033800") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5317") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5376") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS3371") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "N10002BTA") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19027853B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12016300B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "289128") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "702.269") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "034.530") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS2188") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS006") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1205") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319161-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NJ006") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NF678") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "820 222") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183532") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085457") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1755322") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183601") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163050") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190104") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163208") ) AND aa.Language = "ru" Продажа автозапчастей типа Сальник / комплект сальников вала для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 15012600 Уплотняющее кольцо, коленчатый вал
15033800 Уплотняющее кольцо, коленчатый вал
BGA OS5317 Уплотняющее кольцо, коленчатый вал
OS5376 Уплотняющее кольцо, коленчатый вал
OS3371 Уплотняющее кольцо, коленчатый вал
BTA N10002BTA Уплотняющее кольцо, коленчатый вал
CORTECO 19027853B Уплотняющее кольцо, коленчатый вал
12016300B Уплотняющее кольцо, коленчатый вал
289128 Комплект прокладок вала, двигатель
ELRING 702.269 Уплотняющее кольцо, коленчатый вал
034.530 Уплотняющее кольцо, коленчатый вал
FAI AutoParts OS2188 Уплотняющее кольцо, коленчатый вал
OS006 Уплотняющее кольцо, коленчатый вал
OS1205 Уплотняющее кольцо, коленчатый вал
GOETZE 50-319161-00 Уплотняющее кольцо, коленчатый вал
PAYEN NJ006 Уплотняющее кольцо, коленчатый вал
NF678 Уплотняющее кольцо, коленчатый вал
TOPRAN 820 222 Уплотняющее кольцо, коленчатый вал
WILMINK GROUP WG1183532 Уплотняющее кольцо, коленчатый вал
WG1085457 Уплотняющее кольцо, коленчатый вал
WG1755322 Комплект прокладок вала, двигатель
WG1183601 Уплотняющее кольцо, коленчатый вал
WG1163050 Уплотняющее кольцо, коленчатый вал
WG1190104 Уплотняющее кольцо, коленчатый вал
WG1163208 Уплотняющее кольцо, коленчатый вал
2026 CATCAR.INFO (v 2.0)