#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTk1MDh8fG1kZl9pZD09MF4zNDA0N3x8c3BhcmVfaWQ9PTEwMjIwOA%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 = "34047" AND ( (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "BFE1000.10" AND av.ProductID IN (3357)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "BFE1000.05" AND av.ProductID IN (3357)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "402403" AND av.ProductID IN (3357)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "402406" AND av.ProductID IN (3357)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "402401" AND av.ProductID IN (3357)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "402402" AND av.ProductID IN (3357)) ) 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 = 378 AND aa.DataSupplierArticleNumber = "BFE1000.10") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "BFE1000.05") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402403") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402406") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402401") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402402") ) 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 = 378 AND aa.DataSupplierArticleNumber = "BFE1000.10") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "BFE1000.05") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402403") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402406") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402401") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "402402") ) AND aa.Language = "ru" Продажа автозапчастей типа Тормозная жидкость для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
OPEN PARTS BFE1000.10 Тормозная жидкость
BFE1000.05 Тормозная жидкость
VALEO 402403 Тормозная жидкость
402406 Тормозная жидкость
402401 Тормозная жидкость
402402 Тормозная жидкость
2026 CATCAR.INFO (v 2.0)