#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTE1ODd8fG1kZl9pZD09MV44NjV8fHNwYXJlX2lkPT0yMDA3Nzc%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 = "865" AND ( (av.SupplierID = 422 AND av.DataSupplierArticleNumber = "93969" AND av.ProductID IN (467)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "139000N" AND av.ProductID IN (467)) OR (av.SupplierID = 247 AND av.DataSupplierArticleNumber = "ME6231" AND av.ProductID IN (467)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8FH 351 312-541" AND av.ProductID IN (467)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "0606.3015" AND av.ProductID IN (467)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8FH 351 312-541" AND av.ProductID IN (467)) OR (av.SupplierID = 123 AND av.DataSupplierArticleNumber = "72034" AND av.ProductID IN (467)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "54256" AND av.ProductID IN (467)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "10-35234-SX" AND av.ProductID IN (467)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "D6ME004TT" AND av.ProductID IN (467)) ) 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 = 422 AND aa.DataSupplierArticleNumber = "93969") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "139000N") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "ME6231") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8FH 351 312-541") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0606.3015") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8FH 351 312-541") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "72034") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "54256") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "10-35234-SX") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D6ME004TT") ) 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 = 422 AND aa.DataSupplierArticleNumber = "93969") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "139000N") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "ME6231") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8FH 351 312-541") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0606.3015") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8FH 351 312-541") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "72034") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "54256") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "10-35234-SX") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D6ME004TT") ) AND aa.Language = "ru" Продажа автозапчастей типа Салонный теплообменник для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AHE 93969 Теплообменник, отопление салона
AKS DASIS 139000N Теплообменник, отопление салона
AVA QUALITY COOLING ME6231 Теплообменник, отопление салона
BEHR HELLA SERVICE 8FH 351 312-541 Теплообменник, отопление салона
FRIGAIR 0606.3015 Теплообменник, отопление салона
HELLA 8FH 351 312-541 Теплообменник, отопление салона
NISSENS 72034 Теплообменник, отопление салона
NRF 54256 Теплообменник, отопление салона
STELLOX 10-35234-SX Теплообменник, отопление салона
THERMOTEC D6ME004TT Теплообменник, отопление салона
2026 CATCAR.INFO (v 2.0)