#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTU2NDZ8fG1kZl9pZD09MV4xMzQzM3x8c3BhcmVfaWQ9PTIwMDMzOA%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 = "13433" AND ( (av.SupplierID = 283 AND av.DataSupplierArticleNumber = "44118" AND av.ProductID IN (82)) OR (av.SupplierID = 283 AND av.DataSupplierArticleNumber = "44122" AND av.ProductID IN (82)) OR (av.SupplierID = 264 AND av.DataSupplierArticleNumber = "BCR145A" AND av.ProductID IN (82)) OR (av.SupplierID = 264 AND av.DataSupplierArticleNumber = "BCR323A" AND av.ProductID IN (82)) OR (av.SupplierID = 65 AND av.DataSupplierArticleNumber = "09.A741.10" AND av.ProductID IN (82)) OR (av.SupplierID = 65 AND av.DataSupplierArticleNumber = "09.B325.30" AND av.ProductID IN (82)) OR (av.SupplierID = 4872 AND av.DataSupplierArticleNumber = "DB0323V" AND av.ProductID IN (82)) OR (av.SupplierID = 278 AND av.DataSupplierArticleNumber = "CVD670" AND av.ProductID IN (82)) OR (av.SupplierID = 278 AND av.DataSupplierArticleNumber = "CVD552" AND av.ProductID IN (82)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "29167" AND av.ProductID IN (82)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "22677" AND av.ProductID IN (82)) OR (av.SupplierID = 62 AND av.DataSupplierArticleNumber = "FCR323A" AND av.ProductID IN (82)) OR (av.SupplierID = 62 AND av.DataSupplierArticleNumber = "FCR145A" AND av.ProductID IN (82)) OR (av.SupplierID = 48 AND av.DataSupplierArticleNumber = "567751J" AND av.ProductID IN (82)) OR (av.SupplierID = 48 AND av.DataSupplierArticleNumber = "569160J" AND av.ProductID IN (82)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "015 521 2043" AND av.ProductID IN (82)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "016.295-00A" AND av.ProductID IN (82)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "016.672-00A" AND av.ProductID IN (82)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "016.677-00A" AND av.ProductID IN (82)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "100.431" AND av.ProductID IN (82)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "100.462" AND av.ProductID IN (82)) OR (av.SupplierID = 4699 AND av.DataSupplierArticleNumber = "02-ME006" AND av.ProductID IN (82)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.110.1926.360" AND av.ProductID IN (82)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.110.1926.000" AND av.ProductID IN (82,82)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "03.110.1926.190" AND av.ProductID IN (82,82)) OR (av.SupplierID = 39 AND av.DataSupplierArticleNumber = "93087900" AND av.ProductID IN (82)) OR (av.SupplierID = 39 AND av.DataSupplierArticleNumber = "93186700" AND av.ProductID IN (82)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "DF5025S" AND av.ProductID IN (82)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "DF5010S" AND av.ProductID IN (82)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V31-80001" AND av.ProductID IN (82)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V31-80004" AND av.ProductID IN (82)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "187051" AND av.ProductID IN (82)) OR (av.SupplierID = 456 AND av.DataSupplierArticleNumber = "628.2616" AND av.ProductID IN (82)) OR (av.SupplierID = 456 AND av.DataSupplierArticleNumber = "628.2708" AND av.ProductID IN (82)) OR (av.SupplierID = 22 AND av.DataSupplierArticleNumber = "12 999 804" AND av.ProductID IN (82)) ) 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 = 283 AND aa.DataSupplierArticleNumber = "44118") OR (aa.SupplierID = 283 AND aa.DataSupplierArticleNumber = "44122") OR (aa.SupplierID = 264 AND aa.DataSupplierArticleNumber = "BCR145A") OR (aa.SupplierID = 264 AND aa.DataSupplierArticleNumber = "BCR323A") OR (aa.SupplierID = 65 AND aa.DataSupplierArticleNumber = "09.A741.10") OR (aa.SupplierID = 65 AND aa.DataSupplierArticleNumber = "09.B325.30") OR (aa.SupplierID = 4872 AND aa.DataSupplierArticleNumber = "DB0323V") OR (aa.SupplierID = 278 AND aa.DataSupplierArticleNumber = "CVD670") OR (aa.SupplierID = 278 AND aa.DataSupplierArticleNumber = "CVD552") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29167") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "22677") OR (aa.SupplierID = 62 AND aa.DataSupplierArticleNumber = "FCR323A") OR (aa.SupplierID = 62 AND aa.DataSupplierArticleNumber = "FCR145A") OR (aa.SupplierID = 48 AND aa.DataSupplierArticleNumber = "567751J") OR (aa.SupplierID = 48 AND aa.DataSupplierArticleNumber = "569160J") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "015 521 2043") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "016.295-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "016.672-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "016.677-00A") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "100.431") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "100.462") OR (aa.SupplierID = 4699 AND aa.DataSupplierArticleNumber = "02-ME006") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.110.1926.360") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.110.1926.000") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.110.1926.190") OR (aa.SupplierID = 39 AND aa.DataSupplierArticleNumber = "93087900") OR (aa.SupplierID = 39 AND aa.DataSupplierArticleNumber = "93186700") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "DF5025S") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "DF5010S") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V31-80001") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V31-80004") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "187051") OR (aa.SupplierID = 456 AND aa.DataSupplierArticleNumber = "628.2616") OR (aa.SupplierID = 456 AND aa.DataSupplierArticleNumber = "628.2708") OR (aa.SupplierID = 22 AND aa.DataSupplierArticleNumber = "12 999 804") ) 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 = 283 AND aa.DataSupplierArticleNumber = "44118") OR (aa.SupplierID = 283 AND aa.DataSupplierArticleNumber = "44122") OR (aa.SupplierID = 264 AND aa.DataSupplierArticleNumber = "BCR145A") OR (aa.SupplierID = 264 AND aa.DataSupplierArticleNumber = "BCR323A") OR (aa.SupplierID = 65 AND aa.DataSupplierArticleNumber = "09.A741.10") OR (aa.SupplierID = 65 AND aa.DataSupplierArticleNumber = "09.B325.30") OR (aa.SupplierID = 4872 AND aa.DataSupplierArticleNumber = "DB0323V") OR (aa.SupplierID = 278 AND aa.DataSupplierArticleNumber = "CVD670") OR (aa.SupplierID = 278 AND aa.DataSupplierArticleNumber = "CVD552") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29167") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "22677") OR (aa.SupplierID = 62 AND aa.DataSupplierArticleNumber = "FCR323A") OR (aa.SupplierID = 62 AND aa.DataSupplierArticleNumber = "FCR145A") OR (aa.SupplierID = 48 AND aa.DataSupplierArticleNumber = "567751J") OR (aa.SupplierID = 48 AND aa.DataSupplierArticleNumber = "569160J") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "015 521 2043") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "016.295-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "016.672-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "016.677-00A") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "100.431") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "100.462") OR (aa.SupplierID = 4699 AND aa.DataSupplierArticleNumber = "02-ME006") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.110.1926.360") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.110.1926.000") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "03.110.1926.190") OR (aa.SupplierID = 39 AND aa.DataSupplierArticleNumber = "93087900") OR (aa.SupplierID = 39 AND aa.DataSupplierArticleNumber = "93186700") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "DF5025S") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "DF5010S") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V31-80001") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V31-80004") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "187051") OR (aa.SupplierID = 456 AND aa.DataSupplierArticleNumber = "628.2616") OR (aa.SupplierID = 456 AND aa.DataSupplierArticleNumber = "628.2708") OR (aa.SupplierID = 22 AND aa.DataSupplierArticleNumber = "12 999 804") ) AND aa.Language = "ru" Продажа автозапчастей типа Тормозные диски для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AP 44118 Тормозной диск
44122 Тормозной диск
BERAL BCR145A Тормозной диск
BCR323A Тормозной диск
BREMBO 09.A741.10 Тормозной диск
09.B325.30 Тормозной диск
BREMSI DB0323V Тормозной диск
DON CVD670 Тормозной диск
CVD552 Тормозной диск
FEBI BILSTEIN 29167 Тормозной диск
22677 Тормозной диск
FERODO FCR323A Тормозной диск
FCR145A Тормозной диск
JURID 567751J Тормозной диск
569160J Тормозной диск
MEYLE 015 521 2043 Тормозной диск
PE Automotive 016.295-00A Тормозной диск
016.672-00A Тормозной диск
016.677-00A Тормозной диск
SAMPA 100.431 Тормозной диск
100.462 Тормозной диск
SBP 02-ME006 Тормозной диск
ST-TEMPLIN 03.110.1926.360 Тормозной диск
03.110.1926.000 Тормозной диск
03.110.1926.190 Тормозной диск
TEXTAR 93087900 Тормозной диск
93186700 Тормозной диск
TRW DF5025S Тормозной диск
DF5010S Тормозной диск
VAICO V31-80001 Тормозной диск
V31-80004 Тормозной диск
VALEO 187051 Тормозной диск
VILLAR 628.2616 Тормозной диск
628.2708 Тормозной диск
WABCO 12 999 804 Тормозной диск
2026 CATCAR.INFO (v 2.0)