#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY3OXx8bW9kZWxfaWQ9PTUyMTJ8fG1kZl9pZD09MV4xMjA5N3x8c3BhcmVfaWQ9PTIwMDE2MQ%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 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 = "12097" AND ( (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "1 457 429 820" AND av.ProductID IN (417)) OR (av.SupplierID = 4702 AND av.DataSupplierArticleNumber = "BS03-054" AND av.ProductID IN (417)) OR (av.SupplierID = 4868 AND av.DataSupplierArticleNumber = "P550309" AND av.ProductID IN (417)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "15761" AND av.ProductID IN (417)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "OM512" AND av.ProductID IN (417)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "E10H02" AND av.ProductID IN (417)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "HX 15" AND av.ProductID IN (417)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "HX 15" AND av.ProductID IN (417)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "H 601/4" AND av.ProductID IN (417)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "ELH4199" AND av.ProductID IN (417)) OR (av.SupplierID = 462 AND av.DataSupplierArticleNumber = "TE 4001H" AND av.ProductID IN (417)) OR (av.SupplierID = 4470 AND av.DataSupplierArticleNumber = "L406A" AND av.ProductID IN (417)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SH 418" AND av.ProductID IN (417)) OR (av.SupplierID = 142 AND av.DataSupplierArticleNumber = "S 3081 PO" AND av.ProductID IN (417)) OR (av.SupplierID = 137 AND av.DataSupplierArticleNumber = "25.406.01" AND av.ProductID IN (417)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1214714" AND av.ProductID IN (417)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "WL7026" AND av.ProductID IN (417)) ) 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 = 30 AND aa.DataSupplierArticleNumber = "1 457 429 820") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS03-054") OR (aa.SupplierID = 4868 AND aa.DataSupplierArticleNumber = "P550309") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15761") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OM512") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E10H02") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "HX 15") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "HX 15") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "H 601/4") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELH4199") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "TE 4001H") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "L406A") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SH 418") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 3081 PO") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "25.406.01") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1214714") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WL7026") ) 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 = 30 AND aa.DataSupplierArticleNumber = "1 457 429 820") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS03-054") OR (aa.SupplierID = 4868 AND aa.DataSupplierArticleNumber = "P550309") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15761") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OM512") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E10H02") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "HX 15") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "HX 15") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "H 601/4") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELH4199") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "TE 4001H") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "L406A") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SH 418") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 3081 PO") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "25.406.01") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1214714") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WL7026") ) AND aa.Language = "ru" Продажа автозапчастей типа Гидравлический фильтр рулевого управления для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BOSCH 1 457 429 820 Гидрофильтр, рулевое управление
BOSS FILTERS BS03-054 Гидрофильтр, рулевое управление
DONALDSON P550309 Гидрофильтр, рулевое управление
FEBI BILSTEIN 15761 Гидрофильтр, рулевое управление
FILTRON OM512 Гидрофильтр, рулевое управление
HENGST FILTER E10H02 Гидрофильтр, рулевое управление
KNECHT HX 15 Гидрофильтр, рулевое управление
MAHLE ORIGINAL HX 15 Гидрофильтр, рулевое управление
MANN-FILTER H 601/4 Гидрофильтр, рулевое управление
MECAFILTER ELH4199 Гидрофильтр, рулевое управление
MFILTER TE 4001H Гидрофильтр, рулевое управление
MISFAT L406A Гидрофильтр, рулевое управление
SCT Germany SH 418 Гидрофильтр, рулевое управление
SOFIMA S 3081 PO Гидрофильтр, рулевое управление
UFI 25.406.01 Гидрофильтр, рулевое управление
WILMINK GROUP WG1214714 Гидрофильтр, рулевое управление
WIX FILTERS WL7026 Гидрофильтр, рулевое управление
2026 CATCAR.INFO (v 2.0)