#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTk3MzF8fG1kZl9pZD09MF41OTY2M3x8c3BhcmVfaWQ9PTEwMDg3Mg%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 = "59663" AND ( (av.SupplierID = 128 AND av.DataSupplierArticleNumber = "130125" AND av.ProductID IN (2234)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "17355" AND av.ProductID IN (3314)) OR (av.SupplierID = 345 AND av.DataSupplierArticleNumber = "550649" AND av.ProductID IN (3739,3739)) OR (av.SupplierID = 345 AND av.DataSupplierArticleNumber = "336649" AND av.ProductID IN (2234,2234)) OR (av.SupplierID = 182 AND av.DataSupplierArticleNumber = "PRO-01295" AND av.ProductID IN (2234)) OR (av.SupplierID = 182 AND av.DataSupplierArticleNumber = "166-01295" AND av.ProductID IN (2234)) OR (av.SupplierID = 182 AND av.DataSupplierArticleNumber = "172-05510" AND av.ProductID IN (2234)) OR (av.SupplierID = 4362 AND av.DataSupplierArticleNumber = "652103" AND av.ProductID IN (2234)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "11451783601" AND av.ProductID IN (3314)) ) 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 = 128 AND aa.DataSupplierArticleNumber = "130125") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "17355") OR (aa.SupplierID = 345 AND aa.DataSupplierArticleNumber = "550649") OR (aa.SupplierID = 345 AND aa.DataSupplierArticleNumber = "336649") OR (aa.SupplierID = 182 AND aa.DataSupplierArticleNumber = "PRO-01295") OR (aa.SupplierID = 182 AND aa.DataSupplierArticleNumber = "166-01295") OR (aa.SupplierID = 182 AND aa.DataSupplierArticleNumber = "172-05510") OR (aa.SupplierID = 4362 AND aa.DataSupplierArticleNumber = "652103") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "11451783601") ) 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 = 128 AND aa.DataSupplierArticleNumber = "130125") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "17355") OR (aa.SupplierID = 345 AND aa.DataSupplierArticleNumber = "550649") OR (aa.SupplierID = 345 AND aa.DataSupplierArticleNumber = "336649") OR (aa.SupplierID = 182 AND aa.DataSupplierArticleNumber = "PRO-01295") OR (aa.SupplierID = 182 AND aa.DataSupplierArticleNumber = "166-01295") OR (aa.SupplierID = 182 AND aa.DataSupplierArticleNumber = "172-05510") OR (aa.SupplierID = 4362 AND aa.DataSupplierArticleNumber = "652103") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "11451783601") ) AND aa.Language = "ru" Продажа автозапчастей типа нагнетатель для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BE TURBO 130125 Компрессор, наддув
MALÒ 17355 Трубка нагнетаемого воздуха
MOTAIR TURBO 550649 Маслопровод, компрессор
336649 Компрессор, наддув
SCHLÜTTER TURBOLADER PRO-01295 Компрессор, наддув
166-01295 Компрессор, наддув
172-05510 Компрессор, наддув
TURBO-MOT 652103 Компрессор, наддув
vika 11451783601 Трубка нагнетаемого воздуха
2026 CATCAR.INFO (v 2.0)