#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNnx8bW9kZWxfaWQ9PTExODgwfHxtZGZfaWQ9PTFeMTc2NjJ8fHNwYXJlX2lkPT0yMDAwNDE%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 = "17662" AND ( (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "278.000" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "278.020" AND av.ProductID IN (572)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "45413" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77803-01" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77804-01" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319611-00" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319608-00" AND av.ProductID IN (572)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "79466600" AND av.ProductID IN (1589)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "77969600" AND av.ProductID IN (5017)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5460" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5462" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-37173-00" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-37174-00" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1487836" AND av.ProductID IN (5017)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1145435" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1487837" AND av.ProductID IN (5017)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1700655" AND av.ProductID IN (1589)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1145554" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1487838" AND av.ProductID IN (5017)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1145555" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1145434" 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 = 10 AND aa.DataSupplierArticleNumber = "278.000") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "278.020") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45413") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77803-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77804-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319611-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319608-00") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "79466600") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "77969600") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5460") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5462") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-37173-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-37174-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1487836") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1145435") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1487837") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1700655") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1145554") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1487838") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1145555") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1145434") ) 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 = 10 AND aa.DataSupplierArticleNumber = "278.000") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "278.020") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45413") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77803-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77804-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319611-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319608-00") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "79466600") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "77969600") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5460") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5462") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-37173-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-37174-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1487836") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1145435") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1487837") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1700655") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1145554") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1487838") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1145555") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1145434") ) AND aa.Language = "ru" Продажа автозапчастей типа Коленвал / комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ELRING 278.000 Уплотняющее кольцо, коленчатый вал
278.020 Уплотняющее кольцо, коленчатый вал
FEBI BILSTEIN 45413 Уплотняющее кольцо, коленчатый вал
GLASER P77803-01 Уплотняющее кольцо, коленчатый вал
P77804-01 Уплотняющее кольцо, коленчатый вал
GOETZE 50-319611-00 Уплотняющее кольцо, коленчатый вал
50-319608-00 Уплотняющее кольцо, коленчатый вал
KOLBENSCHMIDT 79466600 Дистанционная шайба, коленчатый вал
77969600 Комплект подшипников коленчатого вала
PAYEN NA5460 Уплотняющее кольцо, коленчатый вал
NA5462 Уплотняющее кольцо, коленчатый вал
VICTOR REINZ 81-37173-00 Уплотняющее кольцо, коленчатый вал
81-37174-00 Уплотняющее кольцо, коленчатый вал
WILMINK GROUP WG1487836 Комплект подшипников коленчатого вала
WG1145435 Уплотняющее кольцо, коленчатый вал
WG1487837 Комплект подшипников коленчатого вала
WG1700655 Дистанционная шайба, коленчатый вал
WG1145554 Уплотняющее кольцо, коленчатый вал
WG1487838 Комплект подшипников коленчатого вала
WG1145555 Уплотняющее кольцо, коленчатый вал
WG1145434 Уплотняющее кольцо, коленчатый вал
2026 CATCAR.INFO (v 2.0)