#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTEwNDQ5fHxtZGZfaWQ9PTBeNTI0MjZ8fHNwYXJlX2lkPT0xMDA3ODk%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 = "52426" AND ( (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS5314" AND av.ProductID IN (572)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP24341" AND av.ProductID IN (757)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20034934B" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20036702B" AND av.ProductID IN (757)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20026412B" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "155.560" 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 = "897.690" AND av.ProductID IN (757)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "8456050" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS1663" AND av.ProductID IN (757)) 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 = 88 AND av.DataSupplierArticleNumber = "P76096-11" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77774-01" AND av.ProductID IN (757)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77689-01" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319430-00" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319560-00" AND av.ProductID IN (757)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1119500200" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5361" AND av.ProductID IN (757)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5106" AND av.ProductID IN (572)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "34-00163-SX" AND av.ProductID IN (757)) 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 = 301 AND av.DataSupplierArticleNumber = "109 383" AND av.ProductID IN (572)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "113 628" AND av.ProductID IN (757)) 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-3874" AND av.ProductID IN (757)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-3275" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-90052-00" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-40538-00" AND av.ProductID IN (757)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-34366-00" AND av.ProductID IN (572)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "11030162201" AND av.ProductID IN (572)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "11030879701" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1148983" AND av.ProductID IN (757)) 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 = "WG1104000" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1005039" 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 = "WG1103968" AND av.ProductID IN (757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1086708" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1428878" 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 = 478 AND aa.DataSupplierArticleNumber = "OS5314") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP24341") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20034934B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20036702B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20026412B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "155.560") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "364.700") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "897.690") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8456050") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1663") 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 = 88 AND aa.DataSupplierArticleNumber = "P76096-11") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77774-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77689-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319430-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319560-00") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1119500200") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5361") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5106") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00163-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00007-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2471") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "109 383") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "113 628") 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-3874") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3275") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-90052-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-40538-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-34366-00") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "11030162201") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "11030879701") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1148983") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103936") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004473") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1005039") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192224") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103968") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086708") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428878") ) 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 = 478 AND aa.DataSupplierArticleNumber = "OS5314") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP24341") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20034934B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20036702B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20026412B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "155.560") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "364.700") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "897.690") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8456050") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1663") 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 = 88 AND aa.DataSupplierArticleNumber = "P76096-11") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77774-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77689-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319430-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319560-00") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1119500200") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5361") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5106") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00163-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00007-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2471") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "109 383") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "113 628") 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-3874") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3275") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-90052-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-40538-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-34366-00") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "11030162201") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "11030879701") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1148983") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103936") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004473") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1005039") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192224") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103968") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086708") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428878") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка/комплект прокладок вала для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

Автозапчасти


Производители Артикул Наименование Сведения Полная информация
BGA OS5314 Уплотняющее кольцо, коленчатый вал
BUGIAD BSP24341 Уплотняющее кольцо, распределительный вал
CORTECO 20034934B Уплотняющее кольцо, коленчатый вал
20036702B Уплотняющее кольцо, распределительный вал
20026412B Уплотняющее кольцо, коленчатый вал
ELRING 155.560 Уплотняющее кольцо, коленчатый вал
364.700 Уплотняющее кольцо, коленчатый вал
897.690 Уплотняющее кольцо, распределительный вал
ELWIS ROYAL 8456050 Уплотняющее кольцо, коленчатый вал
FAI AutoParts OS1663 Уплотняющее кольцо, распределительный вал
OS1323 Уплотняющее кольцо, коленчатый вал
OS1662 Уплотняющее кольцо, коленчатый вал
FEBI BILSTEIN 32471 Уплотняющее кольцо, коленчатый вал
GLASER P76096-11 Уплотняющее кольцо, коленчатый вал
P77774-01 Уплотняющее кольцо, распределительный вал
P77689-01 Уплотняющее кольцо, коленчатый вал
GOETZE 50-319430-00 Уплотняющее кольцо, коленчатый вал
50-319560-00 Уплотняющее кольцо, распределительный вал
JP GROUP 1119500200 Уплотняющее кольцо, коленчатый вал
PAYEN NA5361 Уплотняющее кольцо, распределительный вал
NA5106 Уплотняющее кольцо, коленчатый вал
STELLOX 34-00163-SX Уплотняющее кольцо, распределительный вал
34-00007-SX Уплотняющее кольцо, коленчатый вал
SWAG 30 93 2471 Уплотняющее кольцо, коленчатый вал
TOPRAN 109 383 Уплотняющее кольцо, коленчатый вал
113 628 Уплотняющее кольцо, распределительный вал
TRISCAN 8550 29026 Уплотняющее кольцо, коленчатый вал
8550 10050 Уплотняющее кольцо, коленчатый вал
VAICO V10-3874 Уплотняющее кольцо, распределительный вал
V10-3275 Уплотняющее кольцо, коленчатый вал
VICTOR REINZ 81-90052-00 Уплотняющее кольцо, коленчатый вал
81-40538-00 Уплотняющее кольцо, распределительный вал
81-34366-00 Уплотняющее кольцо, коленчатый вал
vika 11030162201 Уплотняющее кольцо, коленчатый вал
11030879701 Уплотняющее кольцо, коленчатый вал
WILMINK GROUP WG1148983 Уплотняющее кольцо, распределительный вал
WG1103936 Уплотняющее кольцо, коленчатый вал
WG1004473 Уплотняющее кольцо, коленчатый вал
WG1104000 Уплотняющее кольцо, коленчатый вал
WG1005039 Уплотняющее кольцо, коленчатый вал
WG1192224 Уплотняющее кольцо, коленчатый вал
WG1103968 Уплотняющее кольцо, распределительный вал
WG1086708 Уплотняющее кольцо, коленчатый вал
WG1428878 Уплотняющее кольцо, коленчатый вал
2026 CATCAR.INFO (v 2.0)