Array
(
[0] => 264
[LeagueID] => 264
[1] => 24
[at_league_id_fk] => 24
[2] => 5
[sport_id_fk] => 5
[3] => Girls
[LeagueName] => Girls
[4] => Girls Tennis
[full_league_name] => Girls Tennis
[5] => g-tennis
[short_league_name] => g-tennis
[6] => 2025
[season_year] => 2025
[7] => 2
[gender_id_fk] => 2
[8] => 0
[registration_open] => 0
[9] => 1
[league_is_live] => 1
[10] => 0
[start_grade] => 0
[11] => 0
[end_grade] => 0
[12] => 10
[sort_order] => 50
[13] => g-tennis
[short_name] => g-tennis
[14] => g-tennis
[short_display_name] => g-tennis
[15] =>
[rules] =>
[16] => tennis-4-4-22.pdf
[rules_pdf] => tennis-4-4-22.pdf
[17] =>
[image] =>
[18] =>
[image_title] =>
[19] => 0
[use_otl] => 0
[20] => 0
[use_ties] => 0
[21] => 0
[uses_points] => 0
[22] => 1
[uses_win_per] => 1
[23] => 0
[uses_text_score] => 0
[24] => 1
[show_playoffs] => 1
[25] => 0
[show_second_standings] => 0
[26] => 1
[uses_fields] => 1
[27] => 0
[uses_feilds_text] => 0
[28] => TOP 4 TEAMS IN EACH CONFERENCE QUALIFY
Quarters: 1 vs 4, 2 vs 3 Cross Conference.
SEMIS: Winner 1W vs 4E Plays Winner 2E vs 3W Winner 1E vs 4W Plays Winner 2W vs 3E
FINALS DATE TBD BY TWO PARTICIPATING SCHOOLS
(Better seed gets to choose location for all playoff matches including finals)
[playoff_rules] => TOP 4 TEAMS IN EACH CONFERENCE QUALIFY
Quarters: 1 vs 4, 2 vs 3 Cross Conference.
SEMIS: Winner 1W vs 4E Plays Winner 2E vs 3W Winner 1E vs 4W Plays Winner 2W vs 3E
FINALS DATE TBD BY TWO PARTICIPATING SCHOOLS
(Better seed gets to choose location for all playoff matches including finals)
[29] => (2 TEAMS TIED)
1. HEAD TO HEAD (MATCHES, THEN GAMES, THEN POINT DIFFERENTIAL).
2. IF TIED TEAMS DID NOT PLAY HEAD TO HEAD TO HEAD, THEN MOST TOTAL GAMES WON DURING SEASON (FORFEIT COUNTS AS 5 GAMES WON).
3. 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.)
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 POINT DIFFERENTIAL. IF # OF MATCHES PLAYED IS NOT EQUAL FIRST BREAKER IS HEAD TO HEAD WON LOSS PERCENTAGE IN MATCHES PLAYED BY ALL TIED TEAMS VS EACH OTHER, THEN IF NECESSARY TOTAL GAME WINNING PCT IN MATCHES BETWEEN 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.)
[tiebraker_rules] => (2 TEAMS TIED)
1. HEAD TO HEAD (MATCHES, THEN GAMES, THEN POINT DIFFERENTIAL).
2. IF TIED TEAMS DID NOT PLAY HEAD TO HEAD TO HEAD, THEN MOST TOTAL GAMES WON DURING SEASON (FORFEIT COUNTS AS 5 GAMES WON).
3. 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.)
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 POINT DIFFERENTIAL. IF # OF MATCHES PLAYED IS NOT EQUAL FIRST BREAKER IS HEAD TO HEAD WON LOSS PERCENTAGE IN MATCHES PLAYED BY ALL TIED TEAMS VS EACH OTHER, THEN IF NECESSARY TOTAL GAME WINNING PCT IN MATCHES BETWEEN 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.)
[30] =>
[playoff_matchups] =>
[31] =>
[nav_class] =>
[32] => 0
[uses_goals] => 0
[33] =>
[uses_goals_label] =>
[34] => 1
[uses_no_score] => 1
[35] => 1
[uses_notes_in_score] => 1
[36] => 0
[is_archived] => 0
[37] => 1
[skip_ticker] => 1
[38] => admin_standings_order
[playoff_standing_function] => admin_standings_order
[39] => 1
[show_playoffs_games] => 1
[40] => 1
[show_playoff_bracket] => 1
[41] => 2025-04-29
[roster_lock_date] => 2025-04-29
[42] => 0000-00-00
[roster_lock_date_show] => 0000-00-00
[43] => 2025-03-23
[first_of_season] => 2025-03-23
[44] => 2025-05-23
[last_of_season] => 2025-05-23
[45] => 2025-04-10
[schedule_lock_date] => 2025-04-10
[46] => 2025-03-31
[schedule_compare_date] => 2025-03-31
[47] => 8
[number_of_games] => 8
[48] => 1800.00
[league_cost] => 1800.00
[49] => Sp
[season_letter] => Sp
[50] => 3
[games_num_before_date] => 3
[51] => 2025-04-12
[games_date_before_date] => 2025-04-12
[52] => 1
[games_num_after_date] => 1
[53] => 2025-05-20
[games_date_after_date] => 2025-05-20
[54] => 1
[sched_compare_ran] => 1
[55] => 0
[show_in_admin] => 0
[56] => 0.00
[ref_default_amount] => 0.00
[57] => 0.00
[ref_default_amount_2] => 0.00
[58] => 0.00
[ref_default_amount_3] => 0.00
[59] => 0.00
[ref_default_amount_4] => 0.00
[60] => 0.00
[ref_default_amount_5] => 0.00
[61] => 8
[num_teams_playoffs] => 8
[62] => 0
[use_team_names] => 0
[63] =>
[mobile_bg_image] =>
[64] => 1
[uses_roster_ranking] => 1
[65] => 1
[uses_matchups] => 1
[66] =>
[matchup_rules] =>
[67] => 1
[matchup_rules_id] => 1
[68] => 0
[needs_jersey_number] => 0
[69] => 0
[uses_home_and_away] => 0
[70] => /images/champs/2024/g-tennis.JPG
[hero_image_desktop] => /images/champs/2024/g-tennis.JPG
[71] => /images/champs/2024/g-tennis.JPG
[hero_image_mobile] => /images/champs/2024/g-tennis.JPG
[72] => 1
[uses_ref_3] => 1
[73] => 0
[show_championship_banner] => 0
[74] =>
[championship_watch_url] =>
[75] => 5
[sport_id] => 5
[76] => Tennis
[sport_name] => Tennis
[77] => 50
[78] => images/icon-tennis.png
[sport_icon] => images/icon-tennis.png
[79] => hbg-tennis
[home_background_id] => hbg-tennis
[80] => fa fa-trophy bg-red-dark
[sport_icon_mobile_nav] => fa fa-trophy bg-red-dark
[81] => /images/pictures/tennis.jpg
[sport_bg_image] => /images/pictures/tennis.jpg
[82] => /assets/images/icons/tennis.png
[sport_icon_newsite] => /assets/images/icons/tennis.png
)
SELECT G.GameID, GameDate, GameTime , G.HomeTeamID, G.AwayTeamID,
Home.TeamName as Home, Away.TeamName as Away, Complete, G.HomeTeamResult,
G.AwayTeamResult, G.HomeTeamScore, G.AwayTeamScore, Description, G.AMorPM,
SH.school_name as HomeSchool , SA.school_name as AwaySchool, gym_text,
Home.short_name as HShort, Away.short_name as AShort, L.short_name, Gyms.gym_name,
CASE
WHEN AMorPM = 'PM' and GameTime < 12000 and GameTime not in ('0','1','2','3','4','5')
THEN GameTime +120005
WHEN GameTime in ('0','1','2','3','4','5') THEN 235555
ELSE GameTime +5
END as 'NEWTIME', Gyms.add_1, Gyms.cross_st, Gyms.city, Gyms.state, Gyms.zip, G.gym_number,
Home.icon as Hicon, Away.icon as Aicon, SH.icon as SHicon, SA.icon as SAicon,
CASE
WHEN GameDate = 0
THEN '2099-12-29'
ELSE GameDate END as NewDate,
L.uses_matchups, L.matchup_rules_id, G.watch_link_url, Home.team_video_url,
L.full_league_name, S.sport_icon_newsite, L.uses_fields, L.uses_feilds_text
From Games G
Left Join Teams Home on Home.TeamID = HomeTeamID
Left Join Teams Away on Away.TeamID = AwayTeamID
Left Join Schools SH on SH.school_id = Home.school_id_fk
Left Join Schools SA on SA.school_id = Away.school_id_fk
LEFT JOIN Leagues L on L.LeagueID = G.LeagueID
LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk
LEFT JOIN Sports S on S.sport_id = L.sport_id_fk
Where G.is_deleted = 0
AND Complete = 0 AND L.league_is_live = 1 AND L.LeagueID = 264
AND nullif(HomeTeamID,0) is not null AND nullif(AwayTeamID,0) is not null
AND G.GameTypeID in (1,2,3,4,5,6,7,8,9,10,11)
ORDER BY NewDate, HomeSchool ASC, NEWTIME ASC, GameTime ASC
LIMIT 3
