Rabbi I Poleyeff Girls League Home

Array ( [0] => 268 [LeagueID] => 268 [1] => 21 [at_league_id_fk] => 21 [2] => 6 [sport_id_fk] => 6 [3] => Rabbi I Poleyeff Girls [LeagueName] => Rabbi I Poleyeff Girls [4] => Rabbi I Poleyeff Girls Softball [full_league_name] => Rabbi I Poleyeff Girls Softball [5] => G-Sball [short_league_name] => G-Sball [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] => 20 [sort_order] => 60 [13] => girls-softball [short_name] => girls-softball [14] => [short_display_name] => [15] => [rules] => [16] => softball_girls_2016.pdf [rules_pdf] => softball_girls_2016.pdf [17] => [image] => [18] => [image_title] => [19] => 0 [use_otl] => 0 [20] => 1 [use_ties] => 1 [21] => 0 [uses_points] => 0 [22] => 1 [uses_win_per] => 1 [23] => 0 [uses_text_score] => 0 [24] => 0 [show_playoffs] => 0 [25] => 0 [show_second_standings] => 0 [26] => 1 [uses_fields] => 1 [27] => 0 [uses_feilds_text] => 0 [28] => TOP 4 TEAMS IN EACH DIVISION QUALIFY Quarters: 1 vs 4, 2 vs 3 Cross Division. Semis: Follow brackets No Reseeding! GAMES HOSTED BY HIGHER REMAINING SEED, INCLUDING CHAMPIONSHIP GAME. [playoff_rules] => TOP 4 TEAMS IN EACH DIVISION QUALIFY Quarters: 1 vs 4, 2 vs 3 Cross Division. Semis: Follow brackets No Reseeding! GAMES HOSTED BY HIGHER REMAINING SEED, INCLUDING CHAMPIONSHIP GAME. [29] => (2 TEAMS TIED) 1. HEAD TO HEAD (If head to head record is tied, then best margin of victory in head to head games to a maximum margin of 5 runs per game wins this tiebreaker.) 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 TEAMS UNDEFEATED, THAN MOST WINS VS PLAYOFF TEAMS) 5. COIN TOSS FOR SEEDING (IF TIE IS FOR LAST PLAYOFF SPOT, RUN DIFFERENTIAL IN HEAD TO HEAD GAMES BETWEEN THE TWO TIED TEAMS VYING FOR THE FINAL PLAYOFF SPOT WILL BE THE FINAL TIEBREAKER INSTEAD OF A COIN TOSS. ALL MERCIES COUNT AS A 10 RUN DIFFERENTIAL). (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, AND EVEN IF SOME TEAMS INVOLVED IN THE TIE DID NOT PLAY HEAD TO HEAD AT ALL.) (If 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 5 runs per game. For this tiebreaker, 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.) 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 (If head to head record is tied, then best margin of victory in head to head games to a maximum margin of 5 runs per game wins this tiebreaker.) 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 TEAMS UNDEFEATED, THAN MOST WINS VS PLAYOFF TEAMS) 5. COIN TOSS FOR SEEDING (IF TIE IS FOR LAST PLAYOFF SPOT, RUN DIFFERENTIAL IN HEAD TO HEAD GAMES BETWEEN THE TWO TIED TEAMS VYING FOR THE FINAL PLAYOFF SPOT WILL BE THE FINAL TIEBREAKER INSTEAD OF A COIN TOSS. ALL MERCIES COUNT AS A 10 RUN DIFFERENTIAL). (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, AND EVEN IF SOME TEAMS INVOLVED IN THE TIE DID NOT PLAY HEAD TO HEAD AT ALL.) (If 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 5 runs per game. For this tiebreaker, 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.) 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] => too_long [nav_class] => too_long [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] => 2025-04-30 [roster_lock_date] => 2025-04-30 [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-03-31 [schedule_lock_date] => 2025-03-31 [46] => 2025-03-27 [schedule_compare_date] => 2025-03-27 [47] => 8 [number_of_games] => 8 [48] => 1000.00 [league_cost] => 1000.00 [49] => [season_letter] => [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] => 90.00 [ref_default_amount] => 90.00 [57] => 90.00 [ref_default_amount_2] => 90.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] => http://myhsal.com/images/champs/2017/girls-softball.jpg [mobile_bg_image] => http://myhsal.com/images/champs/2017/girls-softball.jpg [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] => /images/champs/2024/g-softball.jpg [hero_image_desktop] => /images/champs/2024/g-softball.jpg [71] => /images/champs/2024/g-softball.jpg [hero_image_mobile] => /images/champs/2024/g-softball.jpg [72] => 1 [uses_ref_3] => 1 [73] => 0 [show_championship_banner] => 0 [74] => [championship_watch_url] => [75] => 6 [sport_id] => 6 [76] => Softball [sport_name] => Softball [77] => 60 [78] => images/icon-softball.png [sport_icon] => images/icon-softball.png [79] => hbg-softball [home_background_id] => hbg-softball [80] => ionicons ion-ios-baseball-outline bg-red-dark [sport_icon_mobile_nav] => ionicons ion-ios-baseball-outline bg-red-dark [81] => /images/pictures/softball.jpg [sport_bg_image] => /images/pictures/softball.jpg [82] => /assets/images/icons/softball1.png [sport_icon_newsite] => /assets/images/icons/softball1.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 = 268 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