#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTY0MTd8fG1kZl9pZD09MV4yMDgyN3x8c3BhcmVfaWQ9PTIwMDE1OA%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 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 = "20827" AND ( (av.SupplierID = 180 AND av.DataSupplierArticleNumber = "S244" AND av.ProductID IN (8)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "F 026 400 210" AND av.ProductID IN (2470)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "F 026 400 068" AND av.ProductID IN (8)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "F 026 400 483" AND av.ProductID IN (8)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "30443" AND av.ProductID IN (8)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "38612" AND av.ProductID IN (8)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "AM446/3W" AND av.ProductID IN (2470)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "AM446/3" AND av.ProductID IN (8)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "LX 1024" AND av.ProductID IN (8)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "LX 1024" AND av.ProductID IN (8)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "C 27 1250/1" AND av.ProductID IN (8)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "C 27 023" AND av.ProductID IN (8)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "CF 1640" AND av.ProductID IN (2470)) OR (av.SupplierID = 142 AND av.DataSupplierArticleNumber = "S 7619 A" AND av.ProductID IN (8)) OR (av.SupplierID = 142 AND av.DataSupplierArticleNumber = "S 7616 A" AND av.ProductID IN (2470)) OR (av.SupplierID = 137 AND av.DataSupplierArticleNumber = "27.616.00" AND av.ProductID IN (2470)) OR (av.SupplierID = 137 AND av.DataSupplierArticleNumber = "27.619.00" AND av.ProductID IN (8)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "93313E" AND av.ProductID IN (2470)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "93236E" 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 = 180 AND aa.DataSupplierArticleNumber = "S244") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "F 026 400 210") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "F 026 400 068") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "F 026 400 483") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "30443") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38612") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM446/3W") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM446/3") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 1024") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 1024") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 27 1250/1") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 27 023") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "CF 1640") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 7619 A") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 7616 A") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "27.616.00") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "27.619.00") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93313E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93236E") ) 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 = "S244") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "F 026 400 210") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "F 026 400 068") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "F 026 400 483") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "30443") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38612") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM446/3W") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AM446/3") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 1024") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 1024") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 27 1250/1") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 27 023") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "CF 1640") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 7619 A") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 7616 A") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "27.616.00") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "27.619.00") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93313E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93236E") ) AND aa.Language = "ru" Продажа автозапчастей типа Воздушный фильтр для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ALCO FILTER S244 Воздушный фильтр
BOSCH F 026 400 210 Фильтр добавочного воздуха
F 026 400 068 Воздушный фильтр
F 026 400 483 Воздушный фильтр
FEBI BILSTEIN 30443 Воздушный фильтр
38612 Воздушный фильтр
FILTRON AM446/3W Фильтр добавочного воздуха
AM446/3 Воздушный фильтр
KNECHT LX 1024 Воздушный фильтр
MAHLE ORIGINAL LX 1024 Воздушный фильтр
MANN-FILTER C 27 1250/1 Воздушный фильтр
C 27 023 Воздушный фильтр
CF 1640 Фильтр добавочного воздуха
SOFIMA S 7619 A Воздушный фильтр
S 7616 A Фильтр добавочного воздуха
UFI 27.616.00 Фильтр добавочного воздуха
27.619.00 Воздушный фильтр
WIX FILTERS 93313E Фильтр добавочного воздуха
93236E Воздушный фильтр
2026 CATCAR.INFO (v 2.0)