var temp = _context.PlayerStats.Where(T => T.allianceId == _surf).Select(T => T.guildId).Distinct();
var result = new Dictionary<string, string>();
foreach (var item in temp)
result[item] = _context.PlayerStats.FirstOrDefault(T => T.guildId == item).guildName;
return View(result);