#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTUwMDN8fG1kZl9pZD09MF4xNzM2MXx8c3BhcmVfaWQ9PTEwMDM1OQ%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 = "17361" AND ( (av.SupplierID = 4528 AND av.DataSupplierArticleNumber = "101294" AND av.ProductID IN (2)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "ST1768" AND av.ProductID IN (2)) OR (av.SupplierID = 4843 AND av.DataSupplierArticleNumber = "S3055" AND av.ProductID IN (2)) OR (av.SupplierID = 412 AND av.DataSupplierArticleNumber = "A 20 240" AND av.ProductID IN (2)) OR (av.SupplierID = 4842 AND av.DataSupplierArticleNumber = "AEU1294" AND av.ProductID IN (2)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "SVA199" AND av.ProductID IN (2)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BST2219" AND av.ProductID IN (2)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B18165" AND av.ProductID IN (2)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 986 020 240" AND av.ProductID IN (2)) OR (av.SupplierID = 484 AND av.DataSupplierArticleNumber = "CST15199GS" AND av.ProductID IN (2)) OR (av.SupplierID = 393 AND av.DataSupplierArticleNumber = "3038" AND av.ProductID IN (2)) OR (av.SupplierID = 28 AND av.DataSupplierArticleNumber = "300.565.103.210" AND av.ProductID IN (2)) OR (av.SupplierID = 28 AND av.DataSupplierArticleNumber = "300.565.103.500" AND av.ProductID IN (2)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "311208102" AND av.ProductID IN (2)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "25-3222" AND av.ProductID IN (2)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "220445" AND av.ProductID IN (2)) OR (av.SupplierID = 224 AND av.DataSupplierArticleNumber = "RE83548N" AND av.ProductID IN (2)) OR (av.SupplierID = 337 AND av.DataSupplierArticleNumber = "11020240" AND av.ProductID IN (2)) OR (av.SupplierID = 90 AND av.DataSupplierArticleNumber = "105141" AND av.ProductID IN (2)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "ST32228" AND av.ProductID IN (2)) OR (av.SupplierID = 87 AND av.DataSupplierArticleNumber = "8020240" AND av.ProductID IN (2)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "6 0082 9" AND av.ProductID IN (2)) OR (av.SupplierID = 4819 AND av.DataSupplierArticleNumber = "114163" AND av.ProductID IN (2)) OR (av.SupplierID = 425 AND av.DataSupplierArticleNumber = "CS1294" AND av.ProductID IN (2)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8EA 738 157-001" AND av.ProductID IN (2)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8EA 012 526-521" AND av.ProductID IN (2)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "42020240" AND av.ProductID IN (2)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1190305000" AND av.ProductID IN (2)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1190305009" AND av.ProductID IN (2)) OR (av.SupplierID = 4496 AND av.DataSupplierArticleNumber = "22.1294" AND av.ProductID IN (2)) OR (av.SupplierID = 20 AND av.DataSupplierArticleNumber = "LRS01676" AND av.ProductID IN (2)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "944280202400" AND av.ProductID IN (2)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "13878" AND av.ProductID IN (2)) OR (av.SupplierID = 342 AND av.DataSupplierArticleNumber = "220445" AND av.ProductID IN (2)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "4720240" AND av.ProductID IN (2)) OR (av.SupplierID = 4543 AND av.DataSupplierArticleNumber = "8213184" AND av.ProductID IN (2)) OR (av.SupplierID = 4543 AND av.DataSupplierArticleNumber = "88213184" AND av.ProductID IN (2)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QRS1247" AND av.ProductID IN (2)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "RAS41351" AND av.ProductID IN (2)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DRT0240" AND av.ProductID IN (2)) OR (av.SupplierID = 4620 AND av.DataSupplierArticleNumber = "F042S0H094" AND av.ProductID IN (2)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "458213" AND av.ProductID IN (2)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "438171" AND av.ProductID IN (2)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-12-20240" AND av.ProductID IN (2)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99110596601" AND av.ProductID IN (2)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99110025701" AND av.ProductID IN (2)) OR (av.SupplierID = 4627 AND av.DataSupplierArticleNumber = "17967N" AND av.ProductID IN (2)) ) 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 = "101294") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "ST1768") OR (aa.SupplierID = 4843 AND aa.DataSupplierArticleNumber = "S3055") OR (aa.SupplierID = 412 AND aa.DataSupplierArticleNumber = "A 20 240") OR (aa.SupplierID = 4842 AND aa.DataSupplierArticleNumber = "AEU1294") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "SVA199") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BST2219") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18165") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 986 020 240") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CST15199GS") OR (aa.SupplierID = 393 AND aa.DataSupplierArticleNumber = "3038") OR (aa.SupplierID = 28 AND aa.DataSupplierArticleNumber = "300.565.103.210") OR (aa.SupplierID = 28 AND aa.DataSupplierArticleNumber = "300.565.103.500") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "311208102") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "25-3222") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "220445") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "RE83548N") OR (aa.SupplierID = 337 AND aa.DataSupplierArticleNumber = "11020240") OR (aa.SupplierID = 90 AND aa.DataSupplierArticleNumber = "105141") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "ST32228") OR (aa.SupplierID = 87 AND aa.DataSupplierArticleNumber = "8020240") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "6 0082 9") OR (aa.SupplierID = 4819 AND aa.DataSupplierArticleNumber = "114163") OR (aa.SupplierID = 425 AND aa.DataSupplierArticleNumber = "CS1294") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8EA 738 157-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8EA 012 526-521") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "42020240") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1190305000") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1190305009") OR (aa.SupplierID = 4496 AND aa.DataSupplierArticleNumber = "22.1294") OR (aa.SupplierID = 20 AND aa.DataSupplierArticleNumber = "LRS01676") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "944280202400") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "13878") OR (aa.SupplierID = 342 AND aa.DataSupplierArticleNumber = "220445") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "4720240") OR (aa.SupplierID = 4543 AND aa.DataSupplierArticleNumber = "8213184") OR (aa.SupplierID = 4543 AND aa.DataSupplierArticleNumber = "88213184") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QRS1247") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "RAS41351") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DRT0240") OR (aa.SupplierID = 4620 AND aa.DataSupplierArticleNumber = "F042S0H094") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "458213") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "438171") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-12-20240") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99110596601") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99110025701") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "17967N") ) 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 = "101294") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "ST1768") OR (aa.SupplierID = 4843 AND aa.DataSupplierArticleNumber = "S3055") OR (aa.SupplierID = 412 AND aa.DataSupplierArticleNumber = "A 20 240") OR (aa.SupplierID = 4842 AND aa.DataSupplierArticleNumber = "AEU1294") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "SVA199") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BST2219") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18165") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 986 020 240") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CST15199GS") OR (aa.SupplierID = 393 AND aa.DataSupplierArticleNumber = "3038") OR (aa.SupplierID = 28 AND aa.DataSupplierArticleNumber = "300.565.103.210") OR (aa.SupplierID = 28 AND aa.DataSupplierArticleNumber = "300.565.103.500") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "311208102") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "25-3222") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "220445") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "RE83548N") OR (aa.SupplierID = 337 AND aa.DataSupplierArticleNumber = "11020240") OR (aa.SupplierID = 90 AND aa.DataSupplierArticleNumber = "105141") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "ST32228") OR (aa.SupplierID = 87 AND aa.DataSupplierArticleNumber = "8020240") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "6 0082 9") OR (aa.SupplierID = 4819 AND aa.DataSupplierArticleNumber = "114163") OR (aa.SupplierID = 425 AND aa.DataSupplierArticleNumber = "CS1294") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8EA 738 157-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8EA 012 526-521") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "42020240") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1190305000") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1190305009") OR (aa.SupplierID = 4496 AND aa.DataSupplierArticleNumber = "22.1294") OR (aa.SupplierID = 20 AND aa.DataSupplierArticleNumber = "LRS01676") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "944280202400") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "13878") OR (aa.SupplierID = 342 AND aa.DataSupplierArticleNumber = "220445") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "4720240") OR (aa.SupplierID = 4543 AND aa.DataSupplierArticleNumber = "8213184") OR (aa.SupplierID = 4543 AND aa.DataSupplierArticleNumber = "88213184") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QRS1247") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "RAS41351") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DRT0240") OR (aa.SupplierID = 4620 AND aa.DataSupplierArticleNumber = "F042S0H094") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "458213") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "438171") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-12-20240") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99110596601") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99110025701") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "17967N") ) AND aa.Language = "ru" Продажа автозапчастей типа Стартер для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AD KÜHNER 101294 Стартер
AMK ST1768 Стартер
AS-PL S3055 Стартер
ATL Autotechnik A 20 240 Стартер
AUTOELECTRO AEU1294 Стартер
AUTOTEAM SVA199 Стартер
BORG & BECK BST2219 Стартер
Borsehung B18165 Стартер
BOSCH 0 986 020 240 Стартер
CASCO CST15199GS Стартер
CEVAM 3038 Стартер
CV PSH 300.565.103.210 Стартер
300.565.103.500 Стартер
DRI 311208102 Стартер
ELSTOCK 25-3222 Стартер
ERA 220445 Стартер
ERA Benelux RE83548N Стартер
EUROTEC 11020240 Стартер
FARCOM 105141 Стартер
FENOX ST32228 Стартер
FRIESEN 8020240 Стартер
GEBE 6 0082 9 Стартер
HC-Cargo 114163 Стартер
HC-PARTS CS1294 Стартер
HELLA 8EA 738 157-001 Стартер
8EA 012 526-521 Стартер
HERTH+BUSS ELPARTS 42020240 Стартер
JP GROUP 1190305000 Стартер
1190305009 Стартер
LAUBER 22.1294 Стартер
LUCAS ELECTRICAL LRS01676 Стартер
MAGNETI MARELLI 944280202400 Стартер
MAPCO 13878 Стартер
MESSMER 220445 Стартер
NK 4720240 Стартер
PowerMax 8213184 Стартер
88213184 Стартер
QUINTON HAZELL QRS1247 Стартер
REMY RAS41351 Стартер
DRT0240 Стартер
UNIPOINT F042S0H094 Стартер
VALEO 458213 Стартер
438171 Стартер
VEMO V10-12-20240 Стартер
vika 99110596601 Стартер
99110025701 Стартер
WAI 17967N Стартер
2026 CATCAR.INFO (v 2.0)