summaryrefslogtreecommitdiff
path: root/scripts/pyranking
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2017-09-07 14:44:00 +0200
committeremkael <emkael@tlen.pl>2017-09-07 14:44:00 +0200
commit42bfe1195b453feec3018b15f8a99b5f2f9f4339 (patch)
tree8c9d1e0058fd8a39db8f0b2ccafb158a498379bd /scripts/pyranking
parent9653e31ca7ef40a408d176d338cd93a8076b3318 (diff)
Connecting players' ranks and clubs with specific ranking edition
Diffstat (limited to 'scripts/pyranking')
-rw-r--r--scripts/pyranking/fetch.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/pyranking/fetch.py b/scripts/pyranking/fetch.py
index 0d301d4..304f509 100644
--- a/scripts/pyranking/fetch.py
+++ b/scripts/pyranking/fetch.py
@@ -5,8 +5,8 @@ def fetch_ranking(date, assoc=False):
rankings.place,
rankings.pid,
CONCAT(players.name, " ", players.surname) player,
- players.rank,
- rankings.region, players.club,
+ rankings.rank,
+ rankings.region, rankings.club,
REPLACE(rankings.flags, "K", "") age,
IF(rankings.flags LIKE 'K%', "K", "") gender,
rankings.score