#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTc1ODB8fG1kZl9pZD09MF4yMTE0MHx8c3BhcmVfaWQ9PTEwMDc3Ng%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 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 = "21140" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "40235" AND av.ProductID IN (1778)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QFL0282" AND av.ProductID IN (416)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 94 0235" AND av.ProductID IN (1778)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "409 119" AND av.ProductID IN (3843)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "408 516" AND av.ProductID IN (416)) ) 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 = 101 AND aa.DataSupplierArticleNumber = "40235") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QFL0282") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 0235") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "409 119") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "408 516") ) 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 = 101 AND aa.DataSupplierArticleNumber = "40235") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QFL0282") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 0235") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "409 119") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "408 516") ) AND aa.Language = "ru" Продажа автозапчастей типа Управление/гидравлика для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 40235 Шланг, теплообменник для охлаждения трансмиссионного масла
QUINTON HAZELL QFL0282 Гидрофильтр, автоматическая коробка передач
SWAG 10 94 0235 Шланг, теплообменник для охлаждения трансмиссионного масла
TOPRAN 409 119 Комплект гидрофильтров, автоматическая коробка передач
408 516 Гидрофильтр, автоматическая коробка передач
2026 CATCAR.INFO (v 2.0)