#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU0NXx8bW9kZWxfaWQ9PTQxMzF8fG1kZl9pZD09MF4xMTYzN3x8c3BhcmVfaWQ9PTEwMDMxNA%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 = "11637" AND ( (av.SupplierID = 415 AND av.DataSupplierArticleNumber = "P3233" AND av.ProductID IN (3437)) OR (av.SupplierID = 415 AND av.DataSupplierArticleNumber = "P3232" AND av.ProductID IN (3436)) OR (av.SupplierID = 415 AND av.DataSupplierArticleNumber = "P3234" AND av.ProductID IN (3437)) OR (av.SupplierID = 415 AND av.DataSupplierArticleNumber = "P3238" AND av.ProductID IN (3436)) OR (av.SupplierID = 445 AND av.DataSupplierArticleNumber = "240703" AND av.ProductID IN (3437)) OR (av.SupplierID = 13 AND av.DataSupplierArticleNumber = "22127" AND av.ProductID IN (3437)) ) 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 = 415 AND aa.DataSupplierArticleNumber = "P3233") OR (aa.SupplierID = 415 AND aa.DataSupplierArticleNumber = "P3232") OR (aa.SupplierID = 415 AND aa.DataSupplierArticleNumber = "P3234") OR (aa.SupplierID = 415 AND aa.DataSupplierArticleNumber = "P3238") OR (aa.SupplierID = 445 AND aa.DataSupplierArticleNumber = "240703") OR (aa.SupplierID = 13 AND aa.DataSupplierArticleNumber = "22127") ) 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 = 415 AND aa.DataSupplierArticleNumber = "P3233") OR (aa.SupplierID = 415 AND aa.DataSupplierArticleNumber = "P3232") OR (aa.SupplierID = 415 AND aa.DataSupplierArticleNumber = "P3234") OR (aa.SupplierID = 415 AND aa.DataSupplierArticleNumber = "P3238") OR (aa.SupplierID = 445 AND aa.DataSupplierArticleNumber = "240703") OR (aa.SupplierID = 13 AND aa.DataSupplierArticleNumber = "22127") ) AND aa.Language = "ru" Продажа автозапчастей типа Глушитель для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FENNO P3233 Глушитель выхлопных газов конечный
P3232 Средний глушитель выхлопных газов
P3234 Глушитель выхлопных газов конечный
P3238 Средний глушитель выхлопных газов
KLARIUS 240703 Глушитель выхлопных газов конечный
WALKER 22127 Глушитель выхлопных газов конечный
2026 CATCAR.INFO (v 2.0)