#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTEzMTJ8fG1kZl9pZD09MF45NTMzfHxzcGFyZV9pZD09MTAwNDA2&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 = "9533" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "13719" AND av.ProductID IN (308)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "641858" AND av.ProductID IN (308)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "RT1389" AND av.ProductID IN (308)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.80423" AND av.ProductID IN (308)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A04180" AND av.ProductID IN (308)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "TDI3496" AND av.ProductID IN (308)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP23113" AND av.ProductID IN (308)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "47261" AND av.ProductID IN (308)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "ATB2253" AND av.ProductID IN (308)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DT11250" AND av.ProductID IN (308)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "T9405" AND av.ProductID IN (308)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "13507" AND av.ProductID IN (308)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "2387-B5" AND av.ProductID IN (308)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "21706" AND av.ProductID IN (308)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "T43091" AND av.ProductID IN (308)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "HTG 186" AND av.ProductID IN (308)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "531 0565 30" AND av.ProductID IN (308)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "14-0853" AND av.ProductID IN (308)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1112203109" AND av.ProductID IN (308)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1112203100" AND av.ProductID IN (308)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "R0211" AND av.ProductID IN (308)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI10450" AND av.ProductID IN (308)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1220127" AND av.ProductID IN (308)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PB-1001" AND av.ProductID IN (308)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "54-0440" AND av.ProductID IN (308)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "0-N1045" AND av.ProductID IN (308)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "1014-0565" AND av.ProductID IN (308)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT2139" AND av.ProductID IN (308)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "55739" AND av.ProductID IN (308)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "1706005" AND av.ProductID IN (308)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 11250" AND av.ProductID IN (308)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "GT357.51" AND av.ProductID IN (308)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 92 1706" AND av.ProductID IN (308)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "423966" AND av.ProductID IN (308)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8646 29142" AND av.ProductID IN (308)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.12.111" AND av.ProductID IN (308)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1252415" AND av.ProductID IN (308)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1428547" 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 = "13719") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "641858") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RT1389") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80423") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A04180") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI3496") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP23113") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "47261") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ATB2253") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT11250") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "T9405") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13507") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "2387-B5") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "21706") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T43091") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "HTG 186") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0565 30") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "14-0853") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1112203109") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1112203100") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0211") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI10450") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1220127") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PB-1001") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "54-0440") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1045") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "1014-0565") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2139") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "55739") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "1706005") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 11250") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GT357.51") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 1706") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "423966") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 29142") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.12.111") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1252415") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428547") ) 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 = "13719") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "641858") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "RT1389") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80423") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A04180") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI3496") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP23113") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "47261") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ATB2253") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT11250") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "T9405") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "13507") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "2387-B5") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "21706") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T43091") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "HTG 186") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0565 30") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "14-0853") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1112203109") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1112203100") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0211") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI10450") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1220127") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PB-1001") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "54-0440") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1045") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "1014-0565") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2139") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "55739") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "1706005") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 11250") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GT357.51") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 1706") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "423966") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 29142") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.12.111") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1252415") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428547") ) AND aa.Language = "ru" Продажа автозапчастей типа Ролик натяжителя для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

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


Производители Артикул Наименование Сведения Полная информация
3RG 13719 Натяжной ролик, ремень ГРМ
AUTEX 641858 Натяжной ролик, ремень ГРМ
AUTLOG RT1389 Натяжной ролик, ремень ГРМ
AUTOKIT 03.80423 Натяжной ролик, ремень ГРМ
AUTOTEAM A04180 Натяжной ролик, ремень ГРМ
BREDA LORETT TDI3496 Натяжной ролик, ремень ГРМ
BUGIAD BSP23113 Натяжной ролик, ремень ГРМ
CALIBER 47261 Натяжной ролик, ремень ГРМ
DAYCO ATB2253 Натяжной ролик, ремень ГРМ
DYNAMATRIX DT11250 Натяжной ролик, ремень ГРМ
FAI AutoParts T9405 Натяжной ролик, ремень ГРМ
FARE SA 13507 Натяжной ролик, ремень ГРМ
FEBEST 2387-B5 Натяжной ролик, ремень ГРМ
FEBI BILSTEIN 21706 Натяжной ролик, ремень ГРМ
GATES T43091 Натяжной ролик, ремень ГРМ
HUTCHINSON HTG 186 Натяжной ролик, ремень ГРМ
INA 531 0565 30 Натяжной ролик, ремень ГРМ
IPD 14-0853 Натяжной ролик, ремень ГРМ
JP GROUP 1112203109 Натяжной ролик, ремень ГРМ
1112203100 Натяжной ролик, ремень ГРМ
KAMOKA R0211 Натяжной ролик, ремень ГРМ
KM International FI10450 Натяжной ролик, ремень ГРМ
KRAFT AUTOMOTIVE 1220127 Натяжной ролик, ремень ГРМ
LYNXauto PB-1001 Натяжной ролик, ремень ГРМ
MAXGEAR 54-0440 Натяжной ролик, ремень ГРМ
OPTIMAL 0-N1045 Натяжной ролик, ремень ГРМ
PROFIT 1014-0565 Натяжной ролик, ремень ГРМ
REPKIT RKT2139 Натяжной ролик, ремень ГРМ
RUVILLE 55739 Натяжной ролик, ремень ГРМ
SASIC 1706005 Натяжной ролик, ремень ГРМ
SKF VKM 11250 Натяжной ролик, ремень ГРМ
SNR GT357.51 Натяжной ролик, ремень ГРМ
SWAG 30 92 1706 Натяжной ролик, ремень ГРМ
TRICLO 423966 Натяжной ролик, ремень ГРМ
TRISCAN 8646 29142 Натяжной ролик, ремень ГРМ
TRUCKTEC AUTOMOTIVE 07.12.111 Натяжной ролик, ремень ГРМ
WILMINK GROUP WG1252415 Натяжной ролик, ремень ГРМ
WG1428547 Натяжной ролик, ремень ГРМ
2026 CATCAR.INFO (v 2.0)