#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4Nnx8bW9kZWxfaWQ9PTk3Mjh8fG1kZl9pZD09MV4xNzExOXx8c3BhcmVfaWQ9PTIwMDA4Nw%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 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 = "17119" AND ( (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8MK 376 906-331" AND av.ProductID IN (470)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "0211.2013" AND av.ProductID IN (470)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8MK 376 906-331" AND av.ProductID IN (470)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "50192" AND av.ProductID IN (470)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "733553" AND av.ProductID IN (470)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1721150" AND av.ProductID IN (470)) ) 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 = 105 AND aa.DataSupplierArticleNumber = "8MK 376 906-331") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0211.2013") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8MK 376 906-331") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "50192") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "733553") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1721150") ) 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 = 105 AND aa.DataSupplierArticleNumber = "8MK 376 906-331") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0211.2013") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8MK 376 906-331") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "50192") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "733553") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1721150") ) AND aa.Language = "ru" Продажа автозапчастей типа Радиатор печки / комплектующие для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BEHR HELLA SERVICE 8MK 376 906-331 Радиатор, охлаждение двигателя
FRIGAIR 0211.2013 Радиатор, охлаждение двигателя
HELLA 8MK 376 906-331 Радиатор, охлаждение двигателя
NRF 50192 Радиатор, охлаждение двигателя
VALEO 733553 Радиатор, охлаждение двигателя
WILMINK GROUP WG1721150 Радиатор, охлаждение двигателя
2026 CATCAR.INFO (v 2.0)