#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNHx8bW9kZWxfaWQ9PTc1Nzh8fG1kZl9pZD09MF41NjI2M3x8c3BhcmVfaWQ9PTEwNDMzMA%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 = "56263" AND ( (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654601" AND av.ProductID IN (1390)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654693" AND av.ProductID IN (1390)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81479" AND av.ProductID IN (1390)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81619" AND av.ProductID IN (1390)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A07944" AND av.ProductID IN (1390)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A08144" AND av.ProductID IN (1390)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "RLA4069" AND av.ProductID IN (1390)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "RLA3839" AND av.ProductID IN (1390)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "88206" AND av.ProductID IN (1390)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "88106" AND av.ProductID IN (1390)) OR (av.SupplierID = 31 AND av.DataSupplierArticleNumber = "AP9018" AND av.ProductID IN (1390)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "219136" AND av.ProductID IN (1390)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "OAP7115" AND av.ProductID IN (1390)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "3 5419 1" AND av.ProductID IN (1390)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "3 5416 1" AND av.ProductID IN (1390)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XU 358 038-761" AND av.ProductID IN (1390)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XU 358 038-901" AND av.ProductID IN (1390)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "30-1133" AND av.ProductID IN (1390)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "30-1069" AND av.ProductID IN (1390)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "535 0178 10" AND av.ProductID IN (1390)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "535 0193 10" AND av.ProductID IN (1390)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3596" AND av.ProductID IN (1390)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3688" AND av.ProductID IN (1390)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI19860" AND av.ProductID IN (1390)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI20360" AND av.ProductID IN (1390)) OR (av.SupplierID = 424 AND av.DataSupplierArticleNumber = "LOPA0137" AND av.ProductID IN (1390)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PA-1125" AND av.ProductID IN (1390)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PA-1136" AND av.ProductID IN (1390)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F5-1113" AND av.ProductID IN (1390)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F5-1132" AND av.ProductID IN (1390)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "P5017810" AND av.ProductID IN (1390)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT3195" AND av.ProductID IN (1390)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT3335" AND av.ProductID IN (1390)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "56650" AND av.ProductID IN (1390)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "59955" AND av.ProductID IN (1390)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 03304" AND av.ProductID IN (1390)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 03881" AND av.ProductID IN (1390)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8641 284006" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253752" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253765" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1152073" AND av.ProductID IN (1390)) ) 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 = "654601") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654693") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81479") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81619") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A07944") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A08144") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA4069") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA3839") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88206") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88106") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9018") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "219136") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "OAP7115") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5419 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5416 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-761") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-901") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1133") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1069") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0178 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0193 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3596") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3688") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI19860") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI20360") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LOPA0137") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1125") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1136") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1113") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1132") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P5017810") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3195") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3335") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56650") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "59955") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03304") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03881") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 284006") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253752") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253765") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152073") ) 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 = "654601") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654693") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81479") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81619") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A07944") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A08144") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA4069") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA3839") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88206") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88106") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9018") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "219136") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "OAP7115") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5419 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5416 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-761") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-901") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1133") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1069") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0178 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0193 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3596") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3688") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI19860") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI20360") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LOPA0137") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1125") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1136") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1113") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1132") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P5017810") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3195") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3335") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56650") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "59955") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03304") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03881") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 284006") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253752") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253765") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152073") ) AND aa.Language = "ru" Продажа автозапчастей типа Механизм свободного хода генератора для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTEX 654601 Механизм свободного хода генератора
654693 Механизм свободного хода генератора
AUTOKIT 03.81479 Механизм свободного хода генератора
03.81619 Механизм свободного хода генератора
AUTOTEAM A07944 Механизм свободного хода генератора
A08144 Механизм свободного хода генератора
BREDA LORETT RLA4069 Механизм свободного хода генератора
RLA3839 Механизм свободного хода генератора
CALIBER 88206 Механизм свободного хода генератора
88106 Механизм свободного хода генератора
CONTITECH AP9018 Механизм свободного хода генератора
ERA 219136 Механизм свободного хода генератора
GATES OAP7115 Механизм свободного хода генератора
GEBE 3 5419 1 Механизм свободного хода генератора
3 5416 1 Механизм свободного хода генератора
HELLA 9XU 358 038-761 Механизм свободного хода генератора
9XU 358 038-901 Механизм свободного хода генератора
IJS GROUP 30-1133 Механизм свободного хода генератора
30-1069 Механизм свободного хода генератора
INA 535 0178 10 Механизм свободного хода генератора
535 0193 10 Механизм свободного хода генератора
IPD 15-3596 Механизм свободного хода генератора
15-3688 Механизм свободного хода генератора
KM International FI19860 Механизм свободного хода генератора
FI20360 Механизм свободного хода генератора
LUCAS ENGINE DRIVE LOPA0137 Механизм свободного хода генератора
LYNXauto PA-1125 Механизм свободного хода генератора
PA-1136 Механизм свободного хода генератора
OPTIMAL F5-1113 Механизм свободного хода генератора
F5-1132 Механизм свободного хода генератора
PATRON P5017810 Механизм свободного хода генератора
REPKIT RKT3195 Механизм свободного хода генератора
RKT3335 Механизм свободного хода генератора
RUVILLE 56650 Механизм свободного хода генератора
59955 Механизм свободного хода генератора
SKF VKM 03304 Механизм свободного хода генератора
VKM 03881 Механизм свободного хода генератора
TRISCAN 8641 284006 Механизм свободного хода генератора
WILMINK GROUP WG1253752 Механизм свободного хода генератора
WG1253765 Механизм свободного хода генератора
WG1152073 Механизм свободного хода генератора
2026 CATCAR.INFO (v 2.0)