Time: 0.17819094657898 secs

Memory Usage: 1,851,336 bytes - 1.77M / 128M PHP 8.4.23

Redis Gets: 205

Redis Sets: 0

Total Queries: 44

select L.*,C.Unique_Id, C.Last_Name, C.First_Name, C.Email, C.Email_2, C.Phone, C.Mobile_Phone, C.Logo_URL as Commish_Logo_URL,PL.Entry_Fee, PL.No_Prize, PL.Total_Teams, PL.Private, PL.Slow_Draft, PL.Draft_Date from Commissioner as C,League as L left outer join Pay_Leagues as PL on (PL.League_Id = L.League_Id) where L.League_Id = C.League_Id and L.League_Id=555599 ==> size: 366
select * from Group_Definition gd, Group_Member gm where gd.Group_Id = gm.Group_Id and gd.League_Id = 555599 and gd.Group_Type=0 order by gd.Sorder ==> size: 147
select * from Baseball_Timeline where start_date <= NOW() and NOW() < end_date and year = 2026 ==> size: 94
select * from Player_Eligibility_Rules where Game_Id = 4650 ==> size: 59
select * FROM Team where League_Id = 555599 order by Name ==> size: 57
select * from Baseball_Timeline where Year=2026 order by Week asc ==> size: 65
select * from Deadlines where League_Id = 555599 ==> size: 48
select * from Baseball_Game_Schedule where Start_Time > '2026-04-30' and Start_Time < '2026-05-04' and (Competition_Type = 'Regular Season') order by Start_Time asc ==> size: 164
select * from Eligibility_Status where Game_Id=4650 ==> size: 51
update Eligibility_Status set Status = 1 where Game_Id=4650 ==> size: 59
select * from Player_Eligibility_Rules where Game_Id = 4650 ==> size: 59
select * from Position_Activity as PA where Position_Id in (202,203,204,205,206,207,208,209,210,216) and Year=2026 and Games_Played>=10 and PA.Player_Id not in (select Player_Id from Eligible_Players where Game_Id=4650 and Position_Id=PA.Position_Id and Player_Id=PA.Player_Id and Reason=1) ==> size: 290
select * from Position_Activity as PA where Position_Id = 213 and Year=2026 and Games_Played>=1 and PA.Player_Id not in (select Player_Id from Eligible_Players where Game_Id=4650 and Position_Id=PA.Position_Id and Player_Id=PA.Player_Id and Reason=1) ==> size: 250
select * from Position_Activity as PA where Position_Id = 214 and Year=2026 and Games_Played>=1 and PA.Player_Id not in (select Player_Id from Eligible_Players where Game_Id=4650 and Position_Id=PA.Position_Id and Player_Id=PA.Player_Id and Reason=1) ==> size: 250
select * from Baseball_Player_View as BPV where BPV.Deleted = 0 and BPV.Make_Eligible = 1 and BPV.Primary_Position in (202,203,204,205,206,207,208,209,210,216) and BPV.Player_Id not in (select distinct Baseball_Player_View.Player_Id from Baseball_Player_View left outer join Position_Activity on (Baseball_Player_View.Player_Id = Position_Activity.Player_Id) where Baseball_Player_View.Deleted=0 and Baseball_Player_View.Make_Eligible=1 and Position_Activity.Position_Id in (202,203,204,205,206,207,208,209,210,216) and Position_Activity.Games_Played >=10 and Position_Activity.Year=2025) and BPV.Player_Id not in (select Player_Id from Eligible_Players where Game_Id=4650 and Position_Id=BPV.Primary_Position and Player_Id=BPV.Player_Id) ==> size: 738
select * from Baseball_Player_View as BPV where BPV.Deleted = 0 and BPV.Make_Eligible = 1 and BPV.Primary_Position = 213 and BPV.Player_Id not in (select distinct Baseball_Player_View.Player_Id from Baseball_Player_View left outer join Position_Activity on (Baseball_Player_View.Player_Id = Position_Activity.Player_Id) where Baseball_Player_View.Deleted=0 and Baseball_Player_View.Make_Eligible=1 and Position_Activity.Position_Id = 213 and Position_Activity.Games_Played >=1 and Position_Activity.Year=2025) and BPV.Player_Id not in (select Player_Id from Eligible_Players where Game_Id=4650 and Position_Id in (213,214,212) and Player_Id=BPV.Player_Id) ==> size: 655
select * from Baseball_Player_View as BPV where BPV.Deleted = 0 and BPV.Make_Eligible = 1 and BPV.Primary_Position = 214 and BPV.Player_Id not in (select distinct Baseball_Player_View.Player_Id from Baseball_Player_View left outer join Position_Activity on (Baseball_Player_View.Player_Id = Position_Activity.Player_Id) where Baseball_Player_View.Deleted=0 and Baseball_Player_View.Make_Eligible=1 and Position_Activity.Position_Id = 214 and Position_Activity.Games_Played >=10 and Position_Activity.Year=2025) and BPV.Player_Id not in (select Player_Id from Eligible_Players where Game_Id=4650 and Position_Id in (213,214,212) and Player_Id=BPV.Player_Id) ==> size: 656
update Eligibility_Status set Status = 0, Last_Update=NOW() where Game_Id=4650 ==> size: 78
select * from League_Stats where League_Id=555599 ==> size: 49
update League_Stats set Status = 1 where League_Id=555599 ==> size: 57
select Game_Id,Start_Time,Last_Update from Baseball_Game_Schedule where Year=2026 and Start_Time > '2026-04-13 00:00:00' and Start_Time < '2026-04-19 23:59:59' and (Competition_Type='Regular Season') and Competition_Status<>'scheduled' and Competition_Status<>'postponed' order by Last_Update desc ==> size: 297
select Game_Id,Start_Time,Last_Update from Baseball_Game_Schedule where Year=2026 and Start_Time > '2026-04-20 00:00:00' and Start_Time < '2026-04-29 23:59:59' and (Competition_Type='Regular Season') and Competition_Status<>'scheduled' and Competition_Status<>'postponed' order by Last_Update desc ==> size: 297
select Game_Id,Start_Time,Last_Update from Baseball_Game_Schedule where Year=2026 and Start_Time > '2026-04-30 00:00:00' and Start_Time < '2026-05-03 23:59:59' and (Competition_Type='Regular Season') and Competition_Status<>'scheduled' and Competition_Status<>'postponed' order by Last_Update desc ==> size: 297
update League_Stats set Status=0,Last_Checked=NOW() where League_Id=555599 and Status=1 ==> size: 87
select * from League_Design where League_Id = 555599 ==> size: 52
select * from Message_Board where League_Id=555599 and Year=2026 and Group_Id=0 and Sticky=1 and Hidden=0 and Recipient=-1 order by Comment_Time desc ==> size: 149
select * from Message_Board where League_Id=555599 and Sticky=0 and Hidden=0 order by Comment_Time desc limit 50 ==> size: 112
select * from Transaction_Log, Player where Transaction_Log.Player_Id = Player.Player_Id and Transaction_Log.League_Id = 555599 order by Transaction_Time desc limit 5 ==> size: 167
select * FROM Trades WHERE League_Id=555599 and Trade_Status in (0,4,7,10,2) and Fantasy_Week >= 5 and Official = 1 order by Trade_Time desc limit 3 ==> size: 149
select * from Baseball_Game_Schedule where Start_Time > '2026-04-30' and Start_Time < '2026-05-04' and (Competition_Type = 'Regular Season') order by Start_Time asc ==> size: 164
select * from Team_Cumulative_Scoring_Stats where League_Id = 555599 and Year=2026 ==> size: 83
select * from Baseball_Game_Schedule where Start_Time > '2026-04-30' and Start_Time < '2026-05-04' and (Competition_Type = 'Regular Season') order by Start_Time asc ==> size: 164
SELECT * FROM Team_Roster,Player,Baseball_Player WHERE Team_Roster.Player_Id = Player.Player_Id AND Player.Player_Id = Baseball_Player.Player_Id AND Team_Roster.League_Id=555599 AND Team_Roster.Team_Id=4983585 AND Team_Roster.Fantasy_Week=6 AND Team_Roster.Period=1 ORDER BY Last_Name ==> size: 284
select Player_Id,coalesce(sum(Games_Played),0) as Games_Played,coalesce(sum(Games_Started),0) as Games_Started,coalesce(sum(Fielding_Errors),0) as Fielding_Errors,coalesce(sum(Passed_Balls),0) as Passed_Balls,coalesce(sum(Outfield_Assists),0) as Outfield_Assists,coalesce(sum(At_Bats),0) as At_Bats,coalesce(sum(Runs),0) as Runs,coalesce(sum(Hits),0) as Hits,coalesce(sum(Doubles),0) as Doubles,coalesce(sum(Triples),0) as Triples,coalesce(sum(Home_Runs),0) as Home_Runs,coalesce(sum(Total_Bases),0) as Total_Bases,coalesce(sum(RBI),0) as RBI,coalesce(sum(Walks),0) as Walks,coalesce(sum(Intentional_Walks),0) as Intentional_Walks,coalesce(sum(Strikeouts),0) as Strikeouts,coalesce(sum(Hit_By_Pitch),0) as Hit_By_Pitch,coalesce(sum(Stolen_Bases),0) as Stolen_Bases,coalesce(sum(Caught_Stealing),0) as Caught_Stealing,coalesce(sum(Catcher_Stealers_Allowed),0) as Catcher_Stealers_Allowed,coalesce(sum(Catcher_Stealers_Caught),0) as Catcher_Stealers_Caught,coalesce(sum(Sacrifice_Hits),0) as Sacrifice_Hits,coalesce(sum(Sacrifice_Flys),0) as Sacrifice_Flys,coalesce(sum(Grounded_Into_Double_Plays),0) as Grounded_Into_Double_Plays,coalesce(sum(Left_On_Base),0) as Left_On_Base,coalesce(sum(Two_Out_RBI),0) as Two_Out_RBI,coalesce(sum(RLISP_Two_Out),0) as RLISP_Two_Out,coalesce(sum(Pitcher_Games_Played),0) as Pitcher_Games_Played,coalesce(sum(Pitcher_Games_Started),0) as Pitcher_Games_Started,coalesce(sum(Wins),0) as Wins,coalesce(sum(Losses),0) as Losses,coalesce(sum(No_Decisions),0) as No_Decisions,coalesce(sum(Holds),0) as Holds,coalesce(sum(Saves),0) as Saves,coalesce(sum(Blown_Saves),0) as Blown_Saves,coalesce(sum(Complete_Games),0) as Complete_Games,coalesce(sum(Shutouts),0) as Shutouts,coalesce(sum(Quality_Starts),0) as Quality_Starts,coalesce(sum(Outs_Pitched),0) as Outs_Pitched,coalesce(sum(Pitcher_Hits),0) as Pitcher_Hits,coalesce(sum(Pitcher_Runs),0) as Pitcher_Runs,coalesce(sum(Pitcher_Earned_Runs),0) as Pitcher_Earned_Runs,coalesce(sum(Pitcher_Walks),0) as Pitcher_Walks,coalesce(sum(Pitcher_Strikeouts),0) as Pitcher_Strikeouts,coalesce(sum(Pitcher_Home_Runs),0) as Pitcher_Home_Runs,coalesce(sum(Pitcher_Stolen_Bases),0) as Pitcher_Stolen_Bases,coalesce(sum(Pitcher_Caught_Stealing),0) as Pitcher_Caught_Stealing,coalesce(sum(Pitcher_Intentional_Walks),0) as Pitcher_Intentional_Walks,coalesce(sum(Pitcher_Hit_By_Pitch),0) as Pitcher_Hit_By_Pitch,coalesce(sum(Pitcher_Sacrifice_Hits),0) as Pitcher_Sacrifice_Hits,coalesce(sum(Pitcher_Sacrifice_Flys),0) as Pitcher_Sacrifice_Flys,coalesce(sum(Pitches_Thrown),0) as Pitches_Thrown,coalesce(sum(Starting_Pitches_Thrown),0) as Starting_Pitches_Thrown,coalesce(sum(Wild_Pitches),0) as Wild_Pitches,coalesce(sum(Strikes_Thrown),0) as Strikes_Thrown,coalesce(sum(Ground_Ball_Outs),0) as Ground_Ball_Outs,coalesce(sum(Fly_Ball_Outs),0) as Fly_Ball_Outs,coalesce(sum(Batters_Faced),0) as Batters_Faced,coalesce(sum(Pickoffs),0) as Pickoffs,coalesce(sum(Inherited_Runners),0) as Inherited_Runners,coalesce(sum(Inherited_Runners_Scored),0) as Inherited_Runners_Scored,coalesce(sum(Balks),0) as Balks from Baseball_Game_Player_Stats where Player_Id in (2821,5058,4515,8098,5355,2835,4970,8479,7580) and Game_Id in (59415,58182,58289,58558,59143,59671,60440,58949,59125,60441,58056,59712,58711,58944,59757,60250,58367,58495,59680,60022,58864,59732,59531,58753,59681,59744,58123,59849,60352,59749,60336,60351,58376,59873,59518,58107,58298,59594,58058,60340,60355,59815,58302,59409,60116,60170,58157,58388,59933,59222,59998,58297,58418,58694,60322,58125) group by Player_Id ==> size: 3534
SELECT * FROM Team_Roster,Player,Baseball_Player WHERE Team_Roster.Player_Id = Player.Player_Id AND Player.Player_Id = Baseball_Player.Player_Id AND Team_Roster.League_Id=555599 AND Team_Roster.Team_Id=4983537 AND Team_Roster.Fantasy_Week=6 AND Team_Roster.Period=1 ORDER BY Last_Name ==> size: 284
select Player_Id,coalesce(sum(Games_Played),0) as Games_Played,coalesce(sum(Games_Started),0) as Games_Started,coalesce(sum(Fielding_Errors),0) as Fielding_Errors,coalesce(sum(Passed_Balls),0) as Passed_Balls,coalesce(sum(Outfield_Assists),0) as Outfield_Assists,coalesce(sum(At_Bats),0) as At_Bats,coalesce(sum(Runs),0) as Runs,coalesce(sum(Hits),0) as Hits,coalesce(sum(Doubles),0) as Doubles,coalesce(sum(Triples),0) as Triples,coalesce(sum(Home_Runs),0) as Home_Runs,coalesce(sum(Total_Bases),0) as Total_Bases,coalesce(sum(RBI),0) as RBI,coalesce(sum(Walks),0) as Walks,coalesce(sum(Intentional_Walks),0) as Intentional_Walks,coalesce(sum(Strikeouts),0) as Strikeouts,coalesce(sum(Hit_By_Pitch),0) as Hit_By_Pitch,coalesce(sum(Stolen_Bases),0) as Stolen_Bases,coalesce(sum(Caught_Stealing),0) as Caught_Stealing,coalesce(sum(Catcher_Stealers_Allowed),0) as Catcher_Stealers_Allowed,coalesce(sum(Catcher_Stealers_Caught),0) as Catcher_Stealers_Caught,coalesce(sum(Sacrifice_Hits),0) as Sacrifice_Hits,coalesce(sum(Sacrifice_Flys),0) as Sacrifice_Flys,coalesce(sum(Grounded_Into_Double_Plays),0) as Grounded_Into_Double_Plays,coalesce(sum(Left_On_Base),0) as Left_On_Base,coalesce(sum(Two_Out_RBI),0) as Two_Out_RBI,coalesce(sum(RLISP_Two_Out),0) as RLISP_Two_Out,coalesce(sum(Pitcher_Games_Played),0) as Pitcher_Games_Played,coalesce(sum(Pitcher_Games_Started),0) as Pitcher_Games_Started,coalesce(sum(Wins),0) as Wins,coalesce(sum(Losses),0) as Losses,coalesce(sum(No_Decisions),0) as No_Decisions,coalesce(sum(Holds),0) as Holds,coalesce(sum(Saves),0) as Saves,coalesce(sum(Blown_Saves),0) as Blown_Saves,coalesce(sum(Complete_Games),0) as Complete_Games,coalesce(sum(Shutouts),0) as Shutouts,coalesce(sum(Quality_Starts),0) as Quality_Starts,coalesce(sum(Outs_Pitched),0) as Outs_Pitched,coalesce(sum(Pitcher_Hits),0) as Pitcher_Hits,coalesce(sum(Pitcher_Runs),0) as Pitcher_Runs,coalesce(sum(Pitcher_Earned_Runs),0) as Pitcher_Earned_Runs,coalesce(sum(Pitcher_Walks),0) as Pitcher_Walks,coalesce(sum(Pitcher_Strikeouts),0) as Pitcher_Strikeouts,coalesce(sum(Pitcher_Home_Runs),0) as Pitcher_Home_Runs,coalesce(sum(Pitcher_Stolen_Bases),0) as Pitcher_Stolen_Bases,coalesce(sum(Pitcher_Caught_Stealing),0) as Pitcher_Caught_Stealing,coalesce(sum(Pitcher_Intentional_Walks),0) as Pitcher_Intentional_Walks,coalesce(sum(Pitcher_Hit_By_Pitch),0) as Pitcher_Hit_By_Pitch,coalesce(sum(Pitcher_Sacrifice_Hits),0) as Pitcher_Sacrifice_Hits,coalesce(sum(Pitcher_Sacrifice_Flys),0) as Pitcher_Sacrifice_Flys,coalesce(sum(Pitches_Thrown),0) as Pitches_Thrown,coalesce(sum(Starting_Pitches_Thrown),0) as Starting_Pitches_Thrown,coalesce(sum(Wild_Pitches),0) as Wild_Pitches,coalesce(sum(Strikes_Thrown),0) as Strikes_Thrown,coalesce(sum(Ground_Ball_Outs),0) as Ground_Ball_Outs,coalesce(sum(Fly_Ball_Outs),0) as Fly_Ball_Outs,coalesce(sum(Batters_Faced),0) as Batters_Faced,coalesce(sum(Pickoffs),0) as Pickoffs,coalesce(sum(Inherited_Runners),0) as Inherited_Runners,coalesce(sum(Inherited_Runners_Scored),0) as Inherited_Runners_Scored,coalesce(sum(Balks),0) as Balks from Baseball_Game_Player_Stats where Player_Id in (8862,9534,8591,8228,9457,8337,5929,3908,6608) and Game_Id in (59415,58182,58289,58558,59143,59671,60440,58949,59125,60441,58056,59712,58711,58944,59757,60250,58367,58495,59680,60022,58864,59732,59531,58753,59681,59744,58123,59849,60352,59749,60336,60351,58376,59873,59518,58107,58298,59594,58058,60340,60355,59815,58302,59409,60116,60170,58157,58388,59933,59222,59998,58297,58418,58694,60322,58125) group by Player_Id ==> size: 3534
SELECT * FROM Team_Roster,Player,Baseball_Player WHERE Team_Roster.Player_Id = Player.Player_Id AND Player.Player_Id = Baseball_Player.Player_Id AND Team_Roster.League_Id=555599 AND Team_Roster.Team_Id=4983605 AND Team_Roster.Fantasy_Week=6 AND Team_Roster.Period=1 ORDER BY Last_Name ==> size: 284
select Player_Id,coalesce(sum(Games_Played),0) as Games_Played,coalesce(sum(Games_Started),0) as Games_Started,coalesce(sum(Fielding_Errors),0) as Fielding_Errors,coalesce(sum(Passed_Balls),0) as Passed_Balls,coalesce(sum(Outfield_Assists),0) as Outfield_Assists,coalesce(sum(At_Bats),0) as At_Bats,coalesce(sum(Runs),0) as Runs,coalesce(sum(Hits),0) as Hits,coalesce(sum(Doubles),0) as Doubles,coalesce(sum(Triples),0) as Triples,coalesce(sum(Home_Runs),0) as Home_Runs,coalesce(sum(Total_Bases),0) as Total_Bases,coalesce(sum(RBI),0) as RBI,coalesce(sum(Walks),0) as Walks,coalesce(sum(Intentional_Walks),0) as Intentional_Walks,coalesce(sum(Strikeouts),0) as Strikeouts,coalesce(sum(Hit_By_Pitch),0) as Hit_By_Pitch,coalesce(sum(Stolen_Bases),0) as Stolen_Bases,coalesce(sum(Caught_Stealing),0) as Caught_Stealing,coalesce(sum(Catcher_Stealers_Allowed),0) as Catcher_Stealers_Allowed,coalesce(sum(Catcher_Stealers_Caught),0) as Catcher_Stealers_Caught,coalesce(sum(Sacrifice_Hits),0) as Sacrifice_Hits,coalesce(sum(Sacrifice_Flys),0) as Sacrifice_Flys,coalesce(sum(Grounded_Into_Double_Plays),0) as Grounded_Into_Double_Plays,coalesce(sum(Left_On_Base),0) as Left_On_Base,coalesce(sum(Two_Out_RBI),0) as Two_Out_RBI,coalesce(sum(RLISP_Two_Out),0) as RLISP_Two_Out,coalesce(sum(Pitcher_Games_Played),0) as Pitcher_Games_Played,coalesce(sum(Pitcher_Games_Started),0) as Pitcher_Games_Started,coalesce(sum(Wins),0) as Wins,coalesce(sum(Losses),0) as Losses,coalesce(sum(No_Decisions),0) as No_Decisions,coalesce(sum(Holds),0) as Holds,coalesce(sum(Saves),0) as Saves,coalesce(sum(Blown_Saves),0) as Blown_Saves,coalesce(sum(Complete_Games),0) as Complete_Games,coalesce(sum(Shutouts),0) as Shutouts,coalesce(sum(Quality_Starts),0) as Quality_Starts,coalesce(sum(Outs_Pitched),0) as Outs_Pitched,coalesce(sum(Pitcher_Hits),0) as Pitcher_Hits,coalesce(sum(Pitcher_Runs),0) as Pitcher_Runs,coalesce(sum(Pitcher_Earned_Runs),0) as Pitcher_Earned_Runs,coalesce(sum(Pitcher_Walks),0) as Pitcher_Walks,coalesce(sum(Pitcher_Strikeouts),0) as Pitcher_Strikeouts,coalesce(sum(Pitcher_Home_Runs),0) as Pitcher_Home_Runs,coalesce(sum(Pitcher_Stolen_Bases),0) as Pitcher_Stolen_Bases,coalesce(sum(Pitcher_Caught_Stealing),0) as Pitcher_Caught_Stealing,coalesce(sum(Pitcher_Intentional_Walks),0) as Pitcher_Intentional_Walks,coalesce(sum(Pitcher_Hit_By_Pitch),0) as Pitcher_Hit_By_Pitch,coalesce(sum(Pitcher_Sacrifice_Hits),0) as Pitcher_Sacrifice_Hits,coalesce(sum(Pitcher_Sacrifice_Flys),0) as Pitcher_Sacrifice_Flys,coalesce(sum(Pitches_Thrown),0) as Pitches_Thrown,coalesce(sum(Starting_Pitches_Thrown),0) as Starting_Pitches_Thrown,coalesce(sum(Wild_Pitches),0) as Wild_Pitches,coalesce(sum(Strikes_Thrown),0) as Strikes_Thrown,coalesce(sum(Ground_Ball_Outs),0) as Ground_Ball_Outs,coalesce(sum(Fly_Ball_Outs),0) as Fly_Ball_Outs,coalesce(sum(Batters_Faced),0) as Batters_Faced,coalesce(sum(Pickoffs),0) as Pickoffs,coalesce(sum(Inherited_Runners),0) as Inherited_Runners,coalesce(sum(Inherited_Runners_Scored),0) as Inherited_Runners_Scored,coalesce(sum(Balks),0) as Balks from Baseball_Game_Player_Stats where Player_Id in (7376,7623,9483,8582,5886,9158,4165,8581,9434) and Game_Id in (59415,58182,58289,58558,59143,59671,60440,58949,59125,60441,58056,59712,58711,58944,59757,60250,58367,58495,59680,60022,58864,59732,59531,58753,59681,59744,58123,59849,60352,59749,60336,60351,58376,59873,59518,58107,58298,59594,58058,60340,60355,59815,58302,59409,60116,60170,58157,58388,59933,59222,59998,58297,58418,58694,60322,58125) group by Player_Id ==> size: 3534
SELECT * FROM Team_Roster,Player,Baseball_Player WHERE Team_Roster.Player_Id = Player.Player_Id AND Player.Player_Id = Baseball_Player.Player_Id AND Team_Roster.League_Id=555599 AND Team_Roster.Team_Id=4983602 AND Team_Roster.Fantasy_Week=6 AND Team_Roster.Period=1 ORDER BY Last_Name ==> size: 284
select Player_Id,coalesce(sum(Games_Played),0) as Games_Played,coalesce(sum(Games_Started),0) as Games_Started,coalesce(sum(Fielding_Errors),0) as Fielding_Errors,coalesce(sum(Passed_Balls),0) as Passed_Balls,coalesce(sum(Outfield_Assists),0) as Outfield_Assists,coalesce(sum(At_Bats),0) as At_Bats,coalesce(sum(Runs),0) as Runs,coalesce(sum(Hits),0) as Hits,coalesce(sum(Doubles),0) as Doubles,coalesce(sum(Triples),0) as Triples,coalesce(sum(Home_Runs),0) as Home_Runs,coalesce(sum(Total_Bases),0) as Total_Bases,coalesce(sum(RBI),0) as RBI,coalesce(sum(Walks),0) as Walks,coalesce(sum(Intentional_Walks),0) as Intentional_Walks,coalesce(sum(Strikeouts),0) as Strikeouts,coalesce(sum(Hit_By_Pitch),0) as Hit_By_Pitch,coalesce(sum(Stolen_Bases),0) as Stolen_Bases,coalesce(sum(Caught_Stealing),0) as Caught_Stealing,coalesce(sum(Catcher_Stealers_Allowed),0) as Catcher_Stealers_Allowed,coalesce(sum(Catcher_Stealers_Caught),0) as Catcher_Stealers_Caught,coalesce(sum(Sacrifice_Hits),0) as Sacrifice_Hits,coalesce(sum(Sacrifice_Flys),0) as Sacrifice_Flys,coalesce(sum(Grounded_Into_Double_Plays),0) as Grounded_Into_Double_Plays,coalesce(sum(Left_On_Base),0) as Left_On_Base,coalesce(sum(Two_Out_RBI),0) as Two_Out_RBI,coalesce(sum(RLISP_Two_Out),0) as RLISP_Two_Out,coalesce(sum(Pitcher_Games_Played),0) as Pitcher_Games_Played,coalesce(sum(Pitcher_Games_Started),0) as Pitcher_Games_Started,coalesce(sum(Wins),0) as Wins,coalesce(sum(Losses),0) as Losses,coalesce(sum(No_Decisions),0) as No_Decisions,coalesce(sum(Holds),0) as Holds,coalesce(sum(Saves),0) as Saves,coalesce(sum(Blown_Saves),0) as Blown_Saves,coalesce(sum(Complete_Games),0) as Complete_Games,coalesce(sum(Shutouts),0) as Shutouts,coalesce(sum(Quality_Starts),0) as Quality_Starts,coalesce(sum(Outs_Pitched),0) as Outs_Pitched,coalesce(sum(Pitcher_Hits),0) as Pitcher_Hits,coalesce(sum(Pitcher_Runs),0) as Pitcher_Runs,coalesce(sum(Pitcher_Earned_Runs),0) as Pitcher_Earned_Runs,coalesce(sum(Pitcher_Walks),0) as Pitcher_Walks,coalesce(sum(Pitcher_Strikeouts),0) as Pitcher_Strikeouts,coalesce(sum(Pitcher_Home_Runs),0) as Pitcher_Home_Runs,coalesce(sum(Pitcher_Stolen_Bases),0) as Pitcher_Stolen_Bases,coalesce(sum(Pitcher_Caught_Stealing),0) as Pitcher_Caught_Stealing,coalesce(sum(Pitcher_Intentional_Walks),0) as Pitcher_Intentional_Walks,coalesce(sum(Pitcher_Hit_By_Pitch),0) as Pitcher_Hit_By_Pitch,coalesce(sum(Pitcher_Sacrifice_Hits),0) as Pitcher_Sacrifice_Hits,coalesce(sum(Pitcher_Sacrifice_Flys),0) as Pitcher_Sacrifice_Flys,coalesce(sum(Pitches_Thrown),0) as Pitches_Thrown,coalesce(sum(Starting_Pitches_Thrown),0) as Starting_Pitches_Thrown,coalesce(sum(Wild_Pitches),0) as Wild_Pitches,coalesce(sum(Strikes_Thrown),0) as Strikes_Thrown,coalesce(sum(Ground_Ball_Outs),0) as Ground_Ball_Outs,coalesce(sum(Fly_Ball_Outs),0) as Fly_Ball_Outs,coalesce(sum(Batters_Faced),0) as Batters_Faced,coalesce(sum(Pickoffs),0) as Pickoffs,coalesce(sum(Inherited_Runners),0) as Inherited_Runners,coalesce(sum(Inherited_Runners_Scored),0) as Inherited_Runners_Scored,coalesce(sum(Balks),0) as Balks from Baseball_Game_Player_Stats where Player_Id in (5588,8175,8367,6927,9887,9439,8918,9220,7761) and Game_Id in (59415,58182,58289,58558,59143,59671,60440,58949,59125,60441,58056,59712,58711,58944,59757,60250,58367,58495,59680,60022,58864,59732,59531,58753,59681,59744,58123,59849,60352,59749,60336,60351,58376,59873,59518,58107,58298,59594,58058,60340,60355,59815,58302,59409,60116,60170,58157,58388,59933,59222,59998,58297,58418,58694,60322,58125) group by Player_Id ==> size: 3534
select * from Player_Notes where player_id > 0 and created > date_add(now(), interval -10 day) and headline = 1 and deleted=0 and published=1 order by created desc limit 20 ==> size: 173
select * from Metrics_Players where Week=6 and Player_Pool=0 and Acquired>0 order by Acquired desc limit 10 ==> size: 107
select * from Metrics_Players where Week=6 and Player_Pool=0 and Released>0 order by Released desc limit 10 ==> size: 107
select * from Baseball_Game_Schedule where Start_Time > '2026-08-19' and Start_Time < '2026-08-20' and (Competition_Type = 'Regular Season') order by Start_Time asc ==> size: 164