#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUyNHx8bW9kZWxfaWQ9PTcxfHxtZGZfaWQ9PTBeMjYzNHx8c3BhcmVfaWQ9PTEwMDI2MQ%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 = "2634" AND ( (av.SupplierID = 4814 AND av.DataSupplierArticleNumber = "P10007" AND av.ProductID IN (9)) OR (av.SupplierID = 180 AND av.DataSupplierArticleNumber = "FF-009" AND av.ProductID IN (9)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "E01" AND av.ProductID IN (9)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BFF8014" AND av.ProductID IN (9)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "CFF100104" AND av.ProductID IN (9)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "L104/606" AND av.ProductID IN (9)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "EFF012" AND av.ProductID IN (9)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "A130007" AND av.ProductID IN (9)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "A130008" AND av.ProductID IN (9)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "A130003" AND av.ProductID IN (9)) OR (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP1110.13.0001" AND av.ProductID IN (9)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DFFL13" AND av.ProductID IN (9)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "ZP 8014 FP" AND av.ProductID IN (9)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "PS822" AND av.ProductID IN (9)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "H101WK" AND av.ProductID IN (9)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "4020/1" AND av.ProductID IN (9)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "4510" AND av.ProductID IN (9)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "F300901" AND av.ProductID IN (9)) OR (av.SupplierID = 387 AND av.DataSupplierArticleNumber = "FE002z" AND av.ProductID IN (9)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "KL 13 OF" 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 = "LFPF001" AND av.ProductID IN (9)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "213908006800" AND av.ProductID IN (9)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "KL 13 OF" AND av.ProductID IN (9)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "WK 31/2" AND av.ProductID IN (9)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MFF-3000" AND av.ProductID IN (9)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "4020/1" AND av.ProductID IN (9)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "4510" AND av.ProductID IN (9)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "ELE1990" AND av.ProductID IN (9)) OR (av.SupplierID = 462 AND av.DataSupplierArticleNumber = "BF 01" AND av.ProductID IN (9)) OR (av.SupplierID = 4470 AND av.DataSupplierArticleNumber = "E001" AND av.ProductID IN (9)) OR (av.SupplierID = 490 AND av.DataSupplierArticleNumber = "FB007" AND av.ProductID IN (9)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "FF-01482" AND av.ProductID IN (9)) OR (av.SupplierID = 5 AND av.DataSupplierArticleNumber = "4.00030.80.0" AND av.ProductID IN (9)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QFF0111" AND av.ProductID IN (9)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "ST 337" AND av.ProductID IN (9)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "21-00589-SX" AND av.ProductID IN (9)) OR (av.SupplierID = 4011 AND av.DataSupplierArticleNumber = "BN500" AND av.ProductID IN (9)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "587000" AND av.ProductID IN (9)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1025410" AND av.ProductID IN (9)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1214882" AND av.ProductID IN (9)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "WF8127" 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 = "P10007") OR (aa.SupplierID = 180 AND aa.DataSupplierArticleNumber = "FF-009") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "E01") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BFF8014") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "CFF100104") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "L104/606") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "EFF012") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A130007") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A130008") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A130003") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP1110.13.0001") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DFFL13") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "ZP 8014 FP") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "PS822") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H101WK") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "4020/1") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "4510") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "F300901") OR (aa.SupplierID = 387 AND aa.DataSupplierArticleNumber = "FE002z") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "KL 13 OF") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50013074") OR (aa.SupplierID = 4973 AND aa.DataSupplierArticleNumber = "LFPF001") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "213908006800") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "KL 13 OF") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "WK 31/2") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MFF-3000") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "4020/1") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "4510") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELE1990") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "BF 01") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "E001") OR (aa.SupplierID = 490 AND aa.DataSupplierArticleNumber = "FB007") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "FF-01482") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "4.00030.80.0") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QFF0111") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "ST 337") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "21-00589-SX") OR (aa.SupplierID = 4011 AND aa.DataSupplierArticleNumber = "BN500") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "587000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025410") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1214882") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WF8127") ) 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 = "P10007") OR (aa.SupplierID = 180 AND aa.DataSupplierArticleNumber = "FF-009") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "E01") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BFF8014") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "CFF100104") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "L104/606") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "EFF012") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A130007") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A130008") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A130003") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP1110.13.0001") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DFFL13") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "ZP 8014 FP") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "PS822") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H101WK") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "4020/1") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "4510") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "F300901") OR (aa.SupplierID = 387 AND aa.DataSupplierArticleNumber = "FE002z") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "KL 13 OF") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50013074") OR (aa.SupplierID = 4973 AND aa.DataSupplierArticleNumber = "LFPF001") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "213908006800") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "KL 13 OF") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "WK 31/2") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MFF-3000") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "4020/1") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "4510") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELE1990") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "BF 01") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "E001") OR (aa.SupplierID = 490 AND aa.DataSupplierArticleNumber = "FB007") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "FF-01482") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "4.00030.80.0") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QFF0111") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "ST 337") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "21-00589-SX") OR (aa.SupplierID = 4011 AND aa.DataSupplierArticleNumber = "BN500") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "587000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025410") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1214882") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WF8127") ) AND aa.Language = "ru" Продажа автозапчастей типа Топливный фильтр для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
1A FIRST AUTOMOTIVE P10007 Топливный фильтр
ALCO FILTER FF-009 Топливный фильтр
AUTOMOTOR France E01 Топливный фильтр
BORG & BECK BFF8014 Топливный фильтр
CHAMPION CFF100104 Топливный фильтр
L104/606 Топливный фильтр
COMLINE EFF012 Топливный фильтр
DENCKERMANN A130007 Топливный фильтр
A130008 Топливный фильтр
A130003 Топливный фильтр
Dr!ve+ DP1110.13.0001 Топливный фильтр
DYNAMATRIX DFFL13 Топливный фильтр
FIL FILTER ZP 8014 FP Топливный фильтр
FILTRON PS822 Топливный фильтр
HENGST FILTER H101WK Топливный фильтр
HOFFER 4020/1 Топливный фильтр
4510 Топливный фильтр
KAMOKA F300901 Топливный фильтр
KLAXCAR FRANCE FE002z Топливный фильтр
KNECHT KL 13 OF Топливный фильтр
KOLBENSCHMIDT 50013074 Топливный фильтр
LUCAS FILTERS LFPF001 Топливный фильтр
MAGNETI MARELLI 213908006800 Топливный фильтр
MAHLE ORIGINAL KL 13 OF Топливный фильтр
MANN-FILTER WK 31/2 Топливный фильтр
MDR MFF-3000 Топливный фильтр
MEAT & DORIA 4020/1 Топливный фильтр
4510 Топливный фильтр
MECAFILTER ELE1990 Топливный фильтр
MFILTER BF 01 Топливный фильтр
MISFAT E001 Топливный фильтр
MULLER FILTER FB007 Топливный фильтр
OPTIMAL FF-01482 Топливный фильтр
PIERBURG 4.00030.80.0 Топливный фильтр
QUINTON HAZELL QFF0111 Топливный фильтр
SCT Germany ST 337 Топливный фильтр
STELLOX 21-00589-SX Топливный фильтр
TECNECO FILTERS BN500 Топливный фильтр
VALEO 587000 Топливный фильтр
WILMINK GROUP WG1025410 Топливный фильтр
WG1214882 Топливный фильтр
WIX FILTERS WF8127 Топливный фильтр
2026 CATCAR.INFO (v 2.0)