#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTY0MTd8fG1kZl9pZD09MV4xMTU2Nnx8c3BhcmVfaWQ9PTIwMDUyMQ%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 = "11566" AND ( (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 002 254" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 469" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 448" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 411" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 001 302" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 467" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 437" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 372" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 001 604" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 468" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 446" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 375" AND av.ProductID IN (12)) OR (av.SupplierID = 484 AND av.DataSupplierArticleNumber = "CSP67100GS" AND av.ProductID IN (12)) OR (av.SupplierID = 484 AND av.DataSupplierArticleNumber = "CSP67101GS" AND av.ProductID IN (12)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49481" AND av.ProductID IN (12)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39326" AND av.ProductID IN (12)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "45751" AND av.ProductID IN (12)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "45753" AND av.ProductID IN (12)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-90805" AND av.ProductID IN (12)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-140206" AND av.ProductID IN (12)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "05.050.0916.110" AND av.ProductID IN (12,12)) ) 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 = "K S01 002 254") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 469") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 448") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 411") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 001 302") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 467") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 437") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 372") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 001 604") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 468") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 446") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 375") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSP67100GS") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSP67101GS") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49481") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39326") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45751") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45753") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-90805") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-140206") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "05.050.0916.110") ) 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 = "K S01 002 254") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 469") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 448") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 411") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 001 302") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 467") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 437") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 372") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 001 604") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 468") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 446") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 375") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSP67100GS") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSP67101GS") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49481") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39326") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45751") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45753") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-90805") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-140206") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "05.050.0916.110") ) AND aa.Language = "ru" Продажа автозапчастей типа Насос гидроусилителя для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BOSCH K S01 002 254 Гидравлический насос, рулевое управление
K S01 000 469 Гидравлический насос, рулевое управление
K S01 000 448 Гидравлический насос, рулевое управление
K S01 000 411 Гидравлический насос, рулевое управление
K S01 001 302 Гидравлический насос, рулевое управление
K S01 000 467 Гидравлический насос, рулевое управление
K S01 000 437 Гидравлический насос, рулевое управление
K S01 000 372 Гидравлический насос, рулевое управление
K S01 001 604 Гидравлический насос, рулевое управление
K S01 000 468 Гидравлический насос, рулевое управление
K S01 000 446 Гидравлический насос, рулевое управление
K S01 000 375 Гидравлический насос, рулевое управление
CASCO CSP67100GS Гидравлический насос, рулевое управление
CSP67101GS Гидравлический насос, рулевое управление
FEBI BILSTEIN 49481 Гидравлический насос, рулевое управление
39326 Гидравлический насос, рулевое управление
45751 Гидравлический насос, рулевое управление
45753 Гидравлический насос, рулевое управление
S-TR STR-90805 Гидравлический насос, рулевое управление
STR-140206 Гидравлический насос, рулевое управление
ST-TEMPLIN 05.050.0916.110 Гидравлический насос, рулевое управление
2026 CATCAR.INFO (v 2.0)