#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTM1MzB8fG1kZl9pZD09MV44MjU0fHxzcGFyZV9pZD09MjAwMDg2&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 = "8254" AND ( (av.SupplierID = 52 AND av.DataSupplierArticleNumber = "TX 18 83" AND av.ProductID IN (316)) OR (av.SupplierID = 52 AND av.DataSupplierArticleNumber = "TX 18 65D" AND av.ProductID IN (316)) OR (av.SupplierID = 52 AND av.DataSupplierArticleNumber = "TX 18 83D" AND av.ProductID IN (316)) OR (av.SupplierID = 52 AND av.DataSupplierArticleNumber = "TX 18 71D" AND av.ProductID IN (316)) OR (av.SupplierID = 52 AND av.DataSupplierArticleNumber = "TX 18 55D" AND av.ProductID IN (316)) OR (av.SupplierID = 52 AND av.DataSupplierArticleNumber = "TX 18 75D" AND av.ProductID IN (316)) OR (av.SupplierID = 52 AND av.DataSupplierArticleNumber = "TX 18 60D" AND av.ProductID IN (316)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "495.980" AND av.ProductID IN (139)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "350195" AND av.ProductID IN (316)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "350112" AND av.ProductID IN (316)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "350156" AND av.ProductID IN (316)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "350183" AND av.ProductID IN (316)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "15850" AND av.ProductID IN (316)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "15846" AND av.ProductID IN (316)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "15851" AND av.ProductID IN (316)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "15847" AND av.ProductID IN (316)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "18016" AND av.ProductID IN (316)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "15849" AND av.ProductID IN (316)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "10528" AND av.ProductID IN (316)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "18017" AND av.ProductID IN (316)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "TH01982G1" AND av.ProductID IN (316)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "TX 18 83" AND av.ProductID IN (316)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "TX 18 65D" AND av.ProductID IN (316)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "TX 18 83D" AND av.ProductID IN (316)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "TX 18 71D" AND av.ProductID IN (316)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "TX 18 55D" AND av.ProductID IN (316)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "TX 18 75D" AND av.ProductID IN (316)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "TX 18 60D" AND av.ProductID IN (316)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "028 271 0011" AND av.ProductID IN (316)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "12-28 265 0001" AND av.ProductID IN (316)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "019.061-00A" AND av.ProductID IN (316)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "019.060-00A" AND av.ProductID IN (316)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "82-24000-SX" AND av.ProductID IN (316)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "82-24017-SX" AND av.ProductID IN (316)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V30-99-0394-1" AND av.ProductID IN (316)) OR (av.SupplierID = 79 AND av.DataSupplierArticleNumber = "4105.83D" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1193153" AND av.ProductID IN (139)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1262811" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1104802" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1091655" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1262816" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1262807" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1104800" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1262809" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1104801" AND av.ProductID IN (316)) ) 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 = 52 AND aa.DataSupplierArticleNumber = "TX 18 83") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 65D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 83D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 71D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 55D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 75D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 60D") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "495.980") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350195") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350112") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350156") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350183") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15850") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15846") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15851") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15847") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "18016") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15849") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "10528") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "18017") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "TH01982G1") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 83") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 65D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 83D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 71D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 55D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 75D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 60D") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "028 271 0011") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-28 265 0001") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "019.061-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "019.060-00A") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "82-24000-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "82-24017-SX") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V30-99-0394-1") OR (aa.SupplierID = 79 AND aa.DataSupplierArticleNumber = "4105.83D") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1193153") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1262811") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104802") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1091655") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1262816") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1262807") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104800") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1262809") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104801") ) 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 = 52 AND aa.DataSupplierArticleNumber = "TX 18 83") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 65D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 83D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 71D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 55D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 75D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 18 60D") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "495.980") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350195") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350112") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350156") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350183") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15850") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15846") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15851") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15847") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "18016") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15849") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "10528") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "18017") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "TH01982G1") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 83") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 65D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 83D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 71D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 55D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 75D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 18 60D") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "028 271 0011") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-28 265 0001") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "019.061-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "019.060-00A") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "82-24000-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "82-24017-SX") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V30-99-0394-1") OR (aa.SupplierID = 79 AND aa.DataSupplierArticleNumber = "4105.83D") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1193153") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1262811") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104802") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1091655") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1262816") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1262807") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104800") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1262809") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104801") ) AND aa.Language = "ru" Продажа автозапчастей типа Термостат / прокладка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BEHR TX 18 83 Термостат, охлаждающая жидкость
TX 18 65D Термостат, охлаждающая жидкость
TX 18 83D Термостат, охлаждающая жидкость
TX 18 71D Термостат, охлаждающая жидкость
TX 18 55D Термостат, охлаждающая жидкость
TX 18 75D Термостат, охлаждающая жидкость
TX 18 60D Термостат, охлаждающая жидкость
ELRING 495.980 Прокладка, термостат
ERA 350195 Термостат, охлаждающая жидкость
350112 Термостат, охлаждающая жидкость
350156 Термостат, охлаждающая жидкость
350183 Термостат, охлаждающая жидкость
FEBI BILSTEIN 15850 Термостат, охлаждающая жидкость
15846 Термостат, охлаждающая жидкость
15851 Термостат, охлаждающая жидкость
15847 Термостат, охлаждающая жидкость
18016 Термостат, охлаждающая жидкость
15849 Термостат, охлаждающая жидкость
10528 Термостат, охлаждающая жидкость
18017 Термостат, охлаждающая жидкость
GATES TH01982G1 Термостат, охлаждающая жидкость
MAHLE ORIGINAL TX 18 83 Термостат, охлаждающая жидкость
TX 18 65D Термостат, охлаждающая жидкость
TX 18 83D Термостат, охлаждающая жидкость
TX 18 71D Термостат, охлаждающая жидкость
TX 18 55D Термостат, охлаждающая жидкость
TX 18 75D Термостат, охлаждающая жидкость
TX 18 60D Термостат, охлаждающая жидкость
MEYLE 028 271 0011 Термостат, охлаждающая жидкость
12-28 265 0001 Термостат, охлаждающая жидкость
PE Automotive 019.061-00A Термостат, охлаждающая жидкость
019.060-00A Термостат, охлаждающая жидкость
STELLOX 82-24000-SX Термостат, охлаждающая жидкость
82-24017-SX Термостат, охлаждающая жидкость
VEMO V30-99-0394-1 Термостат, охлаждающая жидкость
WAHLER 4105.83D Термостат, охлаждающая жидкость
WILMINK GROUP WG1193153 Прокладка, термостат
WG1262811 Термостат, охлаждающая жидкость
WG1104802 Термостат, охлаждающая жидкость
WG1091655 Термостат, охлаждающая жидкость
WG1262816 Термостат, охлаждающая жидкость
WG1262807 Термостат, охлаждающая жидкость
WG1104800 Термостат, охлаждающая жидкость
WG1262809 Термостат, охлаждающая жидкость
WG1104801 Термостат, охлаждающая жидкость
2026 CATCAR.INFO (v 2.0)