SELECT *, ((wins*2)+tie) points FROM TEAMS t1 WHERE t1.agegroup = ORDER BY points DESC SELECT (sum(gr.goals)+sum(gr.assists)) points, t.name tname, p.pnumber, p.name, sum(gr.goals) goals, sum(gr.assists) assists, sum(gr.pm) pm, (select count(game_id) FROM game_results gr, games g WHERE gr.game_id = g.id AND gr.player_id = p.id AND gr.status = 0 AND g.playoff = 0) as games FROM TEAMS t, PLAYERS p, game_results gr, games g WHERE t.id = p.team AND gr.player_id = p.id AND t.agegroup = AND g.id = gr.game_id AND g.playoff = 0 GROUP BY p.id ORDER BY points DESC LIMIT 10 Peewee Stats | Midget Tier 1 Stats | Bantam Stats

>>Show all #uCase(url.agegroup)# Players

#uCase(url.agegroup)# Teams
Team	Games	Wins	Loss	Tie	GF/GA	Points
#HTMLEditFormat(name)#	#games#	#wins#	#loss#	#tie#	#gf# - #ga#	#points#

Top 10 #Ucase(url.agegroup)# Scorers
Player	Team	Games	Goals	Assists	Points	PM
#HTMLEditFormat(name)#	#tname#	#games#	#goals#	#assists#	#points#	#pm#