# HG changeset patch
# User Laman
# Date 2019-05-29 12:32:09
# Node ID ce5c50aae93a857d8a4b429cc879c2e25b4b2756
# Parent  402daa48409f8b03db1093fed6e5d195e5a3b9e9

lifespans: přidán min_rating

diff --git a/queries.py b/queries.py
--- a/queries.py
+++ b/queries.py
@@ -278,12 +278,12 @@ def playersProgress():
 
 def lifeSpans():
 	"""Životnosti hráčů. Datum prvního a posledního turnaje, jejich rozdíl v letech, počet odehraných turnajů."""
-	query="""select pin,min(datum) as min_datum,max(datum) as max_datum,(julianday(max(datum))-julianday(min(datum)))/365.25 as lifespan,count(datum) as t_count,max(rating_after) as max_rating
-		from players_performance_tournaments group by pin having min(rating_before)<=100"""
+	query="""select pin,min(datum) as min_datum,max(datum) as max_datum,(julianday(max(datum))-julianday(min(datum)))/365.25 as lifespan,count(datum) as t_count,max(rating_after) as max_rating,min(rating_before) as min_rating
+		from players_performance_tournaments group by pin"""
 
 	res=cursor.execute(query)
 
-	print("pin\tmin datum\tmax datum\tmax-min\tpočet turnajů\tmax rating")
+	print("pin\tmin datum\tmax datum\tmax-min\tpočet turnajů\tmax rating\tmin rating")
 	for rec in res:
 		print("\t".join([str(x) for x in rec]))