Order by create_dt descending, not game_id descending.

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

diff --git a/xonstat/views/helpers.py b/xonstat/views/helpers.py
index d8b3211e1c231b7c806d799c69bdfc34e8c9e548..f8853a22463cc6a76236822dee4902f990b4fdd2 100644 (file)
--- a/xonstat/views/helpers.py
+++ b/xonstat/views/helpers.py
@@ -99,7 +99,7 @@ def recent_games_q(server_id=None, map_id=None, player_id=None,
             filter(Game.map_id==Map.map_id).\
             filter(Game.game_id==PlayerGameStat.game_id).\
             filter(Game.game_type_cd==GameType.game_type_cd).\
-            order_by(expr.desc(Game.game_id))
+            order_by(expr.desc(Game.create_dt))
 
     # the various filters provided get tacked on to the query
     if server_id is not None: