#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTUwODR8fG1kZl9pZD09MF4zNDk1MHx8c3BhcmVfaWQ9PTEwMDU0OQ%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 = "34950" AND ( (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP23504" AND av.ProductID IN (1137)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "93073" AND av.ProductID IN (1137)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0892077" AND av.ProductID IN (1137)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T493073" AND av.ProductID IN (1137)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-63-0065" AND av.ProductID IN (1137)) ) 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 = 157 AND aa.DataSupplierArticleNumber = "BSP23504") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "93073") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0892077") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T493073") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-63-0065") ) 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 = 157 AND aa.DataSupplierArticleNumber = "BSP23504") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "93073") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0892077") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T493073") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-63-0065") ) AND aa.Language = "ru" Продажа автозапчастей типа Клапаны, рециркуляция ОГ для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BUGIAD BSP23504 Клапан, управление рециркуляция ОГ
Metalcaucho 93073 Клапан, управление рециркуляция ОГ
METZGER 0892077 Клапан, управление рециркуляция ОГ
STC T493073 Клапан, управление рециркуляция ОГ
VEMO V10-63-0065 Клапан, управление рециркуляция ОГ
2026 CATCAR.INFO (v 2.0)