#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTU0MjZ8fG1kZl9pZD09MF4xMTA1NTV8fHNwYXJlX2lkPT0xMDA0OTE%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 = "110555" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "22007100" AND av.ProductID IN (135)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "220154S" AND av.ProductID IN (593)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "726.760" AND av.ProductID IN (135)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "8030013" AND av.ProductID IN (593)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1227192" AND av.ProductID IN (593)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1194514" 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 = "22007100") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "220154S") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "726.760") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "8030013") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1227192") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1194514") ) 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 = "22007100") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "220154S") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "726.760") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "8030013") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1227192") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1194514") ) AND aa.Language = "ru" Продажа автозапчастей типа Винт сливного отверстия для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 22007100 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
CORTECO 220154S Резьбовая пробка, масляный поддон
ELRING 726.760 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
METZGER 8030013 Резьбовая пробка, масляный поддон
WILMINK GROUP WG1227192 Резьбовая пробка, масляный поддон
WG1194514 Уплотнительное кольцо, резьбовая пробка маслосливн. отверст.
2026 CATCAR.INFO (v 2.0)