#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4Nnx8bW9kZWxfaWQ9PTE0Mzg1fHxtZGZfaWQ9PTFeMTk2NzR8fHNwYXJlX2lkPT0yMDA1MjI%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 = "19674" 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 = 4702 AND av.DataSupplierArticleNumber = "BS03-057" AND av.ProductID IN (417)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "OM512" AND av.ProductID IN (417)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "OM512/2" AND av.ProductID IN (417)) OR (av.SupplierID = 4581 AND av.DataSupplierArticleNumber = "HF35489" AND av.ProductID IN (417)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "E10H02" AND av.ProductID IN (417)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "E70H" AND av.ProductID IN (417)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "H 601/4" AND av.ProductID IN (417)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "H 623" AND av.ProductID IN (417)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "034 046 0000" AND av.ProductID IN (417)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SH 418" AND av.ProductID IN (417)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "57131E" AND av.ProductID IN (417)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "92125E" 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 = 4702 AND aa.DataSupplierArticleNumber = "BS03-057") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OM512") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OM512/2") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "HF35489") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E10H02") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E70H") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "H 601/4") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "H 623") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "034 046 0000") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SH 418") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "57131E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "92125E") 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 = 4702 AND aa.DataSupplierArticleNumber = "BS03-057") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OM512") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "OM512/2") OR (aa.SupplierID = 4581 AND aa.DataSupplierArticleNumber = "HF35489") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E10H02") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E70H") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "H 601/4") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "H 623") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "034 046 0000") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SH 418") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "57131E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "92125E") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "WL7026") ) AND aa.Language = "ru" Продажа автозапчастей типа Фильтр гидроусилителя для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BOSCH 1 457 429 820 Гидрофильтр, рулевое управление
BOSS FILTERS BS03-054 Гидрофильтр, рулевое управление
BS03-057 Гидрофильтр, рулевое управление
FILTRON OM512 Гидрофильтр, рулевое управление
OM512/2 Гидрофильтр, рулевое управление
FLEETGUARD HF35489 Гидрофильтр, рулевое управление
HENGST FILTER E10H02 Гидрофильтр, рулевое управление
E70H Гидрофильтр, рулевое управление
MANN-FILTER H 601/4 Гидрофильтр, рулевое управление
H 623 Гидрофильтр, рулевое управление
MEYLE 034 046 0000 Гидрофильтр, рулевое управление
SCT Germany SH 418 Гидрофильтр, рулевое управление
WIX FILTERS 57131E Гидрофильтр, рулевое управление
92125E Гидрофильтр, рулевое управление
WL7026 Гидрофильтр, рулевое управление
2026 CATCAR.INFO (v 2.0)