#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTM0MDV8fG1kZl9pZD09MF4xNTMzOXx8c3BhcmVfaWQ9PTEwNDMzMA%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 = "15339" AND ( (av.SupplierID = 4528 AND av.DataSupplierArticleNumber = "885110" AND av.ProductID IN (1390)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654595" AND av.ProductID IN (1390)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81239" AND av.ProductID IN (1390)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A07476" AND av.ProductID IN (1390)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BBA5040" AND av.ProductID IN (1390)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "RLA3862" AND av.ProductID IN (1390)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "87872" AND av.ProductID IN (1390)) OR (av.SupplierID = 31 AND av.DataSupplierArticleNumber = "AP9003" AND av.ProductID IN (1390)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "ALP2405" AND av.ProductID IN (1390)) OR (av.SupplierID = 4969 AND av.DataSupplierArticleNumber = "11SKV058" AND av.ProductID IN (1390)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "32315" AND av.ProductID IN (1390)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "455063" AND av.ProductID IN (1390)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "OAP7031" AND av.ProductID IN (1390)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "3 3571 1" AND av.ProductID IN (1390)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XU 358 038-381" AND av.ProductID IN (1390)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "4555063" AND av.ProductID IN (1390)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "535 0172 10" AND av.ProductID IN (1390)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3590" AND av.ProductID IN (1390)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI18690" AND av.ProductID IN (1390)) OR (av.SupplierID = 424 AND av.DataSupplierArticleNumber = "LOPA0128" AND av.ProductID IN (1390)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PA-1120" AND av.ProductID IN (1390)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "14750" AND av.ProductID IN (1390)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "45063" AND av.ProductID IN (1390)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F5-1050" AND av.ProductID IN (1390)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT2955" AND av.ProductID IN (1390)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "55381" AND av.ProductID IN (1390)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "455063" AND av.ProductID IN (1390)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 03504" AND av.ProductID IN (1390)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "GA753.04" AND av.ProductID IN (1390)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 93 2315" AND av.ProductID IN (1390)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8641 244006" AND av.ProductID IN (1390)) OR (av.SupplierID = 4730 AND av.DataSupplierArticleNumber = "431558" AND av.ProductID IN (1390)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "588007" AND av.ProductID IN (1390)) OR (av.SupplierID = 4627 AND av.DataSupplierArticleNumber = "24-91276" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253746" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1152058" 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 = 4528 AND aa.DataSupplierArticleNumber = "885110") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654595") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81239") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A07476") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BBA5040") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA3862") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "87872") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9003") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ALP2405") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "11SKV058") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32315") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "455063") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "OAP7031") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 3571 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-381") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "4555063") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0172 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3590") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI18690") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LOPA0128") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1120") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "14750") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "45063") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1050") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2955") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "55381") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "455063") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03504") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GA753.04") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 93 2315") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 244006") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "431558") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "588007") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "24-91276") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253746") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152058") ) 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 = 4528 AND aa.DataSupplierArticleNumber = "885110") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654595") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81239") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A07476") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BBA5040") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA3862") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "87872") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9003") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ALP2405") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "11SKV058") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32315") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "455063") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "OAP7031") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 3571 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-381") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "4555063") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0172 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3590") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI18690") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LOPA0128") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1120") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "14750") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "45063") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1050") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2955") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "55381") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "455063") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03504") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GA753.04") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 93 2315") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 244006") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "431558") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "588007") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "24-91276") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253746") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152058") ) AND aa.Language = "ru" Продажа автозапчастей типа Механизм свободного хода генератора для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

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


Производители Артикул Наименование Сведения Полная информация
AD KÜHNER 885110 Механизм свободного хода генератора
AUTEX 654595 Механизм свободного хода генератора
AUTOKIT 03.81239 Механизм свободного хода генератора
AUTOTEAM A07476 Механизм свободного хода генератора
BORG & BECK BBA5040 Механизм свободного хода генератора
BREDA LORETT RLA3862 Механизм свободного хода генератора
CALIBER 87872 Механизм свободного хода генератора
CONTITECH AP9003 Механизм свободного хода генератора
DAYCO ALP2405 Механизм свободного хода генератора
ESEN SKV 11SKV058 Механизм свободного хода генератора
FEBI BILSTEIN 32315 Механизм свободного хода генератора
FISPA 455063 Механизм свободного хода генератора
GATES OAP7031 Механизм свободного хода генератора
GEBE 3 3571 1 Механизм свободного хода генератора
HELLA 9XU 358 038-381 Механизм свободного хода генератора
HOFFER 4555063 Механизм свободного хода генератора
INA 535 0172 10 Механизм свободного хода генератора
IPD 15-3590 Механизм свободного хода генератора
KM International FI18690 Механизм свободного хода генератора
LUCAS ENGINE DRIVE LOPA0128 Механизм свободного хода генератора
LYNXauto PA-1120 Механизм свободного хода генератора
MAPCO 14750 Механизм свободного хода генератора
MEAT & DORIA 45063 Механизм свободного хода генератора
OPTIMAL F5-1050 Механизм свободного хода генератора
REPKIT RKT2955 Механизм свободного хода генератора
RUVILLE 55381 Механизм свободного хода генератора
SIDAT 455063 Механизм свободного хода генератора
SKF VKM 03504 Механизм свободного хода генератора
SNR GA753.04 Механизм свободного хода генератора
SWAG 40 93 2315 Механизм свободного хода генератора
TRISCAN 8641 244006 Механизм свободного хода генератора
UNIGOM 431558 Механизм свободного хода генератора
VALEO 588007 Механизм свободного хода генератора
WAI 24-91276 Механизм свободного хода генератора
WILMINK GROUP WG1253746 Механизм свободного хода генератора
WG1152058 Механизм свободного хода генератора
2026 CATCAR.INFO (v 2.0)