#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTQ2NjV8fG1kZl9pZD09MV42NDE1fHxzcGFyZV9pZD09MjAwMTU4&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 = "6415" AND ( (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 986 626 752" AND av.ProductID IN (8)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "1 457 433 611" AND av.ProductID IN (2470)) OR (av.SupplierID = 4702 AND av.DataSupplierArticleNumber = "BS01-007" AND av.ProductID IN (8)) OR (av.SupplierID = 4702 AND av.DataSupplierArticleNumber = "BS01-275" AND av.ProductID IN (8)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "MA 531" AND av.ProductID IN (8)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "MA 745" AND av.ProductID IN (8)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "06769" AND av.ProductID IN (8)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "HP 734" AND av.ProductID IN (8)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "HP 783" AND av.ProductID IN (8)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "AM405W" AND av.ProductID IN (2470)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "AM405" AND av.ProductID IN (8)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "E116L" AND av.ProductID IN (8)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "E116LS" AND av.ProductID IN (2470)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "LXS 42/1" AND av.ProductID IN (2470)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "LX 227" AND av.ProductID IN (8)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "50013036" AND av.ProductID IN (8)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "153071760578" AND av.ProductID IN (8)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "153071760587" AND av.ProductID IN (8)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "LX 227" AND av.ProductID IN (8)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "LXS 42/1" AND av.ProductID IN (2470)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "C 23 440/3" AND av.ProductID IN (8)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "CF 1200" AND av.ProductID IN (2470)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FA1519" AND av.ProductID IN (8)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "FA3435" AND av.ProductID IN (2470)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "12-34 321 0008" AND av.ProductID IN (8)) OR (av.SupplierID = 462 AND av.DataSupplierArticleNumber = "A 151/1" AND av.ProductID IN (8)) OR (av.SupplierID = 4470 AND av.DataSupplierArticleNumber = "R805" AND av.ProductID IN (8)) OR (av.SupplierID = 4470 AND av.DataSupplierArticleNumber = "R129" AND av.ProductID IN (2470,8)) OR (av.SupplierID = 4470 AND av.DataSupplierArticleNumber = "R568" AND av.ProductID IN (8)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SW 3889" AND av.ProductID IN (2470)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SB 033" AND av.ProductID IN (8)) OR (av.SupplierID = 142 AND av.DataSupplierArticleNumber = "S 2650 A" AND av.ProductID IN (8)) OR (av.SupplierID = 142 AND av.DataSupplierArticleNumber = "S 7129 A" AND av.ProductID IN (8)) OR (av.SupplierID = 92 AND av.DataSupplierArticleNumber = "FLI6491" AND av.ProductID IN (8)) OR (av.SupplierID = 92 AND av.DataSupplierArticleNumber = "FLI6789" AND av.ProductID IN (8)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-21004-SX" AND av.ProductID IN (8)) OR (av.SupplierID = 137 AND av.DataSupplierArticleNumber = "27.129.00" AND av.ProductID IN (8)) OR (av.SupplierID = 137 AND av.DataSupplierArticleNumber = "27.805.00" AND av.ProductID IN (8)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1216224" AND av.ProductID IN (8)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1217000" AND av.ProductID IN (2470)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1018184" AND av.ProductID IN (8)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "46669E" AND av.ProductID IN (2470)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "46541E" AND av.ProductID IN (8)) ) 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 = 30 AND aa.DataSupplierArticleNumber = "0 986 626 752") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 457 433 611") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-007") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-275") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 531") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 745") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "06769") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 734") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 783") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM405W") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM405") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E116L") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E116LS") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LXS 42/1") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 227") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50013036") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760578") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760587") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 227") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LXS 42/1") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 23 440/3") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "CF 1200") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA1519") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3435") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-34 321 0008") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "A 151/1") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "R805") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "R129") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "R568") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SW 3889") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SB 033") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 2650 A") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 7129 A") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FLI6491") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FLI6789") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-21004-SX") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "27.129.00") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "27.805.00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216224") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1217000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1018184") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "46669E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "46541E") ) 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 = 30 AND aa.DataSupplierArticleNumber = "0 986 626 752") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 457 433 611") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-007") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS01-275") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 531") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA 745") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "06769") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 734") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HP 783") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM405W") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM405") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E116L") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E116LS") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LXS 42/1") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 227") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50013036") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760578") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760587") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 227") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LXS 42/1") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 23 440/3") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "CF 1200") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA1519") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "FA3435") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-34 321 0008") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "A 151/1") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "R805") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "R129") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "R568") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SW 3889") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SB 033") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 2650 A") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 7129 A") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FLI6491") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FLI6789") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-21004-SX") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "27.129.00") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "27.805.00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216224") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1217000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1018184") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "46669E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "46541E") ) AND aa.Language = "ru" Продажа автозапчастей типа Воздушный фильтр для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BOSCH 0 986 626 752 Воздушный фильтр
1 457 433 611 Фильтр добавочного воздуха
BOSS FILTERS BS01-007 Воздушный фильтр
BS01-275 Воздушный фильтр
CLEAN FILTERS MA 531 Воздушный фильтр
MA 745 Воздушный фильтр
FEBI BILSTEIN 06769 Воздушный фильтр
FIL FILTER HP 734 Воздушный фильтр
HP 783 Воздушный фильтр
FILTRON AM405W Фильтр добавочного воздуха
AM405 Воздушный фильтр
HENGST FILTER E116L Воздушный фильтр
E116LS Фильтр добавочного воздуха
KNECHT LXS 42/1 Фильтр добавочного воздуха
LX 227 Воздушный фильтр
KOLBENSCHMIDT 50013036 Воздушный фильтр
MAGNETI MARELLI 153071760578 Воздушный фильтр
153071760587 Воздушный фильтр
MAHLE ORIGINAL LX 227 Воздушный фильтр
LXS 42/1 Фильтр добавочного воздуха
MANN-FILTER C 23 440/3 Воздушный фильтр
CF 1200 Фильтр добавочного воздуха
MECAFILTER FA1519 Воздушный фильтр
FA3435 Фильтр добавочного воздуха
MEYLE 12-34 321 0008 Воздушный фильтр
MFILTER A 151/1 Воздушный фильтр
MISFAT R805 Воздушный фильтр
R129 Воздушный фильтр
R568 Воздушный фильтр
SCT Germany SW 3889 Фильтр добавочного воздуха
SB 033 Воздушный фильтр
SOFIMA S 2650 A Воздушный фильтр
S 7129 A Воздушный фильтр
SogefiPro FLI6491 Воздушный фильтр
FLI6789 Воздушный фильтр
STELLOX 81-21004-SX Воздушный фильтр
UFI 27.129.00 Воздушный фильтр
27.805.00 Воздушный фильтр
WILMINK GROUP WG1216224 Воздушный фильтр
WG1217000 Фильтр добавочного воздуха
WG1018184 Воздушный фильтр
WIX FILTERS 46669E Фильтр добавочного воздуха
46541E Воздушный фильтр
2026 CATCAR.INFO (v 2.0)