var results = ( from gp in ctx.GamePlayers
                                join games in ctx.Games on gp.GameID equals games.GameID
                                join names in ctx.PlayersNames on gp.PlayerNameID equals    names.PlayerNameID
                                join player in ctx.Players on gp.PlayerID equals player.PlayerID
                                where games.EndReason != 0
                                where games.IsValid
                                where gp.Player.SteamID != 0
                                group gp by gp.PlayerID into gpp
                                select new
                                {
                                    lastName = gpp.FirstOrDefault().PlayerID,
                                } );