diff options
Diffstat (limited to 'src/database.rs')
| -rw-r--r-- | src/database.rs | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/database.rs b/src/database.rs index 5bdb4f4..2f1e24d 100644 --- a/src/database.rs +++ b/src/database.rs @@ -251,9 +251,9 @@ const LEADERBOARD_QUERY: &'static str = "\ leaderboard_LBID.* FROM leaderboard_LBID JOIN ( - SELECT user_id, max(timestamp) as timestamp - FROM leaderboard_history_LBID - GROUP BY user_id + SELECT user_id, max(timestamp) as timestamp + FROM leaderboard_history_LBID + GROUP BY user_id ) history ON history.user_id = leaderboard_LBID.user_id ORDER BY leaderboard_LBID.points DESC, history.timestamp ASC;"; |