#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0OXx8bW9kZWxfaWQ9PTQwODV8fG1kZl9pZD09MF4xMTI4NHx8c3BhcmVfaWQ9PTEwMDQ5MQ%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 = "11284" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "21012700" AND av.ProductID IN (135)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "111.104" AND av.ProductID IN (135)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "KJ779" AND av.ProductID IN (135)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1182961" AND av.ProductID IN (135)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1084951" AND av.ProductID IN (135)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1163712" AND av.ProductID IN (135)) ) 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 = 139 AND aa.DataSupplierArticleNumber = "21012700") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "111.104") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "KJ779") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1182961") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1084951") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163712") ) 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 = 139 AND aa.DataSupplierArticleNumber = "21012700") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "111.104") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "KJ779") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1182961") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1084951") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163712") ) AND aa.Language = "ru" Продажа автозапчастей типа Винт сливного отверстия для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 21012700 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
ELRING 111.104 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
PAYEN KJ779 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
WILMINK GROUP WG1182961 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
WG1084951 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
WG1163712 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
2026 CATCAR.INFO (v 2.0)