#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2M3x8bW9kZWxfaWQ9PTkwMTJ8fG1kZl9pZD09MF41NjI2MHx8c3BhcmVfaWQ9PTEwMDM5Mw%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 = "56260" AND ( (av.SupplierID = 4688 AND av.DataSupplierArticleNumber = "105767" AND av.ProductID IN (468)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "ARD3510" AND av.ProductID IN (468)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "PRD3510" AND av.ProductID IN (468)) OR (av.SupplierID = 247 AND av.DataSupplierArticleNumber = "PE4362" AND av.ProductID IN (468)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "0703.3005" AND av.ProductID IN (468)) OR (av.SupplierID = 296 AND av.DataSupplierArticleNumber = "821M35A" AND av.ProductID IN (468)) OR (av.SupplierID = 123 AND av.DataSupplierArticleNumber = "96497" AND av.ProductID IN (468)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "30319" AND av.ProductID IN (468)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "40004362" AND av.ProductID IN (468)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1723874" 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 = 4688 AND aa.DataSupplierArticleNumber = "105767") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "ARD3510") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "PRD3510") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "PE4362") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0703.3005") OR (aa.SupplierID = 296 AND aa.DataSupplierArticleNumber = "821M35A") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "96497") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "30319") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "40004362") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1723874") ) 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 = 4688 AND aa.DataSupplierArticleNumber = "105767") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "ARD3510") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "PRD3510") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "PE4362") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0703.3005") OR (aa.SupplierID = 296 AND aa.DataSupplierArticleNumber = "821M35A") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "96497") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "30319") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "40004362") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1723874") ) AND aa.Language = "ru" Продажа автозапчастей типа Охладитель наддувочного воздуха (интеркулер) для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTOGAMMA 105767 Интеркулер
AUTOMOTOR France ARD3510 Интеркулер
PRD3510 Интеркулер
AVA QUALITY COOLING PE4362 Интеркулер
FRIGAIR 0703.3005 Интеркулер
JDEUS 821M35A Интеркулер
NISSENS 96497 Интеркулер
NRF 30319 Интеркулер
VAN WEZEL 40004362 Интеркулер
WILMINK GROUP WG1723874 Интеркулер
2026 CATCAR.INFO (v 2.0)