#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUzOXx8bW9kZWxfaWQ9PTQ5Mjd8fG1kZl9pZD09MV44MTY0fHxzcGFyZV9pZD09MjAwMTU3&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 = "8164" AND ( (av.SupplierID = 180 AND av.DataSupplierArticleNumber = "SP-1299" AND av.ProductID IN (7)) OR (av.SupplierID = 180 AND av.DataSupplierArticleNumber = "MD-729" AND av.ProductID IN (7)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "H148" AND av.ProductID IN (7)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "F 026 407 048" AND av.ProductID IN (7)) OR (av.SupplierID = 4702 AND av.DataSupplierArticleNumber = "BS03-005" AND av.ProductID IN (7)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "DO5513" 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 = "P954588" AND av.ProductID IN (7)) OR (av.SupplierID = 4868 AND av.DataSupplierArticleNumber = "P550639" AND av.ProductID IN (7)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "35396" AND av.ProductID IN (7)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "ZP 3069 MG" AND av.ProductID IN (7)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "ML 1136" AND av.ProductID IN (7)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "OE693" AND av.ProductID IN (7)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "OP592/6" AND av.ProductID IN (7)) OR (av.SupplierID = 4581 AND av.DataSupplierArticleNumber = "LF3977" AND av.ProductID IN (7)) OR (av.SupplierID = 4663 AND av.DataSupplierArticleNumber = "OG 1039" AND av.ProductID IN (7)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "H311W" AND av.ProductID IN (7)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "E311H01 D273" AND av.ProductID IN (7)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "H230W" AND av.ProductID IN (7)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "OC 474" AND av.ProductID IN (7)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "50013987" AND av.ProductID IN (7)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "50014518" AND av.ProductID IN (7)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "153071760765" AND av.ProductID IN (7)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "OC 474" AND av.ProductID IN (7)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "W 1170/7" AND av.ProductID IN (7)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "W 13 004" AND av.ProductID IN (7)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "1170/7-OF-PCS-MS" AND av.ProductID IN (7)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "ELH4757" AND av.ProductID IN (7)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "234 322 0001" AND av.ProductID IN (7)) OR (av.SupplierID = 462 AND av.DataSupplierArticleNumber = "TF 6503" AND av.ProductID IN (7)) OR (av.SupplierID = 4470 AND av.DataSupplierArticleNumber = "Z288" AND av.ProductID IN (7)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SM 5770" AND av.ProductID IN (7)) OR (av.SupplierID = 142 AND av.DataSupplierArticleNumber = "S 3288 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 = "FT5657" AND av.ProductID IN (7)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-00016-SX" AND av.ProductID IN (7)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-00031-SX" AND av.ProductID IN (7)) OR (av.SupplierID = 137 AND av.DataSupplierArticleNumber = "23.288.00" AND av.ProductID IN (7)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1018845" AND av.ProductID IN (7)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1019249" AND av.ProductID IN (7)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1104021" AND av.ProductID IN (7)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "92078E" AND av.ProductID IN (7)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "WL10085" 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-1299") OR (aa.SupplierID = 180 AND aa.DataSupplierArticleNumber = "MD-729") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "H148") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "F 026 407 048") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS03-005") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "DO5513") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A210120") OR (aa.SupplierID = 4868 AND aa.DataSupplierArticleNumber = "P954588") OR (aa.SupplierID = 4868 AND aa.DataSupplierArticleNumber = "P550639") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35396") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "ZP 3069 MG") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "ML 1136") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OE693") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OP592/6") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "LF3977") OR (aa.SupplierID = 4663 AND aa.DataSupplierArticleNumber = "OG 1039") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H311W") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E311H01 D273") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H230W") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "OC 474") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50013987") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50014518") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760765") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "OC 474") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "W 1170/7") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "W 13 004") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "1170/7-OF-PCS-MS") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELH4757") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "234 322 0001") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "TF 6503") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "Z288") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SM 5770") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 3288 R") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FA8401A") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FT5657") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-00016-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-00031-SX") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "23.288.00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1018845") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1019249") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104021") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "92078E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WL10085") ) 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-1299") OR (aa.SupplierID = 180 AND aa.DataSupplierArticleNumber = "MD-729") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "H148") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "F 026 407 048") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS03-005") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "DO5513") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "A210120") OR (aa.SupplierID = 4868 AND aa.DataSupplierArticleNumber = "P954588") OR (aa.SupplierID = 4868 AND aa.DataSupplierArticleNumber = "P550639") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35396") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "ZP 3069 MG") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "ML 1136") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OE693") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OP592/6") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "LF3977") OR (aa.SupplierID = 4663 AND aa.DataSupplierArticleNumber = "OG 1039") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H311W") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E311H01 D273") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "H230W") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "OC 474") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50013987") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50014518") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "153071760765") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "OC 474") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "W 1170/7") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "W 13 004") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "1170/7-OF-PCS-MS") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELH4757") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "234 322 0001") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "TF 6503") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "Z288") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SM 5770") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 3288 R") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FA8401A") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "FT5657") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-00016-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-00031-SX") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "23.288.00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1018845") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1019249") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104021") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "92078E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WL10085") ) AND aa.Language = "ru" Продажа автозапчастей типа Масляный фильтр для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ALCO FILTER SP-1299 Масляный фильтр
MD-729 Масляный фильтр
AUTOMOTOR France H148 Масляный фильтр
BOSCH F 026 407 048 Масляный фильтр
BOSS FILTERS BS03-005 Масляный фильтр
CLEAN FILTERS DO5513 Масляный фильтр
DENCKERMANN A210120 Масляный фильтр
DONALDSON P954588 Масляный фильтр
P550639 Масляный фильтр
FEBI BILSTEIN 35396 Масляный фильтр
FIL FILTER ZP 3069 MG Масляный фильтр
ML 1136 Масляный фильтр
FILTRON OE693 Масляный фильтр
OP592/6 Масляный фильтр
FLEETGUARD LF3977 Масляный фильтр
GOODWILL OG 1039 Масляный фильтр
HENGST FILTER H311W Масляный фильтр
E311H01 D273 Масляный фильтр
H230W Масляный фильтр
KNECHT OC 474 Масляный фильтр
KOLBENSCHMIDT 50013987 Масляный фильтр
50014518 Масляный фильтр
MAGNETI MARELLI 153071760765 Масляный фильтр
MAHLE ORIGINAL OC 474 Масляный фильтр
MANN-FILTER W 1170/7 Масляный фильтр
W 13 004 Масляный фильтр
MASTER-SPORT 1170/7-OF-PCS-MS Масляный фильтр
MECAFILTER ELH4757 Масляный фильтр
MEYLE 234 322 0001 Масляный фильтр
MFILTER TF 6503 Масляный фильтр
MISFAT Z288 Масляный фильтр
SCT Germany SM 5770 Масляный фильтр
SOFIMA S 3288 R Масляный фильтр
SogefiPro FA8401A Масляный фильтр
FT5657 Масляный фильтр
STELLOX 81-00016-SX Масляный фильтр
81-00031-SX Масляный фильтр
UFI 23.288.00 Масляный фильтр
WILMINK GROUP WG1018845 Масляный фильтр
WG1019249 Масляный фильтр
WG1104021 Масляный фильтр
WIX FILTERS 92078E Масляный фильтр
WL10085 Масляный фильтр
2026 CATCAR.INFO (v 2.0)