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 = 1) 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 = 1 AND (gr.goals >= 1 OR gr.assists >= 1) GROUP BY p.id ORDER BY points DESC LIMIT 10 Peewee Stats | Midget Tier 1 Stats | Bantam Stats

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

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

There are no playoff statistics available at this time.