YMSSA

Girls Hockey Playoffs

Games
Bracket
Rules
Standings

Reseed after Round #1 (Play-In games).

Playoffs start 5/2

Round #1 (PLAY-IN) - 7vs10; 8vs9 (Games completed by 5/7)
Round #2 1vs8; 2vs7; 3vs6; 4vs5 (Games completed by 5/14)
Round #3 (SemFinal) - 1vs4; 2vs3 (Games completed by 5/23)

Semis

Kushner	Thu 05/22
@ Noam	6:30 PM

Yavneh	Fri 05/23
@ SAR	3:00 PM

Quarters

WDS	1
@ Yavneh	2

Moriah	1
@ Kushner	4

RPRY	1
@ SAR	6

Ramaz	0
@ Noam	7

First Round

Ramaz	3
@ TCA	1

He'Atid	4
@ RPRY	5

Playoff Bracket

First Round	Quarter-finals	Semi-finals	Final	Semi-finals	Quarter-finals	First Round
SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 1 SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 2 SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 3 SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 4 TCA1 Ramaz3	SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 5 Kushner4 Moriah1 SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 6 Noam7 Ramaz0	SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 7 Noam Kushner 5/22 6:30pm @ Noam	SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 16 WINNER SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 8	SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 9 SAR Yavneh 5/23 3:00pm @ SAR	SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 10 Yavneh2 WDS1 SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 11 SAR6 RPRY1	SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 12 SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 13 SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 14 SELECT B., SH.school_name as TopSchool , SA.school_name as BotSchool, Top.logo as tlogo , Bot.logo as blogo, SH.logo as topschoollogo, SA.logo as bottomschoollogo, uses_text_score, G.gym_id_fk, Gyms., G.watch_link_url, Top.team_video_url, Bot.team_video_url as bot_team_video_url, G.dont_show_score FROM PlayoffBrackets B Left Join Games G on B.game_id_fk = G.GameID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Left Join Teams Top on Top.TeamID = top_team_id_fk Left Join Teams Bot on Bot.TeamID = bottom_team_id_fk Left Join Schools SH on SH.school_id = Top.school_id_fk Left Join Schools SA on SA.school_id = Bot.school_id_fk LEFT JOIN Leagues L on L.LeagueID = B.league_id_fk WHERE B.league_id_fk = 7 AND slot_number = 15 RPRY5 He'Atid4

Playoff Setup

(Tiebreaking rules below)

Girls Hockey (10 teams total make playoffs):

Playoffs start 5/2

Round #1 (PLAY-IN) - 7vs10; 8vs9 (Games completed by 5/7)
Round #2 1vs8; 2vs7; 3vs6; 4vs5 (Games completed by 5/14)
Round #3 (SemFinal) - 1vs4; 2vs3 (Games completed by 5/23)

Championship Game: Wednesday 5/28 @ TABC. 6:30pm puck drop

Tiebreaker Rules

Tiebreakers:
Points
Total Wins
Head to Head win/loss
Home Record
Away Record
Coin Flip

Standings

Team	Division	Points	Wins	Loss	Ties
Noam	Blue	14	7	1	0
SAR	Blue	14	7	1	0
Yavneh	Blue	12	6	2	0
Kushner	Blue	11	5	2	1
Moriah	Blue	11	5	2	1
WDS	Blue	8	4	4	0
RPRY	Blue	4	2	6	0
TCA	Blue	3	1	6	1
Ramaz	Blue	3	1	6	1
He'Atid	Blue	0	0	8	0