# HG changeset patch
# User Laman
# Date 2018-04-01 13:59:11
# Node ID ed00726edba54092757d77ba640b63ede0c7812f
# Parent  6048d5c40c9b31f40750ab4b5e7f5b2d4b4e97b7

fix populationAge pro hráče měnící země. 14586913 2006

diff --git a/queries.py b/queries.py
--- a/queries.py
+++ b/queries.py
@@ -126,8 +126,8 @@ def populationAge(year,country):
 				select ppt1.pin,min(ppt1.datum) as min_datum
 					from players_performance_tournaments as ppt1
 						join players_performance_tournaments as ppt2 on ppt1.pin=ppt2.pin
-					where ppt2.datum>=date(?) and ppt2.datum<date(?) and ppt1.p_country_code=?
-					group by ppt1.pin
+					where ppt2.datum>=date(?) and ppt2.datum<date(?) and ppt2.p_country_code=?
+					group by ppt2.pin
 			)
 			group by playing_years
 	"""
@@ -154,7 +154,7 @@ def tournamentAttendance(year):
 # yearByCountry(2017)
 # timeRank(2017,"CZ")
 # populationStrength(2017,"CZ")
-# populationAge(2017,"CZ")
+# populationAge(2006,"CZ")
 # tournamentAttendance(2010)
 # yearsByCountry(2001,2018)
 # populationStrength(2017,2018,"CZ")