SELECT RESULTS.id, t1.name AS 'teamname1', t2.name as 'teamname2', RESULTS.team1_score, RESULTS.team2_score, g.number FROM RESULTS INNER JOIN TEAMS t1 ON RESULTS.team1=t1.id INNER JOIN TEAMS t2 ON RESULTS.team2=t2.id INNER JOIN games g ON RESULTS.gameid = g.id WHERE t1.agegroup = AND g.playoff = 0 ORDER BY g.number ASC Change League:

There are currently no #URL.agegroup# game results. Please check back later.

#ucase(URL.agegroup)# GAME RESULTS

Game #:	Home Team:		Away Team:
#number#	#getResults.teamname1#	#getResults.team1_score#	#getResults.teamname2#	#getResults.team2_score#