#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTM1NDF8fG1kZl9pZD09MV41NjQzfHxzcGFyZV9pZD09MjAwMDg2&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 = "5643" AND ( (av.SupplierID = 52 AND av.DataSupplierArticleNumber = "TX 23 79D" AND av.ProductID IN (316)) OR (av.SupplierID = 52 AND av.DataSupplierArticleNumber = "TX 23 83D" AND av.ProductID IN (316)) OR (av.SupplierID = 52 AND av.DataSupplierArticleNumber = "TH 8 83" AND av.ProductID IN (316)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "088.872" AND av.ProductID IN (139)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "350136" AND av.ProductID IN (316)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "350184" AND av.ProductID IN (316)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "350204" AND av.ProductID IN (316)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "5300280" AND av.ProductID IN (316)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26627" AND av.ProductID IN (316)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "22310" 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 = "22314" 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 = "24643" 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 = "10528" AND av.ProductID IN (316)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "TH 8 83" AND av.ProductID IN (316)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "TX 23 79D" AND av.ProductID IN (316)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "TX 23 83D" AND av.ProductID IN (316)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "028 283 0000" AND av.ProductID IN (316)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "030.461-00A" AND av.ProductID IN (316)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "030.462-00A" AND av.ProductID IN (316)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "203.148" AND av.ProductID IN (139)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "82-24023-SX" AND av.ProductID IN (316)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "D2MA001TT" AND av.ProductID IN (316)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "D2MA002TT" AND av.ProductID IN (316)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "D2MA004TT" AND av.ProductID IN (316)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V40-99-0001" AND av.ProductID IN (316)) OR (av.SupplierID = 79 AND av.DataSupplierArticleNumber = "4150.79D50" AND av.ProductID IN (316)) OR (av.SupplierID = 79 AND av.DataSupplierArticleNumber = "4150.83D50" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1104806" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1190453" AND av.ProductID IN (139)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1104807" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1091666" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1262758" AND av.ProductID IN (316)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1091667" 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 23 79D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 23 83D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TH 8 83") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "088.872") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350136") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350184") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350204") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "5300280") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26627") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "22310") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15846") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "22314") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15849") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "24643") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15850") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "10528") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TH 8 83") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 23 79D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 23 83D") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "028 283 0000") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "030.461-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "030.462-00A") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "203.148") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "82-24023-SX") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D2MA001TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D2MA002TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D2MA004TT") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-99-0001") OR (aa.SupplierID = 79 AND aa.DataSupplierArticleNumber = "4150.79D50") OR (aa.SupplierID = 79 AND aa.DataSupplierArticleNumber = "4150.83D50") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104806") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190453") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104807") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1091666") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1262758") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1091667") ) 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 23 79D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TX 23 83D") OR (aa.SupplierID = 52 AND aa.DataSupplierArticleNumber = "TH 8 83") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "088.872") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350136") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350184") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "350204") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "5300280") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26627") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "22310") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15846") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "22314") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15849") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "24643") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "15850") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "10528") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TH 8 83") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 23 79D") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "TX 23 83D") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "028 283 0000") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "030.461-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "030.462-00A") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "203.148") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "82-24023-SX") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D2MA001TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D2MA002TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D2MA004TT") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-99-0001") OR (aa.SupplierID = 79 AND aa.DataSupplierArticleNumber = "4150.79D50") OR (aa.SupplierID = 79 AND aa.DataSupplierArticleNumber = "4150.83D50") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104806") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190453") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104807") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1091666") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1262758") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1091667") ) AND aa.Language = "ru" Продажа автозапчастей типа Термостат / прокладка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BEHR TX 23 79D Термостат, охлаждающая жидкость
TX 23 83D Термостат, охлаждающая жидкость
TH 8 83 Термостат, охлаждающая жидкость
ELRING 088.872 Прокладка, термостат
ERA 350136 Термостат, охлаждающая жидкость
350184 Термостат, охлаждающая жидкость
350204 Термостат, охлаждающая жидкость
FAE 5300280 Термостат, охлаждающая жидкость
FEBI BILSTEIN 26627 Термостат, охлаждающая жидкость
22310 Термостат, охлаждающая жидкость
15846 Термостат, охлаждающая жидкость
22314 Термостат, охлаждающая жидкость
15849 Термостат, охлаждающая жидкость
24643 Термостат, охлаждающая жидкость
15850 Термостат, охлаждающая жидкость
10528 Термостат, охлаждающая жидкость
MAHLE ORIGINAL TH 8 83 Термостат, охлаждающая жидкость
TX 23 79D Термостат, охлаждающая жидкость
TX 23 83D Термостат, охлаждающая жидкость
MEYLE 028 283 0000 Термостат, охлаждающая жидкость
PE Automotive 030.461-00A Термостат, охлаждающая жидкость
030.462-00A Термостат, охлаждающая жидкость
SAMPA 203.148 Прокладка, термостат
STELLOX 82-24023-SX Термостат, охлаждающая жидкость
THERMOTEC D2MA001TT Термостат, охлаждающая жидкость
D2MA002TT Термостат, охлаждающая жидкость
D2MA004TT Термостат, охлаждающая жидкость
VEMO V40-99-0001 Термостат, охлаждающая жидкость
WAHLER 4150.79D50 Термостат, охлаждающая жидкость
4150.83D50 Термостат, охлаждающая жидкость
WILMINK GROUP WG1104806 Термостат, охлаждающая жидкость
WG1190453 Прокладка, термостат
WG1104807 Термостат, охлаждающая жидкость
WG1091666 Термостат, охлаждающая жидкость
WG1262758 Термостат, охлаждающая жидкость
WG1091667 Термостат, охлаждающая жидкость
2026 CATCAR.INFO (v 2.0)