#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTYyNnx8bW9kZWxfaWQ9PTUxMzB8fG1kZl9pZD09MV4xMjMyOXx8c3BhcmVfaWQ9PTIwMDE2MQ%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 = "12329" AND ( (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "I104" AND av.ProductID IN (417)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "ML 026" 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 = 95 AND av.DataSupplierArticleNumber = "153071760597" 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 = 92 AND av.DataSupplierArticleNumber = "FA5834" 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 = 4337 AND aa.DataSupplierArticleNumber = "I104") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "ML 026") 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 = 95 AND aa.DataSupplierArticleNumber = "153071760597") 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 = 92 AND aa.DataSupplierArticleNumber = "FA5834") 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 = 4337 AND aa.DataSupplierArticleNumber = "I104") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "ML 026") 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 = 95 AND aa.DataSupplierArticleNumber = "153071760597") 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 = 92 AND aa.DataSupplierArticleNumber = "FA5834") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1214714") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WL7026") ) AND aa.Language = "ru" Продажа автозапчастей типа Гидравлический фильтр рулевого управления для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTOMOTOR France I104 Гидрофильтр, рулевое управление
CLEAN FILTERS ML 026 Гидрофильтр, рулевое управление
FILTRON OM512 Гидрофильтр, рулевое управление
HENGST FILTER E10H02 Гидрофильтр, рулевое управление
KNECHT HX 15 Гидрофильтр, рулевое управление
MAGNETI MARELLI 153071760597 Гидрофильтр, рулевое управление
MAHLE ORIGINAL HX 15 Гидрофильтр, рулевое управление
MANN-FILTER H 601/4 Гидрофильтр, рулевое управление
MECAFILTER ELH4199 Гидрофильтр, рулевое управление
MFILTER TE 4001H Гидрофильтр, рулевое управление
MISFAT L406A Гидрофильтр, рулевое управление
SCT Germany SH 418 Гидрофильтр, рулевое управление
SogefiPro FA5834 Гидрофильтр, рулевое управление
WILMINK GROUP WG1214714 Гидрофильтр, рулевое управление
WIX FILTERS WL7026 Гидрофильтр, рулевое управление
2026 CATCAR.INFO (v 2.0)