#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwMnx8bW9kZWxfaWQ9PTU0NTJ8fG1kZl9pZD09MF4xODkzMHx8c3BhcmVfaWQ9PTEwMDM4NA%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 = "18930" AND ( (av.SupplierID = 4814 AND av.DataSupplierArticleNumber = "A63132" AND av.ProductID IN (8)) OR (av.SupplierID = 180 AND av.DataSupplierArticleNumber = "MD-5312" AND av.ProductID IN (8)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADL142227" AND av.ProductID IN (8)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BFA2205" AND av.ProductID IN (8)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "F 026 400 039" AND av.ProductID IN (8)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "CAF100450C" AND av.ProductID IN (8)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "V450/606" AND av.ProductID IN (8)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "MA1387" AND av.ProductID IN (8)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "EAF635" AND av.ProductID IN (8)) OR (av.SupplierID = 437 AND av.DataSupplierArticleNumber = "FL9086" AND av.ProductID IN (8)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "A146890" AND av.ProductID IN (8)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DAF2790" AND av.ProductID IN (8)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT37101" AND av.ProductID IN (8)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39752" AND av.ProductID IN (8)) OR (av.SupplierID = 4838 AND av.DataSupplierArticleNumber = "FA-8804" AND av.ProductID IN (8)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "HPU 4431" AND av.ProductID IN (8)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "AE348/3" AND av.ProductID IN (8)) OR (av.SupplierID = 59 AND av.DataSupplierArticleNumber = "CA10046" AND av.ProductID IN (8)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "18531" AND av.ProductID IN (8)) OR (av.SupplierID = 4689 AND av.DataSupplierArticleNumber = "B2F071PR" AND av.ProductID IN (8)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "3318601909" AND av.ProductID IN (8)) OR (av.SupplierID = 4378 AND av.DataSupplierArticleNumber = "A0535" AND av.ProductID IN (8)) OR (av.SupplierID = 305 AND av.DataSupplierArticleNumber = "E-9281" AND av.ProductID IN (8)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "F213901" AND av.ProductID IN (8)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "LX 2790" AND av.ProductID IN (8)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1713065" AND av.ProductID IN (8)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "153071760191" AND av.ProductID IN (8)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "LX 2790" AND av.ProductID IN (8)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "C 18 003" AND av.ProductID IN (8)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "60100" AND av.ProductID IN (8)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "2790K-LF-PCS-MS" AND av.ProductID IN (8)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "26-0486" AND av.ProductID IN (8)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "18531" AND av.ProductID IN (8)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "EL9172" AND av.ProductID IN (8)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "15-12 321 0000" AND av.ProductID IN (8)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "VFA1225" AND av.ProductID IN (8)) OR (av.SupplierID = 490 AND av.DataSupplierArticleNumber = "PA3132" AND av.ProductID IN (8)) OR (av.SupplierID = 4380 AND av.DataSupplierArticleNumber = "2133736" AND av.ProductID IN (8)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "EAF3053.30" AND av.ProductID IN (8)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "FA-00313" AND av.ProductID IN (8)) OR (av.SupplierID = 38 AND av.DataSupplierArticleNumber = "A1211" AND av.ProductID IN (8)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QFA0229" AND av.ProductID IN (8)) OR (av.SupplierID = 4768 AND av.DataSupplierArticleNumber = "S10017" AND av.ProductID IN (8)) OR (av.SupplierID = 142 AND av.DataSupplierArticleNumber = "S 7606 A" AND av.ProductID IN (8)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "71-01504-SX" AND av.ProductID IN (8)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "70 93 9752" AND av.ProductID IN (8)) OR (av.SupplierID = 4011 AND av.DataSupplierArticleNumber = "AR10046-OV" AND av.ProductID IN (8)) OR (av.SupplierID = 91 AND av.DataSupplierArticleNumber = "A2171" AND av.ProductID IN (8)) OR (av.SupplierID = 137 AND av.DataSupplierArticleNumber = "27.606.00" AND av.ProductID IN (8)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V24-0766" AND av.ProductID IN (8)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1216308" AND av.ProductID IN (8)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1431688" AND av.ProductID IN (8)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "WA9566" 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 = 4814 AND aa.DataSupplierArticleNumber = "A63132") OR (aa.SupplierID = 180 AND aa.DataSupplierArticleNumber = "MD-5312") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADL142227") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BFA2205") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "F 026 400 039") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "CAF100450C") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "V450/606") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA1387") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "EAF635") OR (aa.SupplierID = 437 AND aa.DataSupplierArticleNumber = "FL9086") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A146890") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DAF2790") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT37101") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39752") OR (aa.SupplierID = 4838 AND aa.DataSupplierArticleNumber = "FA-8804") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HPU 4431") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AE348/3") OR (aa.SupplierID = 59 AND aa.DataSupplierArticleNumber = "CA10046") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "18531") OR (aa.SupplierID = 4689 AND aa.DataSupplierArticleNumber = "B2F071PR") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "3318601909") OR (aa.SupplierID = 4378 AND aa.DataSupplierArticleNumber = "A0535") OR (aa.SupplierID = 305 AND aa.DataSupplierArticleNumber = "E-9281") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "F213901") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 2790") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1713065") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760191") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 2790") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 18 003") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "60100") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "2790K-LF-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "26-0486") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "18531") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "EL9172") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "15-12 321 0000") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VFA1225") OR (aa.SupplierID = 490 AND aa.DataSupplierArticleNumber = "PA3132") OR (aa.SupplierID = 4380 AND aa.DataSupplierArticleNumber = "2133736") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EAF3053.30") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "FA-00313") OR (aa.SupplierID = 38 AND aa.DataSupplierArticleNumber = "A1211") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QFA0229") OR (aa.SupplierID = 4768 AND aa.DataSupplierArticleNumber = "S10017") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 7606 A") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "71-01504-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "70 93 9752") OR (aa.SupplierID = 4011 AND aa.DataSupplierArticleNumber = "AR10046-OV") OR (aa.SupplierID = 91 AND aa.DataSupplierArticleNumber = "A2171") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "27.606.00") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V24-0766") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216308") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1431688") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WA9566") ) 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 = 4814 AND aa.DataSupplierArticleNumber = "A63132") OR (aa.SupplierID = 180 AND aa.DataSupplierArticleNumber = "MD-5312") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADL142227") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BFA2205") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "F 026 400 039") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "CAF100450C") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "V450/606") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MA1387") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "EAF635") OR (aa.SupplierID = 437 AND aa.DataSupplierArticleNumber = "FL9086") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A146890") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DAF2790") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT37101") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39752") OR (aa.SupplierID = 4838 AND aa.DataSupplierArticleNumber = "FA-8804") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HPU 4431") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "AE348/3") OR (aa.SupplierID = 59 AND aa.DataSupplierArticleNumber = "CA10046") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "18531") OR (aa.SupplierID = 4689 AND aa.DataSupplierArticleNumber = "B2F071PR") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "3318601909") OR (aa.SupplierID = 4378 AND aa.DataSupplierArticleNumber = "A0535") OR (aa.SupplierID = 305 AND aa.DataSupplierArticleNumber = "E-9281") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "F213901") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LX 2790") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1713065") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760191") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LX 2790") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "C 18 003") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "60100") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "2790K-LF-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "26-0486") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "18531") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "EL9172") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "15-12 321 0000") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VFA1225") OR (aa.SupplierID = 490 AND aa.DataSupplierArticleNumber = "PA3132") OR (aa.SupplierID = 4380 AND aa.DataSupplierArticleNumber = "2133736") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "EAF3053.30") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "FA-00313") OR (aa.SupplierID = 38 AND aa.DataSupplierArticleNumber = "A1211") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QFA0229") OR (aa.SupplierID = 4768 AND aa.DataSupplierArticleNumber = "S10017") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 7606 A") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "71-01504-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "70 93 9752") OR (aa.SupplierID = 4011 AND aa.DataSupplierArticleNumber = "AR10046-OV") OR (aa.SupplierID = 91 AND aa.DataSupplierArticleNumber = "A2171") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "27.606.00") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V24-0766") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1216308") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1431688") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WA9566") ) AND aa.Language = "ru" Продажа автозапчастей типа Воздушный фильтр/корпус воздушного фильтра для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
1A FIRST AUTOMOTIVE A63132 Воздушный фильтр
ALCO FILTER MD-5312 Воздушный фильтр
BLUE PRINT ADL142227 Воздушный фильтр
BORG & BECK BFA2205 Воздушный фильтр
BOSCH F 026 400 039 Воздушный фильтр
CHAMPION CAF100450C Воздушный фильтр
V450/606 Воздушный фильтр
CLEAN FILTERS MA1387 Воздушный фильтр
COMLINE EAF635 Воздушный фильтр
CoopersFiaam FL9086 Воздушный фильтр
DENCKERMANN A146890 Воздушный фильтр
DYNAMATRIX DAF2790 Воздушный фильтр
FAST FT37101 Воздушный фильтр
FEBI BILSTEIN 39752 Воздушный фильтр
FI.BA FA-8804 Воздушный фильтр
FIL FILTER HPU 4431 Воздушный фильтр
FILTRON AE348/3 Воздушный фильтр
FRAM CA10046 Воздушный фильтр
HOFFER 18531 Воздушный фильтр
JC PREMIUM B2F071PR Воздушный фильтр
JP GROUP 3318601909 Воздушный фильтр
JS ASAKASHI A0535 Воздушный фильтр
K&N Filters E-9281 Воздушный фильтр
KAMOKA F213901 Воздушный фильтр
KNECHT LX 2790 Воздушный фильтр
KRAFT AUTOMOTIVE 1713065 Воздушный фильтр
MAGNETI MARELLI 153071760191 Воздушный фильтр
MAHLE ORIGINAL LX 2790 Воздушный фильтр
MANN-FILTER C 18 003 Воздушный фильтр
MAPCO 60100 Воздушный фильтр
MASTER-SPORT 2790K-LF-PCS-MS Воздушный фильтр
MAXGEAR 26-0486 Воздушный фильтр
MEAT & DORIA 18531 Воздушный фильтр
MECAFILTER EL9172 Воздушный фильтр
MEYLE 15-12 321 0000 Воздушный фильтр
MOTAQUIP VFA1225 Воздушный фильтр
MULLER FILTER PA3132 Воздушный фильтр
Omnicraft 2133736 Воздушный фильтр
OPEN PARTS EAF3053.30 Воздушный фильтр
OPTIMAL FA-00313 Воздушный фильтр
PURFLUX A1211 Воздушный фильтр
QUINTON HAZELL QFA0229 Воздушный фильтр
SIVENTO S10017 Воздушный фильтр
SOFIMA S 7606 A Воздушный фильтр
STELLOX 71-01504-SX Воздушный фильтр
SWAG 70 93 9752 Воздушный фильтр
TECNECO FILTERS AR10046-OV Воздушный фильтр
TECNOCAR A2171 Воздушный фильтр
UFI 27.606.00 Воздушный фильтр
VAICO V24-0766 Воздушный фильтр
WILMINK GROUP WG1216308 Воздушный фильтр
WG1431688 Воздушный фильтр
WIX FILTERS WA9566 Воздушный фильтр
2026 CATCAR.INFO (v 2.0)