#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTQ2NjJ8fG1kZl9pZD09MF4xNDk3M3x8c3BhcmVfaWQ9PTEwMjQ1MA%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 = "14973" AND ( (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "89.148" AND av.ProductID IN (387)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "8091038" AND av.ProductID IN (387)) OR (av.SupplierID = 6 AND av.DataSupplierArticleNumber = "561 0006 10" AND av.ProductID IN (387)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "91038" AND av.ProductID IN (387)) OR (av.SupplierID = 5 AND av.DataSupplierArticleNumber = "7.24807.03.0" AND av.ProductID IN (387)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "89.148" AND av.ProductID IN (387)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.11.028" AND av.ProductID IN (387)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.11.029" AND av.ProductID IN (387)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V30-8227" AND av.ProductID IN (387)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1014476" AND av.ProductID IN (387)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1026894" AND av.ProductID IN (387)) ) 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 = 441 AND aa.DataSupplierArticleNumber = "89.148") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "8091038") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "561 0006 10") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "91038") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.24807.03.0") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "89.148") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.028") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.029") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-8227") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1014476") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1026894") ) 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 = 441 AND aa.DataSupplierArticleNumber = "89.148") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "8091038") OR (aa.SupplierID = 6 AND aa.DataSupplierArticleNumber = "561 0006 10") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "91038") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.24807.03.0") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "89.148") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.028") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.11.029") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-8227") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1014476") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1026894") ) AND aa.Language = "ru" Продажа автозапчастей типа Вакуумный насос для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FISPA 89.148 Вакуумный насос, тормозная система
HOFFER 8091038 Вакуумный насос, тормозная система
LuK 561 0006 10 Вакуумный насос, тормозная система
MEAT & DORIA 91038 Вакуумный насос, тормозная система
PIERBURG 7.24807.03.0 Вакуумный насос, тормозная система
SIDAT 89.148 Вакуумный насос, тормозная система
TRUCKTEC AUTOMOTIVE 02.11.028 Вакуумный насос, тормозная система
02.11.029 Вакуумный насос, тормозная система
VAICO V30-8227 Вакуумный насос, тормозная система
WILMINK GROUP WG1014476 Вакуумный насос, тормозная система
WG1026894 Вакуумный насос, тормозная система
2026 CATCAR.INFO (v 2.0)