#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTczOXx8bW9kZWxfaWQ9PTQ2Mzh8fG1kZl9pZD09MV42MDUyfHxzcGFyZV9pZD09MjAwMTU4&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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "6052" AND ( (av.SupplierID = 180 AND av.DataSupplierArticleNumber = "MD-5112" AND av.ProductID IN (8)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "T133" AND av.ProductID IN (2470)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "T130" AND av.ProductID IN (8)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "T131" AND av.ProductID IN (8)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "1 457 433 726" AND av.ProductID IN (8)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "1 457 433 731" AND av.ProductID IN (8)) OR (av.SupplierID = 4702 AND av.DataSupplierArticleNumber = "BS01-101" AND av.ProductID IN (8)) OR (av.SupplierID = 4702 AND av.DataSupplierArticleNumber = "BS01-018" AND av.ProductID IN (8)) OR (av.SupplierID = 4702 AND av.DataSupplierArticleNumber = "BS01-038" AND av.ProductID IN (8)) OR (av.SupplierID = 4702 AND av.DataSupplierArticleNumber = "BS01-100" AND av.ProductID IN (8)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "MA 730" AND av.ProductID IN (8)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "MA 521" AND av.ProductID IN (8)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "MA1471" AND av.ProductID IN (8)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "MA 555" AND av.ProductID IN (8)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "MA 587" AND av.ProductID IN (8)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "MA 389" AND av.ProductID IN (8)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "HP 471" AND av.ProductID IN (8)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "HP 473" AND av.ProductID IN (8)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "HP 433" AND av.ProductID IN (8)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "HP 664" AND av.ProductID IN (8)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "HP 463" AND av.ProductID IN (8)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "HP 729 B" AND av.ProductID IN (8)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "AM404/1W" AND av.ProductID IN (2470)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "AM404/1" AND av.ProductID IN (8)) OR (av.SupplierID = 4581 AND av.DataSupplierArticleNumber = "AF1882" AND av.ProductID IN (8)) OR (av.SupplierID = 4581 AND av.DataSupplierArticleNumber = "AF4662" AND av.ProductID IN (8)) OR (av.SupplierID = 4581 AND av.DataSupplierArticleNumber = "AF4841" AND av.ProductID IN (8)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "E129L" AND av.ProductID IN (8)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "E564LS" AND av.ProductID IN (2470)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "LX 29" AND av.ProductID IN (8)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "LXS 25" AND av.ProductID IN (2470)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "LX 31" AND av.ProductID IN (8)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "LX 654" AND av.ProductID IN (8)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "LX 796" AND av.ProductID IN (8)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "153071760572" AND av.ProductID IN (8)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "LX 31" AND av.ProductID IN (8)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "LX 654" AND av.ProductID IN (8)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "LXS 25" AND av.ProductID IN (2470)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "LX 796" AND av.ProductID IN (8)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "LX 29" AND av.ProductID IN (8)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "C 30 1184" AND av.ProductID IN (8)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "C 17 124" AND av.ProductID IN (2470)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "C 29 1055" AND av.ProductID IN (8)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FA3650" AND av.ProductID IN (2470)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FA1439" AND av.ProductID IN (8)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FJ3642" AND av.ProductID IN (8)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FA3644" AND av.ProductID IN (8)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FA1443" AND av.ProductID IN (8)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FA3695" AND av.ProductID IN (8)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FA1566" AND av.ProductID IN (8)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FA1440" AND av.ProductID IN (2470)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FA3696" AND av.ProductID IN (8)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FA3642" AND av.ProductID IN (8)) OR (av.SupplierID = 462 AND av.DataSupplierArticleNumber = "A 200" AND av.ProductID IN (8)) OR (av.SupplierID = 462 AND av.DataSupplierArticleNumber = "A 200/1" AND av.ProductID IN (8)) OR (av.SupplierID = 4470 AND av.DataSupplierArticleNumber = "R894" AND av.ProductID IN (2470)) OR (av.SupplierID = 4470 AND av.DataSupplierArticleNumber = "R918" AND av.ProductID IN (8)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.085" AND av.ProductID IN (8)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.077" AND av.ProductID IN (8)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.082" AND av.ProductID IN (8)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "078.084" AND av.ProductID IN (8)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SB 964" AND av.ProductID IN (8)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SB 670" AND av.ProductID IN (8)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SB 922" AND av.ProductID IN (8)) OR (av.SupplierID = 92 AND av.DataSupplierArticleNumber = "FLI6516" AND av.ProductID IN (8)) OR (av.SupplierID = 92 AND av.DataSupplierArticleNumber = "FLI6496" AND av.ProductID IN (8)) OR (av.SupplierID = 92 AND av.DataSupplierArticleNumber = "FLI6514" AND av.ProductID IN (8)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1216684" AND av.ProductID IN (8)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1216800" AND av.ProductID IN (8)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1216346" AND av.ProductID IN (8)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1216398" AND av.ProductID IN (8)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1216981" AND av.ProductID IN (2470)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "93075E" AND av.ProductID IN (8)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "93085E" AND av.ProductID IN (8)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "93087E" AND av.ProductID IN (2470)) ) 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 = 180 AND aa.DataSupplierArticleNumber = "MD-5112") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "T133") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "T130") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "T131") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 457 433 726") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 457 433 731") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-101") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-018") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-038") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-100") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 730") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 521") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA1471") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 555") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 587") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 389") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 471") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 473") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 433") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 664") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 463") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 729 B") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM404/1W") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM404/1") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "AF1882") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "AF4662") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "AF4841") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E129L") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E564LS") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 29") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LXS 25") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 31") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 654") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 796") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760572") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 31") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 654") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LXS 25") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 796") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 29") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 30 1184") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 17 124") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 29 1055") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3650") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA1439") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FJ3642") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3644") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA1443") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3695") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA1566") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA1440") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3696") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3642") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "A 200") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "A 200/1") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "R894") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "R918") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.085") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.077") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.082") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.084") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SB 964") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SB 670") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SB 922") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FLI6516") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FLI6496") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FLI6514") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216684") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216800") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216346") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216398") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216981") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93075E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93085E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93087E") ) 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 = 180 AND aa.DataSupplierArticleNumber = "MD-5112") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "T133") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "T130") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "T131") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 457 433 726") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 457 433 731") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-101") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-018") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-038") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-100") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 730") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 521") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA1471") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 555") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 587") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 389") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 471") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 473") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 433") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 664") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 463") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 729 B") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM404/1W") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM404/1") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "AF1882") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "AF4662") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "AF4841") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E129L") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E564LS") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 29") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LXS 25") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 31") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 654") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 796") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760572") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 31") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 654") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LXS 25") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 796") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 29") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 30 1184") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 17 124") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 29 1055") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3650") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA1439") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FJ3642") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3644") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA1443") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3695") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA1566") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA1440") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3696") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3642") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "A 200") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "A 200/1") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "R894") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "R918") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.085") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.077") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.082") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "078.084") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SB 964") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SB 670") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SB 922") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FLI6516") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FLI6496") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FLI6514") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216684") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216800") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216346") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216398") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216981") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93075E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93085E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93087E") ) AND aa.Language = "ru" Продажа автозапчастей типа Воздушный фильтр для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ALCO FILTER MD-5112 Воздушный фильтр
AUTOMOTOR France T133 Фильтр добавочного воздуха
T130 Воздушный фильтр
T131 Воздушный фильтр
BOSCH 1 457 433 726 Воздушный фильтр
1 457 433 731 Воздушный фильтр
BOSS FILTERS BS01-101 Воздушный фильтр
BS01-018 Воздушный фильтр
BS01-038 Воздушный фильтр
BS01-100 Воздушный фильтр
CLEAN FILTERS MA 730 Воздушный фильтр
MA 521 Воздушный фильтр
MA1471 Воздушный фильтр
MA 555 Воздушный фильтр
MA 587 Воздушный фильтр
MA 389 Воздушный фильтр
FIL FILTER HP 471 Воздушный фильтр
HP 473 Воздушный фильтр
HP 433 Воздушный фильтр
HP 664 Воздушный фильтр
HP 463 Воздушный фильтр
HP 729 B Воздушный фильтр
FILTRON AM404/1W Фильтр добавочного воздуха
AM404/1 Воздушный фильтр
FLEETGUARD AF1882 Воздушный фильтр
AF4662 Воздушный фильтр
AF4841 Воздушный фильтр
HENGST FILTER E129L Воздушный фильтр
E564LS Фильтр добавочного воздуха
KNECHT LX 29 Воздушный фильтр
LXS 25 Фильтр добавочного воздуха
LX 31 Воздушный фильтр
LX 654 Воздушный фильтр
LX 796 Воздушный фильтр
MAGNETI MARELLI 153071760572 Воздушный фильтр
MAHLE ORIGINAL LX 31 Воздушный фильтр
LX 654 Воздушный фильтр
LXS 25 Фильтр добавочного воздуха
LX 796 Воздушный фильтр
LX 29 Воздушный фильтр
MANN-FILTER C 30 1184 Воздушный фильтр
C 17 124 Фильтр добавочного воздуха
C 29 1055 Воздушный фильтр
MECAFILTER FA3650 Фильтр добавочного воздуха
FA1439 Воздушный фильтр
FJ3642 Воздушный фильтр
FA3644 Воздушный фильтр
FA1443 Воздушный фильтр
FA3695 Воздушный фильтр
FA1566 Воздушный фильтр
FA1440 Фильтр добавочного воздуха
FA3696 Воздушный фильтр
FA3642 Воздушный фильтр
MFILTER A 200 Воздушный фильтр
A 200/1 Воздушный фильтр
MISFAT R894 Фильтр добавочного воздуха
R918 Воздушный фильтр
SAMPA 078.085 Воздушный фильтр
078.077 Воздушный фильтр
078.082 Воздушный фильтр
078.084 Воздушный фильтр
SCT Germany SB 964 Воздушный фильтр
SB 670 Воздушный фильтр
SB 922 Воздушный фильтр
SogefiPro FLI6516 Воздушный фильтр
FLI6496 Воздушный фильтр
FLI6514 Воздушный фильтр
WILMINK GROUP WG1216684 Воздушный фильтр
WG1216800 Воздушный фильтр
WG1216346 Воздушный фильтр
WG1216398 Воздушный фильтр
WG1216981 Фильтр добавочного воздуха
WIX FILTERS 93075E Воздушный фильтр
93085E Воздушный фильтр
93087E Фильтр добавочного воздуха
2026 CATCAR.INFO (v 2.0)