Hockey 2027
Boys Varsity II League Home
Array
(
[0] => 292
[LeagueID] => 292
[1] => 0
[at_league_id_fk] => 0
[2] => 2
[sport_id_fk] => 2
[3] => Boys Varsity II
[LeagueName] => Boys Varsity II
[4] => Boys Varsity Hockey II
[full_league_name] => Boys Varsity Hockey II
[5] => B-V-Hockey-II
[short_league_name] => B-V-Hockey-II
[6] => 2027
[season_year] => 2027
[7] => 1
[gender_id_fk] => 1
[8] => 0
[registration_open] => 0
[9] => 1
[league_is_live] => 1
[10] => 0
[start_grade] => 0
[11] => 0
[end_grade] => 0
[12] => 95
[sort_order] => 20
[13] => hockey-boys-v-ii
[short_name] => hockey-boys-v-ii
[14] =>
[short_display_name] =>
[15] =>
[rules] =>
[16] => hockey-rules-11-20-2025.pdf
[rules_pdf] => hockey-rules-11-20-2025.pdf
[17] =>
[image] =>
[18] =>
[image_title] =>
[19] => 0
[use_otl] => 0
[20] => 1
[use_ties] => 1
[21] => 1
[uses_points] => 1
[22] => 0
[uses_win_per] => 0
[23] => 0
[uses_text_score] => 0
[24] => 1
[show_playoffs] => 1
[25] => 0
[show_second_standings] => 0
[26] => 0
[uses_fields] => 0
[27] => 0
[uses_feilds_text] => 0
[28] =>
[playoff_rules] =>
[29] =>
[tiebraker_rules] =>
[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] => 0
[skip_ticker] => 0
[38] => admin_standings_order
[playoff_standing_function] => admin_standings_order
[39] => 0
[show_playoffs_games] => 0
[40] => 0
[show_playoff_bracket] => 0
[41] => 0000-00-00
[roster_lock_date] => 0000-00-00
[42] => 0000-00-00
[roster_lock_date_show] => 0000-00-00
[43] => 0000-00-00
[first_of_season] => 0000-00-00
[44] => 0000-00-00
[last_of_season] => 0000-00-00
[45] => 0000-00-00
[schedule_lock_date] => 0000-00-00
[46] => 0000-00-00
[schedule_compare_date] => 0000-00-00
[47] => 0
[number_of_games] => 0
[48] => 0.00
[league_cost] => 0.00
[49] =>
[season_letter] =>
[50] => 0
[games_num_before_date] => 0
[51] => 0000-00-00
[games_date_before_date] => 0000-00-00
[52] => 0
[games_num_after_date] => 0
[53] => 0000-00-00
[games_date_after_date] => 0000-00-00
[54] => 0
[sched_compare_ran] => 0
[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] => 0
[num_teams_playoffs] => 0
[62] => 0
[use_team_names] => 0
[63] =>
[mobile_bg_image] =>
[64] => 0
[uses_roster_ranking] => 0
[65] => 0
[uses_matchups] => 0
[66] =>
[matchup_rules] =>
[67] => 0
[matchup_rules_id] => 0
[68] => 1
[needs_jersey_number] => 1
[69] => 1
[uses_home_and_away] => 1
[70] =>
[hero_image_desktop] =>
[71] =>
[hero_image_mobile] =>
[72] => 0
[uses_ref_3] => 0
[73] => 0
[show_championship_banner] => 0
[74] =>
[championship_watch_url] =>
[75] => 2
[sport_id] => 2
[76] => Hockey
[sport_name] => Hockey
[77] => 20
[78] => images/icon-hockey.png
[sport_icon] => images/icon-hockey.png
[79] => hbg-hockey
[home_background_id] => hbg-hockey
[80] => fa fa-circle bg-red-dark
[sport_icon_mobile_nav] => fa fa-circle bg-red-dark
[81] => /images/pictures/hockey.jpg
[sport_bg_image] => /images/pictures/hockey.jpg
[82] => /assets/images/icons/hockey.png
[sport_icon_newsite] => /assets/images/icons/hockey.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 = 292
AND nullif(HomeTeamID,0) is not null AND nullif(AwayTeamID,0) is not null
AND G.GameTypeID in (1)
ORDER BY NewDate, HomeSchool ASC, NEWTIME ASC, GameTime ASC
LIMIT 3