#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1MzR8fG1kZl9pZD09MV45ODcwfHxzcGFyZV9pZD09MjAwOTc1&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 = "9870" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "09959" AND av.ProductID IN (1427)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "042.031" AND av.ProductID IN (1427)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "042.033" AND av.ProductID IN (1427)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "042.034" AND av.ProductID IN (1427)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "042.030" AND av.ProductID IN (1427)) ) 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 = "09959") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.031") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.033") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.034") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.030") ) 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 = "09959") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.031") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.033") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.034") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.030") ) AND aa.Language = "ru" Продажа автозапчастей типа Диск шарнира для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 09959 Шарнир, продольный вал
SAMPA 042.031 Шарнир, продольный вал
042.033 Шарнир, продольный вал
042.034 Шарнир, продольный вал
042.030 Шарнир, продольный вал
2026 CATCAR.INFO (v 2.0)