#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2Nnx8bW9kZWxfaWQ9PTM5MDJ8fG1kZl9pZD09MF4xNzk5N3x8c3BhcmVfaWQ9PTEwMDM5Mw%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 articlepassengercars av JOIN passengercarlinkageattributes_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 = "17997" AND ( (av.SupplierID = 422 AND av.DataSupplierArticleNumber = "723.034" AND av.ProductID IN (468)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "187014N" AND av.ProductID IN (468)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "ARD8748" AND av.ProductID IN (468)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "PRD8748" AND av.ProductID IN (468)) OR (av.SupplierID = 247 AND av.DataSupplierArticleNumber = "RT4359" AND av.ProductID IN (468)) OR (av.SupplierID = 247 AND av.DataSupplierArticleNumber = "RTA4359" AND av.ProductID IN (468)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8ML 376 700-634" AND av.ProductID IN (468)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8ML 376 899-011" AND av.ProductID IN (468)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8ML 376 700-631" AND av.ProductID IN (468)) OR (av.SupplierID = 177 AND av.DataSupplierArticleNumber = "L970249" AND av.ProductID IN (468)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "0709.3019" AND av.ProductID IN (468)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "0709.3020" AND av.ProductID IN (468)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8ML 376 700-634" AND av.ProductID IN (468)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8ML 376 899-011" AND av.ProductID IN (468)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8ML 376 700-631" AND av.ProductID IN (468)) OR (av.SupplierID = 296 AND av.DataSupplierArticleNumber = "823M28A" AND av.ProductID IN (468)) OR (av.SupplierID = 469 AND av.DataSupplierArticleNumber = "345100" AND av.ProductID IN (468)) OR (av.SupplierID = 123 AND av.DataSupplierArticleNumber = "96767" AND av.ProductID IN (468)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "30877" AND av.ProductID IN (468)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QIC117" AND av.ProductID IN (468)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "817637" AND av.ProductID IN (468)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "43004359" AND av.ProductID IN (468)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V46-60-0007" AND av.ProductID IN (468)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1724125" 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 = 422 AND aa.DataSupplierArticleNumber = "723.034") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "187014N") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "ARD8748") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "PRD8748") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "RT4359") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "RTA4359") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8ML 376 700-634") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8ML 376 899-011") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8ML 376 700-631") OR (aa.SupplierID = 177 AND aa.DataSupplierArticleNumber = "L970249") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0709.3019") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0709.3020") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8ML 376 700-634") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8ML 376 899-011") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8ML 376 700-631") OR (aa.SupplierID = 296 AND aa.DataSupplierArticleNumber = "823M28A") OR (aa.SupplierID = 469 AND aa.DataSupplierArticleNumber = "345100") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "96767") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "30877") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QIC117") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "817637") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "43004359") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V46-60-0007") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1724125") ) 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 = "723.034") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "187014N") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "ARD8748") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "PRD8748") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "RT4359") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "RTA4359") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8ML 376 700-634") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8ML 376 899-011") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8ML 376 700-631") OR (aa.SupplierID = 177 AND aa.DataSupplierArticleNumber = "L970249") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0709.3019") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0709.3020") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8ML 376 700-634") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8ML 376 899-011") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8ML 376 700-631") OR (aa.SupplierID = 296 AND aa.DataSupplierArticleNumber = "823M28A") OR (aa.SupplierID = 469 AND aa.DataSupplierArticleNumber = "345100") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "96767") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "30877") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QIC117") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "817637") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "43004359") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V46-60-0007") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1724125") ) AND aa.Language = "ru" Продажа автозапчастей типа Охладитель наддувочного воздуха (интеркулер) для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AHE 723.034 Интеркулер
AKS DASIS 187014N Интеркулер
AUTOMOTOR France ARD8748 Интеркулер
PRD8748 Интеркулер
AVA QUALITY COOLING RT4359 Интеркулер
RTA4359 Интеркулер
BEHR HELLA SERVICE 8ML 376 700-634 Интеркулер
8ML 376 899-011 Интеркулер
8ML 376 700-631 Интеркулер
BTS Turbo L970249 Интеркулер
FRIGAIR 0709.3019 Интеркулер
0709.3020 Интеркулер
HELLA 8ML 376 700-634 Интеркулер
8ML 376 899-011 Интеркулер
8ML 376 700-631 Интеркулер
JDEUS 823M28A Интеркулер
KALE OTO RADYATÖR 345100 Интеркулер
NISSENS 96767 Интеркулер
NRF 30877 Интеркулер
QUINTON HAZELL QIC117 Интеркулер
VALEO 817637 Интеркулер
VAN WEZEL 43004359 Интеркулер
VEMO V46-60-0007 Интеркулер
WILMINK GROUP WG1724125 Интеркулер
2026 CATCAR.INFO (v 2.0)