#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTczOXx8bW9kZWxfaWQ9PTQxOTd8fG1kZl9pZD09MV42NDg3fHxzcGFyZV9pZD09MjAxMDY3&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 = "6487" AND ( (av.SupplierID = 233 AND av.DataSupplierArticleNumber = "164001012" AND av.ProductID IN (26)) OR (av.SupplierID = 233 AND av.DataSupplierArticleNumber = "164000014" AND av.ProductID IN (26)) OR (av.SupplierID = 233 AND av.DataSupplierArticleNumber = "164001016" AND av.ProductID IN (26)) OR (av.SupplierID = 233 AND av.DataSupplierArticleNumber = "164001013" AND av.ProductID IN (26)) OR (av.SupplierID = 233 AND av.DataSupplierArticleNumber = "164000015" AND av.ProductID IN (26)) OR (av.SupplierID = 233 AND av.DataSupplierArticleNumber = "164001014" AND av.ProductID IN (26)) OR (av.SupplierID = 233 AND av.DataSupplierArticleNumber = "164001011" AND av.ProductID IN (26)) OR (av.SupplierID = 233 AND av.DataSupplierArticleNumber = "164000013" AND av.ProductID IN (26)) OR (av.SupplierID = 233 AND av.DataSupplierArticleNumber = "164001015" AND av.ProductID IN (26)) ) 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 = 233 AND aa.DataSupplierArticleNumber = "164001012") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164000014") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164001016") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164001013") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164000015") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164001014") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164001011") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164000013") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164001015") ) 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 = 233 AND aa.DataSupplierArticleNumber = "164001012") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164000014") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164001016") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164001013") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164000015") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164001014") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164001011") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164000013") OR (aa.SupplierID = 233 AND aa.DataSupplierArticleNumber = "164001015") ) AND aa.Language = "ru" Продажа автозапчастей типа глушители в комплекте для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
DINEX 164001012 Система выпуска ОГ
164000014 Система выпуска ОГ
164001016 Система выпуска ОГ
164001013 Система выпуска ОГ
164000015 Система выпуска ОГ
164001014 Система выпуска ОГ
164001011 Система выпуска ОГ
164000013 Система выпуска ОГ
164001015 Система выпуска ОГ
2026 CATCAR.INFO (v 2.0)