Use the GIN index wherever possible.

[xonotic/xonstat.git] / xonstat / views / helpers.py

diff --git a/xonstat/views/helpers.py b/xonstat/views/helpers.py
index 8a10a48b733d8602ea3f5fd6fb72203021eaae23..d8b3211e1c231b7c806d799c69bdfc34e8c9e548 100644 (file)
--- a/xonstat/views/helpers.py
+++ b/xonstat/views/helpers.py
@@ -116,11 +116,13 @@ def recent_games_q(server_id=None, map_id=None, player_id=None,
     if player_id is not None:
         if force_player_id:
             recent_games_q = recent_games_q.\
-                filter(PlayerGameStat.player_id==player_id)
+                filter(PlayerGameStat.player_id==player_id).\
+                filter(Game.players.contains([player_id]))
         else:
             recent_games_q = recent_games_q.\
                 filter(PlayerGameStat.scoreboardpos==1).\
                 filter(Game.game_id==pgstat_alias.game_id).\
+                filter(Game.players.contains([player_id])).\
                 filter(pgstat_alias.player_id==player_id)
     else:
         recent_games_q = recent_games_q.\