YMSSA


Quarters

 
2
@
1
 
Mon 05/11
@
7:30 PM
 
Tue 05/12
@
6:30 PM
 
Tue 05/12
@
8:15 PM

Playoff Bracket

Quarter-finals Semi-finals Final Semi-finals Quarter-finals
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 = 16 AND slot_number = 5
Noam
RPRY
5/11 7: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 = 16 AND slot_number = 6
Kushner
SAR
5/12 6:30pm @ Kushner
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 = 16 AND slot_number = 7
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 = 16 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 = 16 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 = 16 AND slot_number = 9
Yavneh
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 = 16 AND slot_number = 10
WDS1
Yavneh2
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 = 16 AND slot_number = 11
Moriah
He'Atid
5/12 8:15pm @ Moriah

Playoff Setup

(Tiebreaking rules below)



Girls Hockey League (8 teams total make playoffs)

Playoffs begin May 5th

* Round #1: 1vs8; 2vs7; 3vs6; 4vs5 (Games completed by 5/12)
* Round #2: (SemFinal) - 1vs4; 2vs3 (Games completed by 5/24)
* Championship Game: Wednesday 5/27 @ Frisch OR TABC



Tiebreaker Rules

(2 TEAMS TIED):

1. Total Wins
2. Ties beat Overtime Losses
3. Head to Head
4. Points vs Playoff Teams
5. STRENGTH OF SCHEDULE (the team that achieved their record against the schedule with the highest combined points total of all of their opponents, then if still tied, the highest winning pct of all of their opponents, which ultimately means that the team that played the hardest schedule, wins this tie-breaker.)
6. STRENGTH OF VICTORY (the team that achieved their win total against opponents with the highest combined winning pct.)
7. Coin Toss for Seeding.

(3 OR MORE TEAMS TIED):
1. Total Wins
2. Ties beat Overtime Losses
3. Head to Head - Most points of all tied teams versus each other. (If the head to head record is tied, then the best margin of victory in all head to head games between all of the teams involved in the tie is calculated to a maximum margin of 3 goals per game. For this tiebreaker, the total combined number of games played vs the other teams involved in the tie by each team in the tie must be the same. Not the # of games against any individual team in the tie but the combined number of games against all of the teams in the tie) IF HEAD TO HEAD POINTS/GOALS DOESN'T BREAK THE MULTIPLE TEAM TIE BEC OF AN UNEVEN # OF GAMES PLAYED VS ALL THOSE INVOLVED IN THE TIE THEN WE MOVE TO RECORD OF ALL TIED TEAMS IN HEAD TO HEAD GAMES BY WINNING PCT EVEN IF # OF GMS PLAYED VS THE ENTIRE GROUP TIED IS NOT EQUAL.

STEPS 4-7 EXACTLY AS ABOVE.

EACH TIE-BREAKING STEP SERVES TO SEPARATE AS MANY TEAMS AS POSSIBLE, WHO WILL THEN BE PLACED IN THE STANDINGS IN THE ORDER IN WHICH THEY FINISH IN THAT TIEBREAKER.

Standings

Team DivisionPoints Wins LossOTLTies
Blue15 7001
Blue13 6101
Blue12 6200
Blue11 5201
Blue10 5300
Blue7 3410
Blue7 3410
Blue4 2600
Blue3 1601
Blue0 0800