#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUyNXx8bW9kZWxfaWQ9PTU0NTR8fG1kZl9pZD09MF4xODk1OXx8c3BhcmVfaWQ9PTEwMzI0MQ%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 = "18959" AND ( (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "060072N" AND av.ProductID IN (4032)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "963013" AND av.ProductID IN (4032)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "FDR475" AND av.ProductID IN (4032)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "XEG9287" AND av.ProductID IN (4032)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "500014" AND av.ProductID IN (4032)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "83.1217" AND av.ProductID IN (4032)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7518365" AND av.ProductID IN (4032)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "46-2008" AND av.ProductID IN (4032)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "88365" AND av.ProductID IN (4032)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "48006" AND av.ProductID IN (4032)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "83.1217" AND av.ProductID IN (4032)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "LEGR279" AND av.ProductID IN (4032,4032)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "ERV325" AND av.ProductID IN (4032,4032)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "18065" AND av.ProductID IN (4032,4032)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "EGR424" AND av.ProductID IN (4032,4032)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "817753" AND av.ProductID IN (4032)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V25-63-0038" AND av.ProductID IN (4032)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1032407" AND av.ProductID IN (4032)) ) 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 = "060072N") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "963013") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "FDR475") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "XEG9287") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "500014") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "83.1217") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7518365") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "46-2008") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "88365") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "48006") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "83.1217") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LEGR279") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ERV325") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "18065") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EGR424") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "817753") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V25-63-0038") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1032407") ) 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 = "060072N") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "963013") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "FDR475") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "XEG9287") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "500014") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "83.1217") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7518365") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "46-2008") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "88365") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "48006") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "83.1217") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "LEGR279") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "ERV325") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "18065") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "EGR424") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "817753") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V25-63-0038") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1032407") ) AND aa.Language = "ru" Продажа автозапчастей типа радиатор для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AKS DASIS 060072N Радиатор, рециркуляция ОГ
AUTEX 963013 Радиатор, рециркуляция ОГ
ELTA AUTOMOTIVE FDR475 Радиатор, рециркуляция ОГ
XEG9287 Радиатор, рециркуляция ОГ
ERA 500014 Радиатор, рециркуляция ОГ
FISPA 83.1217 Радиатор, рециркуляция ОГ
HOFFER 7518365 Радиатор, рециркуляция ОГ
IPD 46-2008 Радиатор, рециркуляция ОГ
MEAT & DORIA 88365 Радиатор, рециркуляция ОГ
NRF 48006 Радиатор, рециркуляция ОГ
SIDAT 83.1217 Радиатор, рециркуляция ОГ
SMPE LEGR279 Радиатор, рециркуляция ОГ
ERV325 Радиатор, рециркуляция ОГ
18065 Радиатор, рециркуляция ОГ
EGR424 Радиатор, рециркуляция ОГ
VALEO 817753 Радиатор, рециркуляция ОГ
VEMO V25-63-0038 Радиатор, рециркуляция ОГ
WILMINK GROUP WG1032407 Радиатор, рециркуляция ОГ
2026 CATCAR.INFO (v 2.0)