#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2Nnx8bW9kZWxfaWQ9PTE4OTZ8fG1kZl9pZD09MF4zMDk0NXx8c3BhcmVfaWQ9PTEwMDQ2MQ%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 = "30945" AND ( (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A03728" AND av.ProductID IN (545)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "57166" AND av.ProductID IN (545)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI9320" AND av.ProductID IN (545)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MTT-5124" AND av.ProductID IN (545)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MTT-5125" AND av.ProductID IN (545)) ) 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 = 4464 AND aa.DataSupplierArticleNumber = "A03728") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "57166") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI9320") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTT-5124") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTT-5125") ) 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 = 4464 AND aa.DataSupplierArticleNumber = "A03728") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "57166") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI9320") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTT-5124") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTT-5125") ) AND aa.Language = "ru" Продажа автозапчастей типа Натяжитель ремня / успокоитель для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTOTEAM A03728 Устройство для натяжения ремня, ремень ГРМ
CALIBER 57166 Устройство для натяжения ремня, ремень ГРМ
KM International FI9320 Устройство для натяжения ремня, ремень ГРМ
MDR MTT-5124 Устройство для натяжения ремня, ремень ГРМ
MTT-5125 Устройство для натяжения ремня, ремень ГРМ
2026 CATCAR.INFO (v 2.0)