diff options
| author | emkael <emkael@tlen.pl> | 2017-04-05 22:23:32 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2017-04-05 22:23:32 +0200 |
| commit | 27f687988ff2704ad6595df4ae24391545e19be3 (patch) | |
| tree | 3487adec92e9d72bb6b42c1900b93ae77432f126 | |
| parent | 4a1ed687bf484ce99395e40194cb56bff753524b (diff) | |
Storing categories in rankings table, as they change
| -rw-r--r-- | ranking.py | 6 |
1 files changed, 3 insertions, 3 deletions
@@ -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 |