From 27f687988ff2704ad6595df4ae24391545e19be3 Mon Sep 17 00:00:00 2001 From: emkael Date: Wed, 5 Apr 2017 22:23:32 +0200 Subject: Storing categories in rankings table, as they change --- ranking.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/ranking.py b/ranking.py index 59b9310..154f877 100644 --- a/ranking.py +++ b/ranking.py @@ -19,9 +19,9 @@ def fetch_ranking(date, assoc=False): rankings.pid, CONCAT(players.name, " ", players.surname) player, players.rank, - players.region, players.club, - REPLACE(players.flags, "K", "") age, - IF(players.flags LIKE 'K%', "K", "") gender, + rankings.region, players.club, + REPLACE(rankings.flags, "K", "") age, + IF(rankings.flags LIKE 'K%', "K", "") gender, rankings.score FROM rankings JOIN players -- cgit v1.2.3