#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTY0MTd8fG1kZl9pZD09MV4xMTEyOHx8c3BhcmVfaWQ9PTIwMDM2MA%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 = "11128" AND ( (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "034 042 0017" AND av.ProductID IN (2720)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.070.1455.060" AND av.ProductID IN (1095,1095)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.080.1785.000" AND av.ProductID IN (255,255)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.070.0941.108" AND av.ProductID IN (3292,3292)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.070.1904.890" AND av.ProductID IN (3009,3009)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.070.1455.000" AND av.ProductID IN (2718,2718)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.070.1905.920" AND av.ProductID IN (2715,2715)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.070.1456.000" AND av.ProductID IN (1095,1095)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.070.0941.000" AND av.ProductID IN (2718,2718)) ) 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 = 144 AND aa.DataSupplierArticleNumber = "034 042 0017") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.1455.060") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.080.1785.000") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.0941.108") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.1904.890") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.1455.000") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.1905.920") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.1456.000") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.0941.000") ) 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 = 144 AND aa.DataSupplierArticleNumber = "034 042 0017") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.1455.060") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.080.1785.000") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.0941.108") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.1904.890") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.1455.000") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.1905.920") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.1456.000") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.070.0941.000") ) AND aa.Language = "ru" Продажа автозапчастей типа Комплектующие, тормозные барабаны для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
MEYLE 034 042 0017 ремонтный комплект, ролик тормозных колодок
ST-TEMPLIN 03.070.1455.060 Болт тормозной колодки
03.080.1785.000 Пружина, тормозная колодка
03.070.0941.108 Ремкомплект, крепление тормозных колодок
03.070.1904.890 Кронштейн, цилиндр тормозных колодок
03.070.1455.000 Ролик тормозных колодок
03.070.1905.920 подпружинненый стопорный штифт, тормозная колодка
03.070.1456.000 Болт тормозной колодки
03.070.0941.000 Ролик тормозных колодок
2026 CATCAR.INFO (v 2.0)