#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3NXx8bW9kZWxfaWQ9PTc1ODh8fG1kZl9pZD09MF4yODI4Mnx8c3BhcmVfaWQ9PTEwMDUyMQ%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 = "28282" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "71007300" AND av.ProductID IN (572)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15083100" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OC6326" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS8372" AND av.ProductID IN (572)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP21170" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20026412B" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20034934B" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "364.700" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "155.560" AND av.ProductID IN (572)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "8456050" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS1323" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS1662" AND av.ProductID IN (572)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "32471" AND av.ProductID IN (572)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "36383" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77689-01" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P76096-11" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319430-00" AND av.ProductID IN (572)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1119500200" AND av.ProductID IN (572)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 103 1000" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5106" AND av.ProductID IN (572)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "34-00007-SX" AND av.ProductID IN (572)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 2471" AND av.ProductID IN (572)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 6383" AND av.ProductID IN (572)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "109 383" AND av.ProductID IN (572)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 29026" AND av.ProductID IN (572)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 10050" AND av.ProductID IN (572)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-3275" AND av.ProductID IN (572)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-3680" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-34366-00" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-90052-00" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1428878" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1163600" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1086708" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1429026" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1177354" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1103936" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1004473" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1192224" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1104000" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1005039" 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 = "71007300") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15083100") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OC6326") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS8372") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP21170") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20026412B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20034934B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "364.700") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "155.560") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8456050") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1323") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1662") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32471") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36383") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77689-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76096-11") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319430-00") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1119500200") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 103 1000") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5106") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00007-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2471") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 6383") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "109 383") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 29026") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10050") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3275") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3680") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-34366-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-90052-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428878") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163600") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086708") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1429026") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177354") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103936") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004473") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192224") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1005039") ) 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 = "71007300") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15083100") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OC6326") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS8372") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP21170") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20026412B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20034934B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "364.700") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "155.560") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8456050") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1323") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1662") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32471") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36383") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77689-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76096-11") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319430-00") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1119500200") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 103 1000") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5106") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00007-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2471") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 6383") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "109 383") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 29026") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10050") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3275") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3680") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-34366-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-90052-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428878") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163600") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086708") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1429026") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177354") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103936") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004473") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192224") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1005039") ) AND aa.Language = "ru" Продажа автозапчастей типа Сальник / комплект сальников вала для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 71007300 Уплотняющее кольцо, коленчатый вал
15083100 Уплотняющее кольцо, коленчатый вал
BGA OC6326 Уплотняющее кольцо, коленчатый вал
OS8372 Уплотняющее кольцо, коленчатый вал
BUGIAD BSP21170 Уплотняющее кольцо, коленчатый вал
CORTECO 20026412B Уплотняющее кольцо, коленчатый вал
20034934B Уплотняющее кольцо, коленчатый вал
ELRING 364.700 Уплотняющее кольцо, коленчатый вал
155.560 Уплотняющее кольцо, коленчатый вал
ELWIS ROYAL 8456050 Уплотняющее кольцо, коленчатый вал
FAI AutoParts OS1323 Уплотняющее кольцо, коленчатый вал
OS1662 Уплотняющее кольцо, коленчатый вал
FEBI BILSTEIN 32471 Уплотняющее кольцо, коленчатый вал
36383 Уплотняющее кольцо, коленчатый вал
GLASER P77689-01 Уплотняющее кольцо, коленчатый вал
P76096-11 Уплотняющее кольцо, коленчатый вал
GOETZE 50-319430-00 Уплотняющее кольцо, коленчатый вал
JP GROUP 1119500200 Уплотняющее кольцо, коленчатый вал
MEYLE 100 103 1000 Уплотняющее кольцо, коленчатый вал
PAYEN NA5106 Уплотняющее кольцо, коленчатый вал
STELLOX 34-00007-SX Уплотняющее кольцо, коленчатый вал
SWAG 30 93 2471 Уплотняющее кольцо, коленчатый вал
30 93 6383 Уплотняющее кольцо, коленчатый вал
TOPRAN 109 383 Уплотняющее кольцо, коленчатый вал
TRISCAN 8550 29026 Уплотняющее кольцо, коленчатый вал
8550 10050 Уплотняющее кольцо, коленчатый вал
VAICO V10-3275 Уплотняющее кольцо, коленчатый вал
V10-3680 Уплотняющее кольцо, коленчатый вал
VICTOR REINZ 81-34366-00 Уплотняющее кольцо, коленчатый вал
81-90052-00 Уплотняющее кольцо, коленчатый вал
WILMINK GROUP WG1428878 Уплотняющее кольцо, коленчатый вал
WG1163600 Уплотняющее кольцо, коленчатый вал
WG1086708 Уплотняющее кольцо, коленчатый вал
WG1429026 Уплотняющее кольцо, коленчатый вал
WG1177354 Уплотняющее кольцо, коленчатый вал
WG1103936 Уплотняющее кольцо, коленчатый вал
WG1004473 Уплотняющее кольцо, коленчатый вал
WG1192224 Уплотняющее кольцо, коленчатый вал
WG1104000 Уплотняющее кольцо, коленчатый вал
WG1005039 Уплотняющее кольцо, коленчатый вал
2026 CATCAR.INFO (v 2.0)