#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTE1ODd8fG1kZl9pZD09MV43ODR8fHNwYXJlX2lkPT0yMDA5MjI%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 = "784" AND ( (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "137100N" AND av.ProductID IN (468)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "137100T" AND av.ProductID IN (468)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8ML 376 723-721" AND av.ProductID IN (468)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8ML 376 724-061" AND av.ProductID IN (468)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8MY 376 744-411" AND av.ProductID IN (3852)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "0706.3007" AND av.ProductID IN (468)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8ML 376 724-061" AND av.ProductID IN (468)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8MY 376 744-411" AND av.ProductID IN (3852)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8ML 376 723-721" AND av.ProductID IN (468)) OR (av.SupplierID = 296 AND av.DataSupplierArticleNumber = "817M07A" AND av.ProductID IN (468)) OR (av.SupplierID = 123 AND av.DataSupplierArticleNumber = "96972" AND av.ProductID IN (468)) OR (av.SupplierID = 123 AND av.DataSupplierArticleNumber = "96971" AND av.ProductID IN (468)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "30409" AND av.ProductID IN (468)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "30905" AND av.ProductID IN (468)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "DAME008TT" AND av.ProductID IN (468)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "DAME001TT" AND av.ProductID IN (468)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "DAME005TT" AND av.ProductID IN (468)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1723945" AND av.ProductID IN (468)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1724145" AND av.ProductID IN (468)) ) 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 = 80 AND aa.DataSupplierArticleNumber = "137100N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "137100T") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8ML 376 723-721") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8ML 376 724-061") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8MY 376 744-411") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0706.3007") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8ML 376 724-061") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8MY 376 744-411") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8ML 376 723-721") OR (aa.SupplierID = 296 AND aa.DataSupplierArticleNumber = "817M07A") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "96972") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "96971") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "30409") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "30905") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "DAME008TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "DAME001TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "DAME005TT") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1723945") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1724145") ) 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 = 80 AND aa.DataSupplierArticleNumber = "137100N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "137100T") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8ML 376 723-721") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8ML 376 724-061") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8MY 376 744-411") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0706.3007") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8ML 376 724-061") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8MY 376 744-411") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8ML 376 723-721") OR (aa.SupplierID = 296 AND aa.DataSupplierArticleNumber = "817M07A") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "96972") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "96971") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "30409") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "30905") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "DAME008TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "DAME001TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "DAME005TT") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1723945") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1724145") ) AND aa.Language = "ru" Продажа автозапчастей типа Охладительнаддувочного воздуха (интеркулер) для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AKS DASIS 137100N Интеркулер
137100T Интеркулер
BEHR HELLA SERVICE 8ML 376 723-721 Интеркулер
8ML 376 724-061 Интеркулер
8MY 376 744-411 Сетка радиатора, интеркулер
FRIGAIR 0706.3007 Интеркулер
HELLA 8ML 376 724-061 Интеркулер
8MY 376 744-411 Сетка радиатора, интеркулер
8ML 376 723-721 Интеркулер
JDEUS 817M07A Интеркулер
NISSENS 96972 Интеркулер
96971 Интеркулер
NRF 30409 Интеркулер
30905 Интеркулер
THERMOTEC DAME008TT Интеркулер
DAME001TT Интеркулер
DAME005TT Интеркулер
WILMINK GROUP WG1723945 Интеркулер
WG1724145 Интеркулер
2026 CATCAR.INFO (v 2.0)