From 27f687988ff2704ad6595df4ae24391545e19be3 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
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(-)

(limited to 'ranking.py')

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