#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUyNXx8bW9kZWxfaWQ9PTM3M3x8bWRmX2lkPT0wXjcyNnx8c3BhcmVfaWQ9PTEwMDI2MQ%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 = "726" AND ( (av.SupplierID = 4814 AND av.DataSupplierArticleNumber = "P10189" AND av.ProductID IN (9)) OR (av.SupplierID = 180 AND av.DataSupplierArticleNumber = "SP-2004" AND av.ProductID IN (9)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "E14" AND av.ProductID IN (9)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BFF8085" AND av.ProductID IN (9)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 450 905 200" AND av.ProductID IN (9)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 450 905 964" AND av.ProductID IN (9)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "L204/606" AND av.ProductID IN (9)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "CFF100204" AND av.ProductID IN (9)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "MBNA 953" AND av.ProductID IN (9)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "EFF015" AND av.ProductID IN (9)) OR (av.SupplierID = 437 AND av.DataSupplierArticleNumber = "FT5201" AND av.ProductID IN (9)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DFFL30" AND av.ProductID IN (9)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "ZP 8035 FM" AND av.ProductID IN (9)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "PP825" AND av.ProductID IN (9)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "8.580064" AND av.ProductID IN (9)) OR (av.SupplierID = 59 AND av.DataSupplierArticleNumber = "G3744" AND av.ProductID IN (9)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "H84WK01" AND av.ProductID IN (9)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "4022" AND av.ProductID IN (9)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "4022/1" AND av.ProductID IN (9)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "KL 30" AND av.ProductID IN (9)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "50013074" AND av.ProductID IN (9)) OR (av.SupplierID = 4973 AND av.DataSupplierArticleNumber = "LFPF014" AND av.ProductID IN (9)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "213908201100" AND av.ProductID IN (9)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "152071760846" AND av.ProductID IN (9)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "KL 30" AND av.ProductID IN (9)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "WK 853" AND av.ProductID IN (9)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "62604" AND av.ProductID IN (9)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "853-PCS-MS" AND av.ProductID IN (9)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "26-0413" AND av.ProductID IN (9)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "4022/1" AND av.ProductID IN (9)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "4022" AND av.ProductID IN (9)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "ELE3569" AND av.ProductID IN (9)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "514 323 0003" AND av.ProductID IN (9)) OR (av.SupplierID = 4470 AND av.DataSupplierArticleNumber = "E502" AND av.ProductID IN (9)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "VFF143" AND av.ProductID IN (9)) OR (av.SupplierID = 490 AND av.DataSupplierArticleNumber = "FB189" AND av.ProductID IN (9)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PF3112" AND av.ProductID IN (9)) OR (av.SupplierID = 38 AND av.DataSupplierArticleNumber = "EP153" AND av.ProductID IN (9)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "ST 305" AND av.ProductID IN (9)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "8.580064" AND av.ProductID IN (9)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "21-00645-SX" AND av.ProductID IN (9)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V25-0107" AND av.ProductID IN (9)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "587202" AND av.ProductID IN (9)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1214969" AND av.ProductID IN (9)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "WF8027" AND av.ProductID IN (9)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "KF-5042" AND av.ProductID IN (9)) ) 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 = "P10189") OR (aa.SupplierID = 180 AND aa.DataSupplierArticleNumber = "SP-2004") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "E14") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BFF8085") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 450 905 200") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 450 905 964") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "L204/606") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "CFF100204") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MBNA 953") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "EFF015") OR (aa.SupplierID = 437 AND aa.DataSupplierArticleNumber = "FT5201") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DFFL30") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "ZP 8035 FM") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "PP825") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "8.580064") OR (aa.SupplierID = 59 AND aa.DataSupplierArticleNumber = "G3744") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H84WK01") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "4022") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "4022/1") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "KL 30") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50013074") OR (aa.SupplierID = 4973 AND aa.DataSupplierArticleNumber = "LFPF014") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "213908201100") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "152071760846") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "KL 30") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "WK 853") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "62604") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "853-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "26-0413") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "4022/1") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "4022") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELE3569") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "514 323 0003") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "E502") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VFF143") OR (aa.SupplierID = 490 AND aa.DataSupplierArticleNumber = "FB189") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PF3112") OR (aa.SupplierID = 38 AND aa.DataSupplierArticleNumber = "EP153") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "ST 305") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "8.580064") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "21-00645-SX") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V25-0107") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "587202") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1214969") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WF8027") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "KF-5042") ) 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 = "P10189") OR (aa.SupplierID = 180 AND aa.DataSupplierArticleNumber = "SP-2004") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "E14") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BFF8085") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 450 905 200") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 450 905 964") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "L204/606") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "CFF100204") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "MBNA 953") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "EFF015") OR (aa.SupplierID = 437 AND aa.DataSupplierArticleNumber = "FT5201") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DFFL30") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "ZP 8035 FM") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "PP825") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "8.580064") OR (aa.SupplierID = 59 AND aa.DataSupplierArticleNumber = "G3744") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H84WK01") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "4022") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "4022/1") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "KL 30") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50013074") OR (aa.SupplierID = 4973 AND aa.DataSupplierArticleNumber = "LFPF014") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "213908201100") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "152071760846") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "KL 30") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "WK 853") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "62604") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "853-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "26-0413") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "4022/1") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "4022") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELE3569") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "514 323 0003") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "E502") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "VFF143") OR (aa.SupplierID = 490 AND aa.DataSupplierArticleNumber = "FB189") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PF3112") OR (aa.SupplierID = 38 AND aa.DataSupplierArticleNumber = "EP153") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "ST 305") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "8.580064") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "21-00645-SX") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V25-0107") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "587202") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1214969") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WF8027") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "KF-5042") ) AND aa.Language = "ru" Продажа автозапчастей типа Топливный фильтр для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
1A FIRST AUTOMOTIVE P10189 Топливный фильтр
ALCO FILTER SP-2004 Топливный фильтр
AUTOMOTOR France E14 Топливный фильтр
BORG & BECK BFF8085 Топливный фильтр
BOSCH 0 450 905 200 Топливный фильтр
0 450 905 964 Топливный фильтр
CHAMPION L204/606 Топливный фильтр
CFF100204 Топливный фильтр
CLEAN FILTERS MBNA 953 Топливный фильтр
COMLINE EFF015 Топливный фильтр
CoopersFiaam FT5201 Топливный фильтр
DYNAMATRIX DFFL30 Топливный фильтр
FIL FILTER ZP 8035 FM Топливный фильтр
FILTRON PP825 Топливный фильтр
FISPA 8.580064 Топливный фильтр
FRAM G3744 Топливный фильтр
HENGST FILTER H84WK01 Топливный фильтр
HOFFER 4022 Топливный фильтр
4022/1 Топливный фильтр
KNECHT KL 30 Топливный фильтр
KOLBENSCHMIDT 50013074 Топливный фильтр
LUCAS FILTERS LFPF014 Топливный фильтр
MAGNETI MARELLI 213908201100 Топливный фильтр
152071760846 Топливный фильтр
MAHLE ORIGINAL KL 30 Топливный фильтр
MANN-FILTER WK 853 Топливный фильтр
MAPCO 62604 Топливный фильтр
MASTER-SPORT 853-PCS-MS Топливный фильтр
MAXGEAR 26-0413 Топливный фильтр
MEAT & DORIA 4022/1 Топливный фильтр
4022 Топливный фильтр
MECAFILTER ELE3569 Топливный фильтр
MEYLE 514 323 0003 Топливный фильтр
MISFAT E502 Топливный фильтр
MOTAQUIP VFF143 Топливный фильтр
MULLER FILTER FB189 Топливный фильтр
PATRON PF3112 Топливный фильтр
PURFLUX EP153 Топливный фильтр
SCT Germany ST 305 Топливный фильтр
SIDAT 8.580064 Топливный фильтр
STELLOX 21-00645-SX Топливный фильтр
VAICO V25-0107 Топливный фильтр
VALEO 587202 Топливный фильтр
WILMINK GROUP WG1214969 Топливный фильтр
WIX FILTERS WF8027 Топливный фильтр
ZEKKERT KF-5042 Топливный фильтр
2026 CATCAR.INFO (v 2.0)