SELECT g.datetime, t1.name team1, t2.name team2, g.arena, g.number number, g.playoff FROM games g, TEAMS t1, TEAMS t2 WHERE g.team_id_1 = t1.id AND g.team_id_2 = t2.id AND t1.agegroup = 'bantam' ORDER BY number SELECT g.datetime, t1.name team1, t2.name team2, g.arena, g.number number, g.playoff FROM games g, TEAMS t1, TEAMS t2 WHERE g.team_id_1 = t1.id AND g.team_id_2 = t2.id AND t1.agegroup = 'peewee' ORDER BY number SELECT g.datetime, t1.name team1, t2.name team2, g.arena, g.number number, g.playoff FROM games g, TEAMS t1, TEAMS t2 WHERE g.team_id_1 = t1.id AND g.team_id_2 = t2.id AND t1.agegroup = 'midget' ORDER BY number Note: Highlighted rows represent playoff games.

East Central Alberta Female Hockey League Bantam Schedule

Sorry, no games scheduled for Bantam at this time.

bgcolor="##EFEFEF">

Game #	Date	Home	VS	Visitor	Time	Arena
#number#	#dateformat(datetime, "d mmmm yyyy")#	#team1#	VS	#team2#	#timeformat(datetime, 'h:mm tt')#	#arena#

East Central Alberta Female Hockey League Peewee Schedule

Sorry, no games scheduled for Peewee at this time.

bgcolor="##EFEFEF">

Game #	Date	Home	VS	Visitor	Time	Arena
#number#	#dateformat(datetime, "d mmmm yyyy")#	#team1#	VS	#team2#	#timeformat(datetime, 'h:mm tt')#	#arena#

East Central Alberta Female Hockey League Midget Schedule

Sorry, no games scheduled for Midget this time.

bgcolor="##EFEFEF">

Game #	Date	Home	VS	Visitor	Time	Arena
#number#	#dateformat(datetime, "d mmmm yyyy")#	#team1#	VS	#team2#	#timeformat(datetime, 'h:mm tt')#	#arena#