#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTM1Mzh8fG1kZl9pZD09MV4xMTg0NHx8c3BhcmVfaWQ9PTIwMDA0MQ%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 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 = "11844" AND ( (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "15027677B" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20029606B" AND av.ProductID IN (572)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "33144" AND av.ProductID IN (572)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "44579" AND av.ProductID IN (572)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "021.453" AND av.ProductID IN (3702)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "021.261" AND av.ProductID IN (574)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "021.451" AND av.ProductID IN (3702)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1226540" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1223986" 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 = 140 AND aa.DataSupplierArticleNumber = "15027677B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20029606B") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "33144") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44579") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.453") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.261") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.451") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1226540") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1223986") ) 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 = 140 AND aa.DataSupplierArticleNumber = "15027677B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20029606B") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "33144") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44579") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.453") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.261") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.451") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1226540") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1223986") ) AND aa.Language = "ru" Продажа автозапчастей типа Коленвал / комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
CORTECO 15027677B Уплотняющее кольцо, коленчатый вал
20029606B Уплотняющее кольцо, коленчатый вал
FEBI BILSTEIN 33144 Уплотняющее кольцо, коленчатый вал
44579 Уплотняющее кольцо, коленчатый вал
SAMPA 021.453 Коленчатый вал
021.261 Подшипник коленвала
021.451 Коленчатый вал
WILMINK GROUP WG1226540 Уплотняющее кольцо, коленчатый вал
WG1223986 Уплотняющее кольцо, коленчатый вал
2026 CATCAR.INFO (v 2.0)