#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2OHx8bW9kZWxfaWQ9PTk0fHxtZGZfaWQ9PTBeMTM4NTN8fHNwYXJlX2lkPT0xMDA0MDY%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 = "13853" AND ( (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "641209" AND av.ProductID IN (308)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.134" AND av.ProductID IN (308)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "TDI3319" AND av.ProductID IN (308)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "ATB2156" AND av.ProductID IN (308)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DT17310" AND av.ProductID IN (308)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "T3558" AND av.ProductID IN (308)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "08467" AND av.ProductID IN (308)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FS06209" AND av.ProductID IN (308)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "T41169" AND av.ProductID IN (308)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "HTG 122" AND av.ProductID IN (308)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "531 0075 10" AND av.ProductID IN (308)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "14-0204" AND av.ProductID IN (308)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "4412200109" AND av.ProductID IN (308)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1228340" AND av.ProductID IN (308)) OR (av.SupplierID = 197 AND av.DataSupplierArticleNumber = "AA10132" AND av.ProductID IN (308)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "23664" AND av.ProductID IN (308)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "45-51 902 1001" AND av.ProductID IN (308)) OR (av.SupplierID = 64 AND av.DataSupplierArticleNumber = "258ST" AND av.ProductID IN (308)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "0-N894" AND av.ProductID IN (308)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTT436FK" AND av.ProductID IN (4644)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTT436" AND av.ProductID IN (308)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT1140" AND av.ProductID IN (308)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "56104" AND av.ProductID IN (308)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 17310" AND av.ProductID IN (308)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "GT361.05" AND av.ProductID IN (308)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "22 03 0001" AND av.ProductID IN (308)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8646 17103" AND av.ProductID IN (308)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V49-0007" AND av.ProductID IN (308)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1097431" AND av.ProductID IN (308)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1428182" AND av.ProductID IN (308)) ) 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 = 300 AND aa.DataSupplierArticleNumber = "641209") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.134") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI3319") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ATB2156") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT17310") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "T3558") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08467") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS06209") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T41169") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "HTG 122") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0075 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "14-0204") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "4412200109") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1228340") OR (aa.SupplierID = 197 AND aa.DataSupplierArticleNumber = "AA10132") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "23664") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "45-51 902 1001") OR (aa.SupplierID = 64 AND aa.DataSupplierArticleNumber = "258ST") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N894") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT436FK") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT436") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1140") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56104") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 17310") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GT361.05") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "22 03 0001") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 17103") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V49-0007") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1097431") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428182") ) 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 = 300 AND aa.DataSupplierArticleNumber = "641209") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.134") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI3319") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ATB2156") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT17310") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "T3558") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08467") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS06209") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T41169") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "HTG 122") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0075 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "14-0204") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "4412200109") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1228340") OR (aa.SupplierID = 197 AND aa.DataSupplierArticleNumber = "AA10132") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "23664") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "45-51 902 1001") OR (aa.SupplierID = 64 AND aa.DataSupplierArticleNumber = "258ST") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N894") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT436FK") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT436") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1140") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56104") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 17310") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GT361.05") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "22 03 0001") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 17103") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V49-0007") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1097431") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428182") ) AND aa.Language = "ru" Продажа автозапчастей типа Ролик натяжителя для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTEX 641209 Натяжной ролик, ремень ГРМ
AUTOKIT 03.134 Натяжной ролик, ремень ГРМ
BREDA LORETT TDI3319 Натяжной ролик, ремень ГРМ
DAYCO ATB2156 Натяжной ролик, ремень ГРМ
DYNAMATRIX DT17310 Натяжной ролик, ремень ГРМ
FAI AutoParts T3558 Натяжной ролик, ремень ГРМ
FEBI BILSTEIN 08467 Натяжной ролик, ремень ГРМ
FLENNOR FS06209 Натяжной ролик, ремень ГРМ
GATES T41169 Натяжной ролик, ремень ГРМ
HUTCHINSON HTG 122 Натяжной ролик, ремень ГРМ
INA 531 0075 10 Натяжной ролик, ремень ГРМ
IPD 14-0204 Натяжной ролик, ремень ГРМ
JP GROUP 4412200109 Натяжной ролик, ремень ГРМ
KRAFT AUTOMOTIVE 1228340 Натяжной ролик, ремень ГРМ
LPR AA10132 Натяжной ролик, ремень ГРМ
MAPCO 23664 Натяжной ролик, ремень ГРМ
MEYLE 45-51 902 1001 Натяжной ролик, ремень ГРМ
OPTIBELT 258ST Натяжной ролик, ремень ГРМ
OPTIMAL 0-N894 Натяжной ролик, ремень ГРМ
QUINTON HAZELL QTT436FK Монтажный комплект, натяжн./паразитн.ролик (зубчатый ремень)
QTT436 Натяжной ролик, ремень ГРМ
REPKIT RKT1140 Натяжной ролик, ремень ГРМ
RUVILLE 56104 Натяжной ролик, ремень ГРМ
SKF VKM 17310 Натяжной ролик, ремень ГРМ
SNR GT361.05 Натяжной ролик, ремень ГРМ
SWAG 22 03 0001 Натяжной ролик, ремень ГРМ
TRISCAN 8646 17103 Натяжной ролик, ремень ГРМ
VAICO V49-0007 Натяжной ролик, ремень ГРМ
WILMINK GROUP WG1097431 Натяжной ролик, ремень ГРМ
WG1428182 Натяжной ролик, ремень ГРМ
2026 CATCAR.INFO (v 2.0)