Boys V Softball 2014-2015 Archive

Winner

main-playoff-winner-right-img
  • GAMES
  • STANDINGS
  • RULES
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, text_score, 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 , GT.GameType, G.GameTypeID 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 GameTypes GT on G.GameTypeID = GT.GameTypeID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Where G.LeagueID = 40 and G.is_deleted = 0 and G.GameTypeID in (2,4,5,6,7,8) AND nullif(HomeTeamID,0) is not null AND nullif(AwayTeamID,0) is not null ORDER BY GameTypeSort Desc, NewDate, HomeSchool ASC, NEWTIME ASC, GameTime ASC

Championship

Semis

Quarters

Playoff Setup

(Tiebreaking rules below)






Tiebreaker Rules

(2 TEAMS TIED) 1. HEAD TO HEAD 2. RECORD IN DIVISION (IF IN SAME DIVISION) 3. RECORD VS PLAYOFF TEAMS BY PCT (UNLESS BOTH TEAMS UNDEFEATED, THAN MOST WINS VS PLAYOFF TEAMS) 4.COIN TOSS FOR SEEDING PLAY-IN GAME FOR FINAL PLAYOFF SPOT (3 OR MORE TEAMS TIED) 1. HEAD TO HEAD (RECORD OF ALL TIED TEAMS IN HEAD TO HEAD EVEN IF # OF GMS PLAYED IS NOT EQUAL) 2. RECORD IN DIVISION (IF IN SAME DIVISION) 3. RECORD VS PLAYOFF TEAMS BY PCT (UNLESS BOTH TEAMS UNDEFEATED, THAN MOST WINS VS PLAYOFF TEAMS) 4. COIN TOSS/PLAY IN GAME ONCE TIE IS REDUCED TO 2 TEAMS, 2 TEAM TIEBREAKERS BETWEEN THOSE TEAMS, AS LISTED ABOVE PREVAIL.