#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2M3x8bW9kZWxfaWQ9PTM4N3x8bWRmX2lkPT0wXjI0MTh8fHNwYXJlX2lkPT0xMDAwNTM%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 = "2418" AND ( (av.SupplierID = 4428 AND av.DataSupplierArticleNumber = "069 0471" AND av.ProductID IN (262)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "320 0209 10" AND av.ProductID IN (262)) OR (av.SupplierID = 4559 AND av.DataSupplierArticleNumber = "MD3113" AND av.ProductID IN (262)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "C1619AF" AND av.ProductID IN (262)) OR (av.SupplierID = 32 AND av.DataSupplierArticleNumber = "1862 882 042" AND av.ProductID IN (262)) OR (av.SupplierID = 294 AND av.DataSupplierArticleNumber = "881864 99V104" AND av.ProductID IN (262,262)) OR (av.SupplierID = 294 AND av.DataSupplierArticleNumber = "881861 999723" AND av.ProductID IN (262,262)) OR (av.SupplierID = 294 AND av.DataSupplierArticleNumber = "881864 002628" AND av.ProductID IN (262,262)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "803131" AND av.ProductID IN (262)) ) 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 = 4428 AND aa.DataSupplierArticleNumber = "069 0471") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "320 0209 10") OR (aa.SupplierID = 4559 AND aa.DataSupplierArticleNumber = "MD3113") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "C1619AF") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "1862 882 042") OR (aa.SupplierID = 294 AND aa.DataSupplierArticleNumber = "881864 99V104") OR (aa.SupplierID = 294 AND aa.DataSupplierArticleNumber = "881861 999723") OR (aa.SupplierID = 294 AND aa.DataSupplierArticleNumber = "881864 002628") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "803131") ) 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 = 4428 AND aa.DataSupplierArticleNumber = "069 0471") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "320 0209 10") OR (aa.SupplierID = 4559 AND aa.DataSupplierArticleNumber = "MD3113") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "C1619AF") OR (aa.SupplierID = 32 AND aa.DataSupplierArticleNumber = "1862 882 042") OR (aa.SupplierID = 294 AND aa.DataSupplierArticleNumber = "881864 99V104") OR (aa.SupplierID = 294 AND aa.DataSupplierArticleNumber = "881861 999723") OR (aa.SupplierID = 294 AND aa.DataSupplierArticleNumber = "881864 002628") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "803131") ) AND aa.Language = "ru" Продажа автозапчастей типа Диск сцепления для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
KM Germany 069 0471 Диск сцепления
LuK 320 0209 10 Диск сцепления
MECARM MD3113 Диск сцепления
QUINTON HAZELL C1619AF Диск сцепления
SACHS 1862 882 042 Диск сцепления
SACHS PERFORMANCE 881864 99V104 Диск сцепления
881861 999723 Диск сцепления
881864 002628 Диск сцепления
VALEO 803131 Диск сцепления
2026 CATCAR.INFO (v 2.0)