#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTYwM3x8bW9kZWxfaWQ9PTgwNDJ8fG1kZl9pZD09MF43MTk2fHxzcGFyZV9pZD09MTAwNDU1&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 = "7196" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "13631" AND av.ProductID IN (308)) OR (av.SupplierID = 4997 AND av.DataSupplierArticleNumber = "YD205581" AND av.ProductID IN (308)) OR (av.SupplierID = 4576 AND av.DataSupplierArticleNumber = "30680" AND av.ProductID IN (308)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "641298" AND av.ProductID IN (308)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.80448" AND av.ProductID IN (308)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A09392" AND av.ProductID IN (308)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "TDI3458" AND av.ProductID IN (308)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "88830" AND av.ProductID IN (308)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DT16102" AND av.ProductID IN (308)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "T9518" AND av.ProductID IN (308)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "13505" AND av.ProductID IN (308)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FS05091" AND av.ProductID IN (308)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "T43014" AND av.ProductID IN (308)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "531 0547 10" AND av.ProductID IN (308)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "14-0293" AND av.ProductID IN (308)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "R0177" AND av.ProductID IN (308)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI23480" AND av.ProductID IN (308)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1225075" AND av.ProductID IN (308)) OR (av.SupplierID = 197 AND av.DataSupplierArticleNumber = "AA10146" AND av.ProductID IN (308)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PB-1191" AND av.ProductID IN (308)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "54-0556" AND av.ProductID IN (308)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "16-51 902 1001" AND av.ProductID IN (308)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "0-N1111" AND av.ProductID IN (308)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTT1001" AND av.ProductID IN (308)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT2164" AND av.ProductID IN (308)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "55581" AND av.ProductID IN (308)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "1704005" AND av.ProductID IN (308)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 16102" AND av.ProductID IN (308)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "700 786" AND av.ProductID IN (308)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8646 10123" AND av.ProductID IN (308)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V46-0003" AND av.ProductID IN (308)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1252404" 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 = 4598 AND aa.DataSupplierArticleNumber = "13631") OR (aa.SupplierID = 4997 AND aa.DataSupplierArticleNumber = "YD205581") OR (aa.SupplierID = 4576 AND aa.DataSupplierArticleNumber = "30680") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "641298") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80448") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A09392") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI3458") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88830") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT16102") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "T9518") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13505") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS05091") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T43014") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0547 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "14-0293") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0177") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI23480") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1225075") OR (aa.SupplierID = 197 AND aa.DataSupplierArticleNumber = "AA10146") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PB-1191") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "54-0556") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "16-51 902 1001") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1111") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT1001") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2164") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "55581") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "1704005") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 16102") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "700 786") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 10123") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V46-0003") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1252404") ) 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 = 4598 AND aa.DataSupplierArticleNumber = "13631") OR (aa.SupplierID = 4997 AND aa.DataSupplierArticleNumber = "YD205581") OR (aa.SupplierID = 4576 AND aa.DataSupplierArticleNumber = "30680") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "641298") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80448") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A09392") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI3458") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88830") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT16102") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "T9518") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13505") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS05091") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T43014") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0547 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "14-0293") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0177") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI23480") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1225075") OR (aa.SupplierID = 197 AND aa.DataSupplierArticleNumber = "AA10146") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PB-1191") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "54-0556") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "16-51 902 1001") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1111") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT1001") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2164") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "55581") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "1704005") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 16102") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "700 786") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 10123") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V46-0003") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1252404") ) AND aa.Language = "ru" Продажа автозапчастей типа Ролик натяжителя для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

Автозапчасти


Производители Артикул Наименование Сведения Полная информация
3RG 13631 Натяжной ролик, ремень ГРМ
A.B.A YD205581 Натяжной ролик, ремень ГРМ
ASAM 30680 Натяжной ролик, ремень ГРМ
AUTEX 641298 Натяжной ролик, ремень ГРМ
AUTOKIT 03.80448 Натяжной ролик, ремень ГРМ
AUTOTEAM A09392 Натяжной ролик, ремень ГРМ
BREDA LORETT TDI3458 Натяжной ролик, ремень ГРМ
CALIBER 88830 Натяжной ролик, ремень ГРМ
DYNAMATRIX DT16102 Натяжной ролик, ремень ГРМ
FAI AutoParts T9518 Натяжной ролик, ремень ГРМ
FARE SA 13505 Натяжной ролик, ремень ГРМ
FLENNOR FS05091 Натяжной ролик, ремень ГРМ
GATES T43014 Натяжной ролик, ремень ГРМ
INA 531 0547 10 Натяжной ролик, ремень ГРМ
IPD 14-0293 Натяжной ролик, ремень ГРМ
KAMOKA R0177 Натяжной ролик, ремень ГРМ
KM International FI23480 Натяжной ролик, ремень ГРМ
KRAFT AUTOMOTIVE 1225075 Натяжной ролик, ремень ГРМ
LPR AA10146 Натяжной ролик, ремень ГРМ
LYNXauto PB-1191 Натяжной ролик, ремень ГРМ
MAXGEAR 54-0556 Натяжной ролик, ремень ГРМ
MEYLE 16-51 902 1001 Натяжной ролик, ремень ГРМ
OPTIMAL 0-N1111 Натяжной ролик, ремень ГРМ
QUINTON HAZELL QTT1001 Натяжной ролик, ремень ГРМ
REPKIT RKT2164 Натяжной ролик, ремень ГРМ
RUVILLE 55581 Натяжной ролик, ремень ГРМ
SASIC 1704005 Натяжной ролик, ремень ГРМ
SKF VKM 16102 Натяжной ролик, ремень ГРМ
TOPRAN 700 786 Натяжной ролик, ремень ГРМ
TRISCAN 8646 10123 Натяжной ролик, ремень ГРМ
VAICO V46-0003 Натяжной ролик, ремень ГРМ
WILMINK GROUP WG1252404 Натяжной ролик, ремень ГРМ
2026 CATCAR.INFO (v 2.0)