#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1NXx8bW9kZWxfaWQ9PTYyMzN8fG1kZl9pZD09MF4yMjQ5Mnx8c3BhcmVfaWQ9PTEwNDMxMQ%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 = "22492" AND ( (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "RT1706" AND av.ProductID IN (310)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A08172" AND av.ProductID IN (310)) OR (av.SupplierID = 4679 AND av.DataSupplierArticleNumber = "385-99" AND av.ProductID IN (310)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "88220" AND av.ProductID IN (310)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "P258001" AND av.ProductID IN (310)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DT65055" AND av.ProductID IN (310)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "0487-CW5W" AND av.ProductID IN (310)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "T39053" AND av.ProductID IN (310)) OR (av.SupplierID = 201 AND av.DataSupplierArticleNumber = "DTP-5511" AND av.ProductID IN (310)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI20430" AND av.ProductID IN (310)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1228517" AND av.ProductID IN (310)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PB-5139" AND av.ProductID IN (310)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "0-N2112S" AND av.ProductID IN (310)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PT65055" AND av.ProductID IN (310)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 65055" AND av.ProductID IN (310)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "GA373.01" AND av.ProductID IN (310)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "03-40589-SX" AND av.ProductID IN (310)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "03-40609-SX" AND av.ProductID IN (310)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1784693" AND av.ProductID IN (310)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "SR-1042" AND av.ProductID IN (310)) ) 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 = 4737 AND aa.DataSupplierArticleNumber = "RT1706") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A08172") OR (aa.SupplierID = 4679 AND aa.DataSupplierArticleNumber = "385-99") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88220") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "P258001") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT65055") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "0487-CW5W") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T39053") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "DTP-5511") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI20430") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1228517") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PB-5139") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N2112S") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PT65055") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 65055") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GA373.01") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "03-40589-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "03-40609-SX") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1784693") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "SR-1042") ) 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 = 4737 AND aa.DataSupplierArticleNumber = "RT1706") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A08172") OR (aa.SupplierID = 4679 AND aa.DataSupplierArticleNumber = "385-99") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88220") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "P258001") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT65055") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "0487-CW5W") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T39053") OR (aa.SupplierID = 201 AND aa.DataSupplierArticleNumber = "DTP-5511") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI20430") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1228517") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PB-5139") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N2112S") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PT65055") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 65055") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GA373.01") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "03-40589-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "03-40609-SX") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1784693") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "SR-1042") ) AND aa.Language = "ru" Продажа автозапчастей типа Ролик натяжителя для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTLOG RT1706 Натяжной ролик, поликлиновойремень
AUTOTEAM A08172 Натяжной ролик, поликлиновойремень
CAFFARO 385-99 Натяжной ролик, поликлиновойремень
CALIBER 88220 Натяжной ролик, поликлиновойремень
DENCKERMANN P258001 Натяжной ролик, поликлиновойремень
DYNAMATRIX DT65055 Натяжной ролик, поликлиновойремень
FEBEST 0487-CW5W Натяжной ролик, поликлиновойремень
GATES T39053 Натяжной ролик, поликлиновойремень
KAVO PARTS DTP-5511 Натяжной ролик, поликлиновойремень
KM International FI20430 Натяжной ролик, поликлиновойремень
KRAFT AUTOMOTIVE 1228517 Натяжной ролик, поликлиновойремень
LYNXauto PB-5139 Натяжной ролик, поликлиновойремень
OPTIMAL 0-N2112S Натяжной ролик, поликлиновойремень
PATRON PT65055 Натяжной ролик, поликлиновойремень
SKF VKM 65055 Натяжной ролик, поликлиновойремень
SNR GA373.01 Натяжной ролик, поликлиновойремень
STELLOX 03-40589-SX Натяжной ролик, поликлиновойремень
03-40609-SX Натяжной ролик, поликлиновойремень
WILMINK GROUP WG1784693 Натяжной ролик, поликлиновойремень
ZEKKERT SR-1042 Натяжной ролик, поликлиновойремень
2026 CATCAR.INFO (v 2.0)