#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTExMTg0fHxtZGZfaWQ9PTBeNTg3NDN8fHNwYXJlX2lkPT0xMDAyNTk%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 = "58743" AND ( (av.SupplierID = 180 AND av.DataSupplierArticleNumber = "MD-721" AND av.ProductID IN (7)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADU172106" AND av.ProductID IN (7)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "48542" AND av.ProductID IN (7)) OR (av.SupplierID = 59 AND av.DataSupplierArticleNumber = "CH11792ECO" AND av.ProductID IN (7)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "E155H D122" AND av.ProductID IN (7)) OR (av.SupplierID = 4689 AND av.DataSupplierArticleNumber = "B1M031PR" AND av.ProductID IN (7)) OR (av.SupplierID = 4378 AND av.DataSupplierArticleNumber = "OE0111" AND av.ProductID IN (7)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "HU 6008 z" AND av.ProductID IN (7)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVFL819" AND av.ProductID IN (7)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PF4218" AND av.ProductID IN (7)) OR (av.SupplierID = 38 AND av.DataSupplierArticleNumber = "L1078" AND av.ProductID IN (7)) OR (av.SupplierID = 4630 AND av.DataSupplierArticleNumber = "EO-53860" AND av.ProductID IN (7)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SH 4082 P" AND av.ProductID IN (7)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "20-50747-SX" AND av.ProductID IN (7)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 94 8542" AND av.ProductID IN (7)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V30-1829" 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 = "MD-721") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADU172106") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48542") OR (aa.SupplierID = 59 AND aa.DataSupplierArticleNumber = "CH11792ECO") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E155H D122") OR (aa.SupplierID = 4689 AND aa.DataSupplierArticleNumber = "B1M031PR") OR (aa.SupplierID = 4378 AND aa.DataSupplierArticleNumber = "OE0111") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "HU 6008 z") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVFL819") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PF4218") OR (aa.SupplierID = 38 AND aa.DataSupplierArticleNumber = "L1078") OR (aa.SupplierID = 4630 AND aa.DataSupplierArticleNumber = "EO-53860") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SH 4082 P") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-50747-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 8542") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-1829") ) 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 = "MD-721") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADU172106") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "48542") OR (aa.SupplierID = 59 AND aa.DataSupplierArticleNumber = "CH11792ECO") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E155H D122") OR (aa.SupplierID = 4689 AND aa.DataSupplierArticleNumber = "B1M031PR") OR (aa.SupplierID = 4378 AND aa.DataSupplierArticleNumber = "OE0111") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "HU 6008 z") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVFL819") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PF4218") OR (aa.SupplierID = 38 AND aa.DataSupplierArticleNumber = "L1078") OR (aa.SupplierID = 4630 AND aa.DataSupplierArticleNumber = "EO-53860") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SH 4082 P") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-50747-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 8542") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-1829") ) AND aa.Language = "ru" Продажа автозапчастей типа Масляный фильтр для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ALCO FILTER MD-721 Масляный фильтр
BLUE PRINT ADU172106 Масляный фильтр
FEBI BILSTEIN 48542 Масляный фильтр
FRAM CH11792ECO Масляный фильтр
HENGST FILTER E155H D122 Масляный фильтр
JC PREMIUM B1M031PR Масляный фильтр
JS ASAKASHI OE0111 Масляный фильтр
MANN-FILTER HU 6008 z Масляный фильтр
MOTAQUIP LVFL819 Масляный фильтр
PATRON PF4218 Масляный фильтр
PURFLUX L1078 Масляный фильтр
SAKURA Automotive EO-53860 Масляный фильтр
SCT Germany SH 4082 P Масляный фильтр
STELLOX 20-50747-SX Масляный фильтр
SWAG 10 94 8542 Масляный фильтр
VAICO V30-1829 Масляный фильтр
2026 CATCAR.INFO (v 2.0)