Championship

 
2
@
1

Semis

 
0
@
2
 
0
@
2

Quarters

 
2
@
1
 
0
@
2
 
0
@
2
 
0
@
2

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 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 = 234 AND slot_number = 5
BRURIAH0
CENTRAL2
21-19, 21-19
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 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 = 234 AND slot_number = 6
NAALEH0
FRISCH FRISCH2
21-10, 21-18
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 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 = 234 AND slot_number = 7
CENTRAL0
FRISCH FRISCH2
21-13, 21-6
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 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 = 234 AND slot_number = 16
WINNER SAR 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 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 = 234 AND slot_number = 8
FRISCH FRISCH1
SAR SAR2
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 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 = 234 AND slot_number = 9
SAR SAR2
MAAYANOT0
21-14, 21-15
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 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 = 234 AND slot_number = 10
NORTH SHORE0
SAR SAR2
21-11, 21-5
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 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 = 234 AND slot_number = 11
MAAYANOT2
HAFTR1
13-21, 21-10, 21-18

Playoff Setup

(Tiebreaking rules below)



Top 3 teams in East Top 5 in the West conference qualify

1st Round:
#5 in the Western Conference plays at #1 in the Western Conference
#4 in the Western Conference at #1 in the Eastern Conference
#3 at #2 Cross Conference

SEMIS:
Follow Brackets. No Reseeding.
Higher remaining seeded team in any game plays at home.


CHAMPIONSHIP MATCH SUNDAY 3/3/24
(if there is a non resolvable conflict with Basketball, the Championship Match may take place on Thurs 2/29/24. Please keep both dates open!)





Tiebreaker Rules

(2 TEAMS TIED)

1. HEAD TO HEAD (MATCHES, THEN GAMES, THEN POINTS).
2. STRENGTH OF SCHEDULE
(the team that achieved their win/loss record against the schedule with the highest combined winning pct of all of their opponents, meaning the team that played the hardest schedule, wins this tie-breaker.)
3. STRENGTH OF VICTORY
(the team that achieved their win total against opponents with the highest combined winning pct.)
4. RECORD VS PLAYOFF TEAMS BY PCT (unless both undefeated, then most wins vs playoff teams, then best games record vs playoff teams).
5. PLAY-IN MATCH FOR LAST PLAYOFF SPOT, COIN TOSS FOR SEEDING.

(3 OR MORE TEAMS TIED)

1. HEAD TO HEAD (RECORD OF ALL TIED TEAMS IN HEAD TO HEAD--FIRST MATCHES, THEN GAMES, THEN POINTS. IF # OF MATCHES PLAYED IS NOT EQUAL FIRST MATCH WINNING PCT THEN GAME WINNING PCT ONLY IN THE MATCHES BETWEEN THE TIED TEAMS).

STEPS 2-5 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.

IF SOME TEAMS ARE SEPARATED BY A TIE-BREAKING STEP, BUT OTHERS INVOLVED IN A MULTI-TEAM TIEBREAKER ARE STILL TIED, WE REVERT BACK TO TIE-BREAKER #1 AND REDO ALL TIE BREAKERS IN THE SAME ORDER WITH ONLY THE STATS PERTAINING TO THE TEAMS STILL TIED REMAINING AS PART OF THE EQUATION. (FOR EXAMPLE THE HEAD TO HEAD RECORD IS NOW CALCULATED AMONG ONLY THE TEAMS REMAINING IN A TIE AND NOT AMONG ALL THE TEAMS THAT WERE ORIGINALLY TIED.)