- games_q = DBSession.query(Game.game_id, Game.game_type_cd, Game.winner,
- Game.create_dt, Server.server_id,
- Server.name.label('server_name'), Map.map_id,
- Map.name.label('map_name'), PlayerGameStat.team,
- PlayerGameStat.rank, PlayerGameStat.elo_delta).\
- filter(PlayerGameStat.game_id == Game.game_id).\
- filter(PlayerGameStat.player_id == player_id).\
- filter(Game.server_id == Server.server_id).\
- filter(Game.map_id == Map.map_id).\
- order_by(Game.game_id.desc())