YMSSA

Boys Blue Hockey Playoffs

Games
Bracket
Rules
Standings

Championship

Noam	2
@ Yavneh	1

Semis

Moriah	3
@ Yavneh	10

RYNJ	1
@ Noam	3

Quarters

SAR	0
@ Noam	12

Moriah	4
@ Ramaz	1

Kushner	1
@ RYNJ	6

BPY	1
@ Yavneh	11

First Round

BPY	4
@ TCA	3

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 = 10 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 = 10 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 = 10 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 = 10 AND slot_number = 4 TCA3 BPY4	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 = 10 AND slot_number = 5 Ramaz1 Moriah4 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 = 10 AND slot_number = 6 Yavneh11 BPY1	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 = 10 AND slot_number = 7 Yavneh10 Moriah3	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 = 10 AND slot_number = 16 WINNER 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 = 10 AND slot_number = 8 Yavneh1 Noam2	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 = 10 AND slot_number = 9 Noam3 RYNJ1	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 = 10 AND slot_number = 10 RYNJ6 Kushner1 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 = 10 AND slot_number = 11 Noam12 SAR0	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 = 10 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 = 10 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 = 10 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 = 10 AND slot_number = 15

Playoff Setup

(Tiebreaking rules below)

Boys Hockey (Blue Division) (8 Teams)
8v9 (Play-In Game) (Game completed by 2/7)
Round #1 - 1vs8; 2vs7; 3vs6; 4vs5 (Games completed by 2/19)
Round #2 - 1vs4; 2vs3 (Games completed by 2/27)

Boys Hockey (White) (6 Teams)
Top 2 Teams get a BYE
Round 1: 3v6; 4v5 (Games completed by 2/19)
Round 2: 1v4; 2v3 (Games completed by 2/27)

Championship Games:

Blue Division: Sunday 3/2 8pm @ Frisch
White Division: Sunday 3/2 5:30pm @ TABC

Tiebreaker Rules

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

Standings

Team	Division	Points	Wins	Loss
Yavneh	Blue	16	8	0
Noam	Blue	14	7	1
RYNJ	Blue	12	6	2
Ramaz	Blue	10	5	3
Moriah	Blue	8	4	4
Kushner	Blue	6	3	5
SAR	Blue	4	2	6
TCA	Blue	2	1	7
BPY	Blue	0	0	8