summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2017-04-05 22:23:32 +0200
committeremkael <emkael@tlen.pl>2017-04-05 22:23:32 +0200
commit27f687988ff2704ad6595df4ae24391545e19be3 (patch)
tree3487adec92e9d72bb6b42c1900b93ae77432f126
parent4a1ed687bf484ce99395e40194cb56bff753524b (diff)
Storing categories in rankings table, as they change
-rw-r--r--ranking.py6
1 files 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