#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTczOXx8bW9kZWxfaWQ9PTU1MzN8fG1kZl9pZD09MV41NjMyfHxzcGFyZV9pZD09MjAwMTM2&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 = "5632" AND ( (av.SupplierID = 180 AND av.DataSupplierArticleNumber = "SP-1017" AND av.ProductID IN (7)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "H101" AND av.ProductID IN (7)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 451 104 010" AND av.ProductID IN (7)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "A210120" AND av.ProductID IN (7)) OR (av.SupplierID = 4868 AND av.DataSupplierArticleNumber = "P553191" AND av.ProductID IN (7)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "OP584" AND av.ProductID IN (7)) OR (av.SupplierID = 4581 AND av.DataSupplierArticleNumber = "LF4006" AND av.ProductID IN (7)) OR (av.SupplierID = 4663 AND av.DataSupplierArticleNumber = "OG 1032" AND av.ProductID IN (7)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "H200W01" AND av.ProductID IN (7)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "H200W10" AND av.ProductID IN (7)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "15372" AND av.ProductID IN (7)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "OC 121" AND av.ProductID IN (7)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "153071760556" AND av.ProductID IN (7)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "OC 121" AND av.ProductID IN (7)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "W 11 102/35" AND av.ProductID IN (7)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "26-0693" AND av.ProductID IN (7)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "15372" AND av.ProductID IN (7)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "ELH4750" AND av.ProductID IN (7)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "814 013 0000" AND av.ProductID IN (7)) OR (av.SupplierID = 462 AND av.DataSupplierArticleNumber = "TF 661" AND av.ProductID IN (7)) OR (av.SupplierID = 4470 AND av.DataSupplierArticleNumber = "Z144" AND av.ProductID IN (7)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SM 146" AND av.ProductID IN (7)) OR (av.SupplierID = 142 AND av.DataSupplierArticleNumber = "S 0900 R" AND av.ProductID IN (7)) OR (av.SupplierID = 92 AND av.DataSupplierArticleNumber = "FA8401A" AND av.ProductID IN (7)) OR (av.SupplierID = 92 AND av.DataSupplierArticleNumber = "FT4878" AND av.ProductID IN (7)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-00002-SX" AND av.ProductID IN (7)) OR (av.SupplierID = 137 AND av.DataSupplierArticleNumber = "23.144.00" AND av.ProductID IN (7)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1150248" AND av.ProductID IN (7)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "51791" AND av.ProductID IN (7)) ) 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 = "SP-1017") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "H101") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 451 104 010") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A210120") OR (aa.SupplierID = 4868 AND aa.DataSupplierArticleNumber = "P553191") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OP584") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "LF4006") OR (aa.SupplierID = 4663 AND aa.DataSupplierArticleNumber = "OG 1032") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H200W01") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H200W10") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "15372") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "OC 121") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760556") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "OC 121") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "W 11 102/35") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "26-0693") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "15372") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELH4750") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "814 013 0000") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "TF 661") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "Z144") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SM 146") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 0900 R") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FA8401A") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FT4878") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-00002-SX") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "23.144.00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1150248") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "51791") ) 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 = "SP-1017") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "H101") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 451 104 010") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A210120") OR (aa.SupplierID = 4868 AND aa.DataSupplierArticleNumber = "P553191") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OP584") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "LF4006") OR (aa.SupplierID = 4663 AND aa.DataSupplierArticleNumber = "OG 1032") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H200W01") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H200W10") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "15372") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "OC 121") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760556") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "OC 121") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "W 11 102/35") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "26-0693") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "15372") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELH4750") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "814 013 0000") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "TF 661") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "Z144") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SM 146") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 0900 R") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FA8401A") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FT4878") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-00002-SX") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "23.144.00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1150248") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "51791") ) AND aa.Language = "ru" Продажа автозапчастей типа Масляный фильтр для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ALCO FILTER SP-1017 Масляный фильтр
AUTOMOTOR France H101 Масляный фильтр
BOSCH 0 451 104 010 Масляный фильтр
DENCKERMANN A210120 Масляный фильтр
DONALDSON P553191 Масляный фильтр
FILTRON OP584 Масляный фильтр
FLEETGUARD LF4006 Масляный фильтр
GOODWILL OG 1032 Масляный фильтр
HENGST FILTER H200W01 Масляный фильтр
H200W10 Масляный фильтр
HOFFER 15372 Масляный фильтр
KNECHT OC 121 Масляный фильтр
MAGNETI MARELLI 153071760556 Масляный фильтр
MAHLE ORIGINAL OC 121 Масляный фильтр
MANN-FILTER W 11 102/35 Масляный фильтр
MAXGEAR 26-0693 Масляный фильтр
MEAT & DORIA 15372 Масляный фильтр
MECAFILTER ELH4750 Масляный фильтр
MEYLE 814 013 0000 Масляный фильтр
MFILTER TF 661 Масляный фильтр
MISFAT Z144 Масляный фильтр
SCT Germany SM 146 Масляный фильтр
SOFIMA S 0900 R Масляный фильтр
SogefiPro FA8401A Масляный фильтр
FT4878 Масляный фильтр
STELLOX 81-00002-SX Масляный фильтр
UFI 23.144.00 Масляный фильтр
WILMINK GROUP WG1150248 Масляный фильтр
WIX FILTERS 51791 Масляный фильтр
2026 CATCAR.INFO (v 2.0)