#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3M3x8bW9kZWxfaWQ9PTQ5NjF8fG1kZl9pZD09MF4xNzE3OXx8c3BhcmVfaWQ9PTEwMjI0NA%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 = "17179" AND ( (av.SupplierID = 65 AND av.DataSupplierArticleNumber = "DP 85 025" AND av.ProductID IN (3405)) OR (av.SupplierID = 65 AND av.DataSupplierArticleNumber = "DP 85 005" AND av.ProductID IN (3405)) OR (av.SupplierID = 158 AND av.DataSupplierArticleNumber = "31338-5604" AND av.ProductID IN (3405)) OR (av.SupplierID = 158 AND av.DataSupplierArticleNumber = "30697-5601" AND av.ProductID IN (3405)) OR (av.SupplierID = 158 AND av.DataSupplierArticleNumber = "31338-5602" AND av.ProductID IN (3405)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "47858" AND av.ProductID IN (3405)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "47900" AND av.ProductID IN (3405)) OR (av.SupplierID = 4955 AND av.DataSupplierArticleNumber = "3R13385602" AND av.ProductID IN (3405)) OR (av.SupplierID = 4955 AND av.DataSupplierArticleNumber = "3R13385604" AND av.ProductID IN (3405)) OR (av.SupplierID = 4955 AND av.DataSupplierArticleNumber = "3R06975601" AND av.ProductID IN (3405)) OR (av.SupplierID = 153 AND av.DataSupplierArticleNumber = "8633.07" AND av.ProductID IN (3405)) OR (av.SupplierID = 153 AND av.DataSupplierArticleNumber = "8263.04" AND av.ProductID IN (3405)) OR (av.SupplierID = 152 AND av.DataSupplierArticleNumber = "8263.04" AND av.ProductID IN (3405)) OR (av.SupplierID = 152 AND av.DataSupplierArticleNumber = "8633.07" AND av.ProductID IN (3405)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-90002" AND av.ProductID IN (3405)) OR (av.SupplierID = 456 AND av.DataSupplierArticleNumber = "637.2080" AND av.ProductID IN (3405)) OR (av.SupplierID = 456 AND av.DataSupplierArticleNumber = "638.2162" AND av.ProductID IN (3405)) OR (av.SupplierID = 366 AND av.DataSupplierArticleNumber = "87333.07" AND av.ProductID IN (3405)) OR (av.SupplierID = 366 AND av.DataSupplierArticleNumber = "83633.04" AND av.ProductID IN (3405)) ) 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 = 65 AND aa.DataSupplierArticleNumber = "DP 85 025") OR (aa.SupplierID = 65 AND aa.DataSupplierArticleNumber = "DP 85 005") OR (aa.SupplierID = 158 AND aa.DataSupplierArticleNumber = "31338-5604") OR (aa.SupplierID = 158 AND aa.DataSupplierArticleNumber = "30697-5601") OR (aa.SupplierID = 158 AND aa.DataSupplierArticleNumber = "31338-5602") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "47858") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "47900") OR (aa.SupplierID = 4955 AND aa.DataSupplierArticleNumber = "3R13385602") OR (aa.SupplierID = 4955 AND aa.DataSupplierArticleNumber = "3R13385604") OR (aa.SupplierID = 4955 AND aa.DataSupplierArticleNumber = "3R06975601") OR (aa.SupplierID = 153 AND aa.DataSupplierArticleNumber = "8633.07") OR (aa.SupplierID = 153 AND aa.DataSupplierArticleNumber = "8263.04") OR (aa.SupplierID = 152 AND aa.DataSupplierArticleNumber = "8263.04") OR (aa.SupplierID = 152 AND aa.DataSupplierArticleNumber = "8633.07") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-90002") OR (aa.SupplierID = 456 AND aa.DataSupplierArticleNumber = "637.2080") OR (aa.SupplierID = 456 AND aa.DataSupplierArticleNumber = "638.2162") OR (aa.SupplierID = 366 AND aa.DataSupplierArticleNumber = "87333.07") OR (aa.SupplierID = 366 AND aa.DataSupplierArticleNumber = "83633.04") ) 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 = 65 AND aa.DataSupplierArticleNumber = "DP 85 025") OR (aa.SupplierID = 65 AND aa.DataSupplierArticleNumber = "DP 85 005") OR (aa.SupplierID = 158 AND aa.DataSupplierArticleNumber = "31338-5604") OR (aa.SupplierID = 158 AND aa.DataSupplierArticleNumber = "30697-5601") OR (aa.SupplierID = 158 AND aa.DataSupplierArticleNumber = "31338-5602") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "47858") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "47900") OR (aa.SupplierID = 4955 AND aa.DataSupplierArticleNumber = "3R13385602") OR (aa.SupplierID = 4955 AND aa.DataSupplierArticleNumber = "3R13385604") OR (aa.SupplierID = 4955 AND aa.DataSupplierArticleNumber = "3R06975601") OR (aa.SupplierID = 153 AND aa.DataSupplierArticleNumber = "8633.07") OR (aa.SupplierID = 153 AND aa.DataSupplierArticleNumber = "8263.04") OR (aa.SupplierID = 152 AND aa.DataSupplierArticleNumber = "8263.04") OR (aa.SupplierID = 152 AND aa.DataSupplierArticleNumber = "8633.07") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-90002") OR (aa.SupplierID = 456 AND aa.DataSupplierArticleNumber = "637.2080") OR (aa.SupplierID = 456 AND aa.DataSupplierArticleNumber = "638.2162") OR (aa.SupplierID = 366 AND aa.DataSupplierArticleNumber = "87333.07") OR (aa.SupplierID = 366 AND aa.DataSupplierArticleNumber = "83633.04") ) AND aa.Language = "ru" Продажа автозапчастей типа Комплект тормозов для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BREMBO DP 85 025 Комплект тормозов, дисковый тормозной механизм
DP 85 005 Комплект тормозов, дисковый тормозной механизм
ICER 31338-5604 Комплект тормозов, дисковый тормозной механизм
30697-5601 Комплект тормозов, дисковый тормозной механизм
31338-5602 Комплект тормозов, дисковый тормозной механизм
MAPCO 47858 Комплект тормозов, дисковый тормозной механизм
47900 Комплект тормозов, дисковый тормозной механизм
R BRAKE 3R13385602 Комплект тормозов, дисковый тормозной механизм
3R13385604 Комплект тормозов, дисковый тормозной механизм
3R06975601 Комплект тормозов, дисковый тормозной механизм
REMSA 8633.07 Комплект тормозов, дисковый тормозной механизм
8263.04 Комплект тормозов, дисковый тормозной механизм
ROADHOUSE 8263.04 Комплект тормозов, дисковый тормозной механизм
8633.07 Комплект тормозов, дисковый тормозной механизм
VAICO V10-90002 Комплект тормозов, дисковый тормозной механизм
VILLAR 637.2080 Комплект тормозов, дисковый тормозной механизм
638.2162 Комплект тормозов, дисковый тормозной механизм
WOKING 87333.07 Комплект тормозов, дисковый тормозной механизм
83633.04 Комплект тормозов, дисковый тормозной механизм
2026 CATCAR.INFO (v 2.0)