
1 x Application (96.51%) | 592ms |
1 x Booting (3.48%) | 21.37ms |
Backtrace |
|
select * from `teamsdb_leagues` where `league_key` = 'l.mlb.com' limit 1
Bindings |
|
Backtrace |
|
select `mlb_teams`.*, `mlb_standings`.`league`, `mlb_standings`.`division`, `mlb_teams`.`park` as `stadium`, `teams`.`team_key_xts`, `teams`.`nickname`, `teams`.`location_name` from `mlb_teams` left join `mlb_standings` on `mlb_standings`.`team_id` = `mlb_teams`.`team_id` left join `mlb_control_panel` on `mlb_control_panel`.`season_id_active` = `mlb_standings`.`season_id` left join `teams` on `teams`.`team_key_xts` = `mlb_teams`.`xts_id` where `xts_id` = 'l.mlb.com-t.10' limit 1
Bindings |
|
Backtrace |
|
select `mlb_standings`.`team_id`, `mlb_teams`.`xts_id`, CONCAT( w ,"-" , l , " * " ,rk_text , " in " , mlb_standings.league , " " , mlb_standings.division) AS oneline from `mlb_standings` inner join (SELECT MAX(mlb_standings.season_id) AS MaxOfseason_id, mlb_standings.team_id FROM mlb_standings
WHERE (((mlb_standings.gp)>0)) GROUP BY mlb_standings.team_id) AS latest_season on `mlb_standings`.`team_id` = `latest_season`.`team_id` and `mlb_standings`.`season_id` = `latest_season`.`MaxOfseason_id` inner join `mlb_teams` on `mlb_standings`.`team_id` = `mlb_teams`.`team_id` inner join `shared_rank` on `mlb_standings`.`division_ranking` = `shared_rank`.`rk_num` where `mlb_teams`.`active` <> 0 and `mlb_teams`.`xts_id` = 'l.mlb.com-t.10' limit 1
Bindings |
|
Backtrace |
|
select `mlb_control_panel`.`season_status`, `active_season`.`season_id` as `active_season`, `current_schedule`.`season_id` as `current_schedule`, MONTH(NOW()) AS current_month, YEAR(NOW()) AS current_year, (SELECT MAX(season_id) FROM mlb_seasons WHERE schedule_available <> 0) AS lastSeason, IF( mlb_control_panel.season_status = 'OS' AND (SELECT MAX(season_id) FROM mlb_seasons WHERE schedule_available <> 0)=mlb_control_panel.season_id_active, 0, 1) AS is_new_schedule_available from `mlb_control_panel` inner join `mlb_seasons` as `active_season` on `active_season`.`season_id` = `mlb_control_panel`.`season_id_active` inner join `mlb_seasons` as `current_schedule` on `current_schedule`.`season_id` = `mlb_control_panel`.`season_id_current_schedule` limit 1
Backtrace |
|
select CONCAT(mlb_teams.xts_id, '/', REPLACE(mlb_teams.city_team_name, ' ', '_')) AS value, mlb_teams.city_team_name AS label from `mlb_teams` inner join `mlb_standings` on `mlb_standings`.`team_id` = `mlb_teams`.`team_id` inner join `mlb_control_panel` on `mlb_control_panel`.`season_id_current_schedule` = `mlb_standings`.`season_id` where `mlb_teams`.`active` != 0 and `mlb_teams`.`city_team_name` is not null group by `mlb_teams`.`team_code` order by `mlb_teams`.`city_career_stats` asc
Bindings |
|
Backtrace |
|
select
MONTH(mlb_schedule.date) AS `month`,
YEAR(mlb_schedule.date) AS `year`,
CONCAT(YEAR(mlb_schedule.date),'_',MONTH(mlb_schedule.date)) AS value,
CONCAT(DATE_FORMAT(mlb_schedule.date, '%M'),' ', YEAR(mlb_schedule.date)) AS label
from `mlb_schedule` inner join `mlb_control_panel` on `mlb_control_panel`.`season_id_current_schedule` = `mlb_schedule`.`season_id` where `mlb_schedule`.`season_mode_id` in (1, 2) group by `year`, `month` order by `mlb_schedule`.`date` asc
Bindings |
|
Backtrace |
|
select `season_desc4` as `value`, `season_desc4` as `label` from `mlb_seasons` where `schedule_available` <> 0 order by `season_id` desc
Bindings |
|
Backtrace |
|
SELECT
mlb_schedule.date,
CONCAT( DAYNAME(mlb_schedule.date), ', ', LEFT(MONTHNAME(mlb_schedule.date), 3), '. ', DAY(mlb_schedule.date) ) AS formatted_date,
mlb_schedule.time,
mlb_schedule.away_score,
mlb_schedule.home_score,
shared_game_status.game_status_desc_feed AS event_status,
mlb_schedule.time_certainty,
mlb_schedule.season_mode_id,
CONCAT('l.mlb.com-e.',mlb_schedule.season_id, LPAD(mlb_schedule.game_id,4,'0')) AS event_key,
CONCAT('/mlb/boxscore/', CONCAT('l.mlb.com-e.',mlb_schedule.season_id, LPAD(mlb_schedule.game_id,4,'0'))) AS boxscore_link,
mlb_schedule.game_status_id,
CONCAT(UCASE(LEFT(mlb_schedule.game_status_desc_short, 1)), SUBSTRING(mlb_schedule.game_status_desc_short, 2)) AS game_status_desc_short,
mlb_schedule.periods,
IF(mlb_teams_2.team_code=home,mlb_team_stats_1.season_game_number,mlb_team_stats.season_game_number) AS season_game_number,
CONCAT('https://cdn.xmlteam.com/gamesv5/logos/l.mlb.com/official/',mlb_teams.xts_id,'.png') AS away_team_logo,
CONCAT('/mlb/team/', mlb_teams.xts_id,'/',REPLACE(mlb_teams.city_team_name, ' ', '_')) AS away_team_link,
mlb_teams.xts_id AS away_xts_id,
mlb_teams.city_team_name AS away_city_team_name,
REPLACE(mlb_teams.city_team_name,' ','_') AS away_city_team_name,
mlb_teams.team_name AS away_team_name,
mlb_teams.city_career_stats AS away,
mlb_teams.team_code_AP AS away_team_code,
mlb_team_stats.decision AS away_decision,
mlb_team_stats.current_streak AS away_streak,
CONCAT(IF(mlb_team_stats.decision='W','W ','L '),IF(mlb_schedule.away_score>mlb_schedule.home_score,CONCAT(mlb_schedule.away_score,'-',mlb_schedule.home_score),CONCAT(mlb_schedule.home_score,'-',mlb_schedule.away_score))/*,IF(ot_so IS NOT NULL,CONCAT('(',ot_so,')'),'')*/) AS away_results,
CONCAT(mlb_team_stats.ytd_win,'-',mlb_team_stats.ytd_loss) AS away_record,
CONCAT('https://cdn.xmlteam.com/gamesv5/logos/l.mlb.com/official/',mlb_teams_1.xts_id,'.png') AS home_team_logo,
CONCAT('/mlb/team/', mlb_teams_1.xts_id,'/',REPLACE(mlb_teams_1.city_team_name, ' ', '_')) AS home_team_link,
mlb_teams_1.xts_id AS home_xts_id,
mlb_teams_1.city_team_name AS home_city_team_name,
REPLACE(mlb_teams_1.city_team_name,' ','_') AS home_city_team_name,
mlb_teams_1.team_name AS home_team_name,
mlb_teams_1.city_career_stats AS home,
mlb_teams_1.team_name AS home_name,
mlb_teams_1.city AS home_city,
mlb_teams_1.team_code_AP AS home_team_code,
mlb_team_stats_1.decision AS home_decision,
mlb_team_stats_1.current_streak AS home_streak,
CONCAT(IF(mlb_team_stats_1.decision='W','W ','L '),IF(mlb_schedule.away_score>mlb_schedule.home_score,CONCAT(mlb_schedule.away_score,'-',mlb_schedule.home_score),CONCAT(mlb_schedule.home_score,'-',mlb_schedule.away_score))/*,IF(ot_so IS NOT NULL,CONCAT('(',ot_so,')'),'')*/) AS home_results,
CONCAT(mlb_team_stats_1.ytd_win,'-',mlb_team_stats_1.ytd_loss) AS home_record,
pitcher_data_win.w_pitcher,
pitcher_data_win.decision as w_pitcher_decision,
pitcher_data_win.label_name as w_pitcher_label_name,
pitcher_data_win.team_code as w_pitcher_team_code,
pitcher_data_win.stats as w_pitcher_stats,
CONCAT('/mlb/p/', pitcher_data_win.tsf_global_id,'/', pitcher_data_win.full_name) AS w_pitcher_player_link,
pitcher_data_lost.l_pitcher,
pitcher_data_lost.decision as l_pitcher_decision,
pitcher_data_lost.label_name as l_pitcher_label_name,
pitcher_data_lost.team_code as l_pitcher_team_code,
pitcher_data_lost.stats as l_pitcher_stats,
CONCAT('/mlb/p/', pitcher_data_lost.tsf_global_id,'/', pitcher_data_lost.full_name) AS l_pitcher_player_link,
pitcher_data_save.sv_pitcher,
pitcher_data_save.decision as sv_pitcher_decision,
pitcher_data_save.label_name as sv_pitcher_label_name,
pitcher_data_save.team_code as sv_pitcher_team_code,
pitcher_data_save.stats as sv_pitcher_stats,
CONCAT('/mlb/p/', pitcher_data_save.tsf_global_id,'/', pitcher_data_save.full_name) AS sv_pitcher_player_link,
CONCAT(away_decision_pitcher.first_name, ' ' ,away_decision_pitcher.last_name) AS away_decision_fullname,
away_decision_pitcher.tsf_global_id AS away_decision_tsf_global_id,
mlb_team_stats.pitcher_of_decision_record AS away_decision_record,
CONCAT(home_decision_pitcher.first_name, ' ' ,home_decision_pitcher.last_name) AS home_decision_fullname,
home_decision_pitcher.tsf_global_id AS home_decision_tsf_global_id,
mlb_team_stats_1.pitcher_of_decision_record AS home_decision_record,
IFNULL(CONCAT(away_save_pitcher.first_name, ' ' ,away_save_pitcher.last_name), '') AS away_save_fullname,
away_save_pitcher.tsf_global_id AS away_save_tsf_global_id,
IFNULL(mlb_team_stats.pitcher_save_record, '') AS away_save_record,
IFNULL(CONCAT(home_save_pitcher.first_name, ' ' ,home_save_pitcher.last_name), '') AS home_save_fullname,
home_save_pitcher.tsf_global_id AS home_save_tsf_global_id,
IFNULL(mlb_team_stats_1.pitcher_save_record, '') AS home_save_record
FROM mlb_teams AS mlb_teams_2, mlb_team_stats
INNER JOIN (mlb_team_stats AS mlb_team_stats_1
INNER JOIN (mlb_teams INNER JOIN (mlb_schedule INNER JOIN mlb_teams AS mlb_teams_1 ON mlb_schedule.home_team_id = mlb_teams_1.team_id)
ON mlb_teams.team_id = mlb_schedule.away_team_id) ON (mlb_schedule.season_id = mlb_team_stats_1.season_id)
AND (mlb_team_stats_1.game_id = mlb_schedule.game_id) AND (mlb_team_stats_1.team_id = mlb_teams_1.team_id)) ON (mlb_team_stats.game_id = mlb_schedule.game_id)
AND (mlb_team_stats.season_id = mlb_schedule.season_id) AND (mlb_team_stats.team_id = mlb_teams.team_id)
INNER JOIN shared_game_status ON mlb_schedule.game_status_id = shared_game_status.id
LEFT JOIN mlb_standings ON mlb_schedule.away_team_id = mlb_standings.team_id AND mlb_schedule.season_id=mlb_standings.season_id
LEFT JOIN mlb_standings AS mlb_standings_1 ON mlb_schedule.home_team_id=mlb_standings_1.team_id AND mlb_schedule.season_id=mlb_standings_1.season_id
LEFT JOIN mlb_players AS away_decision_pitcher ON away_decision_pitcher.player_id=mlb_team_stats.pitcher_of_decision_id
LEFT JOIN mlb_players AS home_decision_pitcher ON home_decision_pitcher.player_id=mlb_team_stats_1.pitcher_of_decision_id
LEFT JOIN mlb_players AS away_save_pitcher ON away_save_pitcher.player_id=mlb_team_stats.pitcher_save_id
LEFT JOIN mlb_players AS home_save_pitcher ON home_save_pitcher.player_id=mlb_team_stats_1.pitcher_save_id
LEFT JOIN
(
SELECT mlb_schedule.id AS schedule_id, mlb_schedule.season_id, mlb_schedule.game_id, mlb_schedule.Date,
mlb_teams.team_code_AP as team_code, mlb_teams.city_career_stats, mlb_teams.team_name AS away_team, mlb_teams.city AS away_city,
mlb_teams_1.team_name AS home_team, mlb_teams_1.city AS home_city, mlb_schedule.away_score, mlb_schedule.home_score,
mlb_schedule.game_status_desc_short, mlb_schedule.Game012, mlb_schedule.venue, mlb_schedule.live_clock,
mlb_schedule.live_clock_state, mlb_schedule.linescore, mlb_schedule.periods,
CONCAT(mlb_team_stats_1.ytd_win, '-' ,mlb_team_stats_1.ytd_loss) AS home_record,
CONCAT(mlb_team_stats.ytd_win, '-' ,mlb_team_stats.ytd_loss) AS away_record,
mlb_schedule.period_half, mlb_schedule.outs
FROM mlb_team_stats AS mlb_team_stats_1
INNER JOIN mlb_schedule ON mlb_team_stats_1.schedule_id = mlb_schedule.id
INNER JOIN mlb_teams ON mlb_schedule.away_team_id = mlb_teams.team_id
INNER JOIN mlb_teams AS mlb_teams_1 ON mlb_schedule.home_team_id = mlb_teams_1.team_id
INNER JOIN mlb_team_stats ON mlb_schedule.id = mlb_team_stats.schedule_id
WHERE mlb_schedule.season_id=2024 AND mlb_team_stats.home_away='a' AND mlb_team_stats_1.home_away='h'
) AS team_data ON team_data.schedule_id = mlb_schedule.id
LEFT JOIN
(
SELECT
mlb_stats.season_id,
mlb_stats.schedule_id,
mlb_players.tsf_global_id,
CONCAT(first_name, '_', last_name) AS full_name,
CONCAT(mlb_stats.decision,': ') AS decision,
CONCAT(LEFT(first_name, 1), '. ', last_name) AS label_name,
CONCAT('(', mlb_teams.team_code_AP, ')') AS team_code,
CONCAT(IFNULL(ytd_win, 0), '-', IFNULL(ytd_loss, 0), ', ', ROUND(IFNULL(ytd_era, 0),2)) AS stats,
CONCAT(decision,': ',LEFT(first_name,1) , '. ' , last_name , ' (' , mlb_teams.team_code_AP , ') ' , ytd_win , '-' , ytd_loss ,', ',ROUND(ytd_era,2)) AS w_pitcher
FROM mlb_stats
INNER JOIN mlb_players ON mlb_stats.player_id = mlb_players.player_id
INNER JOIN mlb_teams ON mlb_stats.team_id = mlb_teams.team_id
WHERE mlb_stats.season_id=2024 AND mlb_stats.decision LIKE '%W%'
) AS pitcher_data_win ON pitcher_data_win.schedule_id = mlb_schedule.id
LEFT JOIN
(
SELECT
mlb_stats.season_id,
mlb_stats.schedule_id,
mlb_players.tsf_global_id,
CONCAT(first_name, '_', last_name) AS full_name,
CONCAT(mlb_stats.decision,': ') AS decision,
CONCAT(LEFT(first_name, 1), '. ', last_name) AS label_name,
CONCAT('(', mlb_teams.team_code_AP, ')') AS team_code,
CONCAT(IFNULL(ytd_win, 0), '-', IFNULL(ytd_loss, 0), ', ', ROUND(IFNULL(ytd_era, 0),2)) AS stats,
CONCAT(decision,': ',LEFT(first_name,1) , '. ' , last_name , ' (' , mlb_teams.team_code_AP , ') ' , ytd_win , '-' , ytd_loss ,', ',ROUND(ytd_era,2)) AS l_pitcher
FROM mlb_stats
INNER JOIN mlb_players ON mlb_stats.player_id = mlb_players.player_id
INNER JOIN mlb_teams ON mlb_stats.team_id = mlb_teams.team_id
WHERE mlb_stats.season_id=2024 AND mlb_stats.decision LIKE '%L%'
) AS pitcher_data_lost ON pitcher_data_lost.schedule_id = mlb_schedule.id
LEFT JOIN
(
SELECT
mlb_stats.season_id,
mlb_stats.schedule_id,
mlb_players.tsf_global_id,
CONCAT(first_name, '_', last_name) AS full_name,
CONCAT(mlb_stats.decision,': ') AS decision,
CONCAT(LEFT(first_name, 1), '. ', last_name) AS label_name,
CONCAT('(', mlb_teams.team_code_AP, ')') AS team_code,
CONCAT(IFNULL(ytd_save, 0), ', ', ROUND(IFNULL(ytd_era, 0),2)) AS stats,
CONCAT(decision,': ',LEFT(first_name,1) , '. ' , last_name , ' (' , mlb_teams.team_code_AP , ') ' , ytd_save ,', ',ROUND(ytd_era,2)) AS sv_pitcher
FROM mlb_stats
INNER JOIN mlb_players ON mlb_stats.player_id = mlb_players.player_id
INNER JOIN mlb_teams ON mlb_stats.team_id = mlb_teams.team_id
WHERE mlb_stats.season_id=2024 AND mlb_stats.decision='Sv'
) AS pitcher_data_save ON pitcher_data_save.schedule_id = mlb_schedule.id
WHERE mlb_schedule.game_status_id in (2,5,10)
AND (mlb_teams_2.team_code=home OR mlb_teams_2.team_code=away)
AND mlb_schedule.season_mode_id in (1,2)
AND mlb_schedule.season_id=2024 AND (mlb_teams_2.xts_id='l.mlb.com-t.10' or mlb_teams_1.xts_id='l.mlb.com-t.10') GROUP BY mlb_schedule.id ORDER BY mlb_schedule.date ASC, mlb_schedule.time ASC
Backtrace |
|
SELECT
mlb_schedule.id,
mlb_schedule.season_id,
mlb_schedule.game_id,
mlb_schedule.season_mode_id,
mlb_schedule.date,
CONCAT( DAYNAME(mlb_schedule.date), ', ', LEFT(MONTHNAME(mlb_schedule.date), 3), '. ', DAY(mlb_schedule.date) ) AS formatted_date,
mlb_schedule.time,
TIME_FORMAT(TIME(CONVERT_TZ(CONCAT(mlb_schedule.date,' ',mlb_schedule.time), 'America/New_York', 'America/New_York')) , '%l:%i %p') AS formatted_time,
mlb_schedule.`Game012`,
mlb_schedule.periods,
mlb_schedule.forecasted_away_score as away_guessing_score,
mlb_schedule.forecasted_home_score as home_guessing_score,
mlb_schedule.time_certainty,
mlb_team_stats.decision AS away_decision,
mlb_team_stats_1.decision AS home_decision,
CONCAT(IF(mlb_team_stats.decision='W','W ','L '),IF(mlb_schedule.away_score>mlb_schedule.home_score,CONCAT(mlb_schedule.away_score,'-',mlb_schedule.home_score),CONCAT(mlb_schedule.home_score,'-',mlb_schedule.away_score))/*,IF(ot_so IS NOT NULL,CONCAT('(',ot_so,')'),'')*/) AS away_results,
CONCAT(IF(mlb_team_stats_1.decision='W','W ','L '),IF(mlb_schedule.away_score>mlb_schedule.home_score,CONCAT(mlb_schedule.away_score,'-',mlb_schedule.home_score),CONCAT(mlb_schedule.home_score,'-',mlb_schedule.away_score))/*,IF(ot_so IS NOT NULL,CONCAT('(',ot_so,')'),'')*/) AS home_results,
mlb_team_stats.current_streak AS away_streak,
mlb_team_stats_1.current_streak AS home_streak,
CONCAT(mlb_team_stats.ytd_win,'-',mlb_team_stats.ytd_loss) AS away_record,
CONCAT(mlb_team_stats_1.ytd_win,'-',mlb_team_stats_1.ytd_loss) AS home_record,
/*new*/
IF(mlb_teams_2.team_code=home,mlb_team_stats_1.season_game_number,mlb_team_stats.season_game_number) AS season_game_number,
/*new*/
mlb_teams.xts_id AS away_xts_id,
mlb_teams.city_team_name AS away_city_team_name,
mlb_teams.team_name AS away_team_name,
mlb_teams.city_career_stats AS away,
mlb_teams.team_code_AP AS away_team_code,
mlb_teams_1.xts_id AS home_xts_id,
mlb_teams_1.city_team_name AS home_city_team_name,
REPLACE(mlb_teams.city_team_name,' ','_') AS away_city_team_name,
REPLACE(mlb_teams_1.city_team_name,' ','_') AS home_city_team_name,
mlb_teams_1.team_name AS home_team_name,
mlb_teams_1.city_career_stats AS home,
mlb_teams_1.team_code_AP AS home_team_code,
CONCAT('l.mlb.com-e.',mlb_schedule.season_id, LPAD(mlb_schedule.game_id,4,'0')) AS event_key,
CONCAT('l.mlb.com-e.',mlb_schedule.season_id, LPAD(mlb_schedule.game_id,4,'0')) AS game_id,
CONCAT('-e.',mlb_schedule.season_id, LPAD(mlb_schedule.game_id,4,'0')) AS game_id_suffix,
CONCAT('/mlb/team/', mlb_teams.xts_id,'/',REPLACE(mlb_teams.city_team_name, ' ', '_')) AS away_team_link,
CONCAT('/mlb/team/', mlb_teams_1.xts_id,'/',REPLACE(mlb_teams_1.city_team_name, ' ', '_')) AS home_team_link,
CONCAT('https://cdn.xmlteam.com/gamesv5/logos/l.mlb.com/official/',mlb_teams.xts_id,'.png') AS away_team_logo,
CONCAT('https://cdn.xmlteam.com/gamesv5/logos/l.mlb.com/official/',mlb_teams_1.xts_id,'.png') AS home_team_logo,
shared_game_status.game_status_desc_feed AS event_status,
mlb_teams_1.team_name AS home_name,
mlb_teams_1.city AS home_city,
mlb_schedule.game_status_desc_short,
mlb_schedule.game_status_id,
mlb_schedule.away_score,
mlb_schedule.home_score,
mlb_team_stats.home_away,
mlb_team_stats_1.home_away,
mlb_schedule.period_half,
mlb_schedule.outs,
mlb_probable_pitchers.away_probable_player_id, mlb_probable_pitchers.away_confirmed,
CONCAT(away_pitcher_w_record.first_name, ' ' ,away_pitcher_w_record.last_name) AS away_probable_fullname,
away_pitcher_w_record.tsf_global_id AS away_probable_tsf_global_id,
away_pitcher_w_record.first_name AS away_probable_first_name,
away_pitcher_w_record.last_name AS away_probable_last_name,
CONCAT('/mlb/p/', away_pitcher_w_record.tsf_global_id,'/', away_pitcher_w_record.first_name, '_' ,away_pitcher_w_record.last_name) AS away_probable_player_link,
IF (mlb_schedule.season_mode_id =1, away_pitcher_w_record.rs_current_record,away_pitcher_w_record.po_current_record) AS away_pitcher_record_stats,
home_pitcher_w_record.tsf_global_id AS home_probable_tsf_global_id,
home_pitcher_w_record.first_name AS home_probable_first_name,
home_pitcher_w_record.last_name AS home_probable_last_name,
mlb_probable_pitchers.home_probable_player_id, mlb_probable_pitchers.home_confirmed,
CONCAT(home_pitcher_w_record.first_name, ' ' ,home_pitcher_w_record.last_name) AS home_probable_fullname,
CONCAT('/mlb/p/', home_pitcher_w_record.tsf_global_id,'/', home_pitcher_w_record.first_name, '_' ,home_pitcher_w_record.last_name) AS home_probable_player_link,
IF (mlb_schedule.season_mode_id =1, home_pitcher_w_record.rs_current_record,home_pitcher_w_record.po_current_record) AS home_pitcher_record_stats
/*new - replace the top part*/
FROM mlb_teams AS mlb_teams_2, mlb_team_stats
INNER JOIN (mlb_team_stats AS mlb_team_stats_1
INNER JOIN (mlb_teams INNER JOIN (mlb_schedule INNER JOIN mlb_teams AS mlb_teams_1 ON mlb_schedule.home_team_id = mlb_teams_1.team_id)
ON mlb_teams.team_id = mlb_schedule.away_team_id) ON (mlb_schedule.season_id = mlb_team_stats_1.season_id)
AND (mlb_team_stats_1.game_id = mlb_schedule.game_id) AND (mlb_team_stats_1.team_id = mlb_teams_1.team_id)) ON (mlb_team_stats.game_id = mlb_schedule.game_id)
AND (mlb_team_stats.season_id = mlb_schedule.season_id) AND (mlb_team_stats.team_id = mlb_teams.team_id)
INNER JOIN shared_game_status ON mlb_schedule.game_status_id = shared_game_status.id
LEFT JOIN mlb_probable_pitchers ON mlb_schedule.id = mlb_probable_pitchers.schedule_id
LEFT JOIN
(
SELECT
mlb_players.player_id,
mlb_players.tsf_global_id,
mlb_players.first_name,
mlb_players.last_name,
mlb_teams.team_code_AP as team_code,
CONCAT (current_record_rs.W,'-', current_record_rs.L,', ', current_record_rs.ERA) AS rs_current_record,
CONCAT (current_record_po.win,'-', current_record_po.loss,', ', current_record_po.ERA) AS po_current_record
FROM mlb_players
INNER JOIN mlb_teams
ON mlb_players.team_id = mlb_teams.team_id
LEFT JOIN
(
SELECT mlb_career_stats_pitchers.line_desc, mlb_career_stats_pitchers.date_sort, mlb_career_stats_pitchers.player_id,
mlb_career_stats_pitchers.W, mlb_career_stats_pitchers.L, mlb_career_stats_pitchers.ERA
FROM mlb_career_stats_pitchers
WHERE mlb_career_stats_pitchers.line_desc='ytd' AND mlb_career_stats_pitchers.date_sort LIKE '%.9'
) AS current_record_rs ON mlb_players.player_id = current_record_rs.player_id
LEFT JOIN
(
SELECT mlb_career_stats_playoffs.player_id, mlb_career_stats_playoffs.line_desc, mlb_career_stats_playoffs.win, mlb_career_stats_playoffs.loss, mlb_career_stats_playoffs.ERA
FROM mlb_career_stats_playoffs
WHERE mlb_career_stats_playoffs.line_desc='ytd'
) AS current_record_po ON mlb_players.player_id = current_record_po.player_id
) AS away_pitcher_w_record ON mlb_probable_pitchers.away_probable_player_id = away_pitcher_w_record.player_id
LEFT JOIN
(
SELECT
mlb_players.player_id,
mlb_players.tsf_global_id,
mlb_players.first_name,
mlb_players.last_name,
mlb_teams.team_code_AP as team_code,
CONCAT (current_record_rs.W,'-', current_record_rs.L,', ', current_record_rs.ERA) AS rs_current_record,
CONCAT (current_record_po.win,'-', current_record_po.loss,', ', current_record_po.ERA) AS po_current_record
FROM mlb_players
INNER JOIN mlb_teams
ON mlb_players.team_id = mlb_teams.team_id
LEFT JOIN
(
SELECT mlb_career_stats_pitchers.line_desc, mlb_career_stats_pitchers.date_sort, mlb_career_stats_pitchers.player_id, mlb_career_stats_pitchers.W, mlb_career_stats_pitchers.L, mlb_career_stats_pitchers.ERA
FROM mlb_career_stats_pitchers
WHERE mlb_career_stats_pitchers.line_desc='ytd' AND mlb_career_stats_pitchers.date_sort LIKE '%.9'
) AS current_record_rs ON mlb_players.player_id = current_record_rs.player_id
LEFT JOIN
(
SELECT mlb_career_stats_playoffs.player_id, mlb_career_stats_playoffs.line_desc, mlb_career_stats_playoffs.win, mlb_career_stats_playoffs.loss, mlb_career_stats_playoffs.ERA
FROM mlb_career_stats_playoffs
WHERE mlb_career_stats_playoffs.line_desc='ytd'
) AS current_record_po ON mlb_players.player_id = current_record_po.player_id
) AS home_pitcher_w_record
ON mlb_probable_pitchers.home_probable_player_id = home_pitcher_w_record.player_id
WHERE mlb_schedule.game_status_id <> 2
AND mlb_schedule.date >= DATE(NOW())
AND (mlb_teams_2.team_code=home OR mlb_teams_2.team_code=away)
AND mlb_schedule.season_mode_id in (1,2)
AND mlb_schedule.season_id=2024 AND (mlb_teams_2.xts_id='l.mlb.com-t.10' or mlb_teams_1.xts_id='l.mlb.com-t.10') GROUP BY mlb_schedule.id ORDER BY mlb_schedule.date ASC, mlb_schedule.time ASC
Backtrace |
|
200
[]
[]
0 of 0array:15 [▼ "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "host" => array:1 [▶ 0 => "site-dev.sportsforecaster.com" ] ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sun, 06 Apr 2025 02:57:52 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImJTZjhWL2VYMno0VE4wWitZYzN3Wmc9PSIsInZhbHVlIjoiOThTRld3NC9aaEx3Z1VScm9lUFlyVFNFcktqM05laExjNG9vN0pYU1NrUlVaNEI4cVlXTTJsSjBUOFYxdEE0ZVN4VDdQbVJ1MlJEc3c1THhqakt2SDQybkRWSEJHSklIR2lNWVQrTEQ5RXd1WFFBaGhyUlRURGtoM3VrUnRFMVEiLCJtYWMiOiIxMjMwZGM5NTYzNTc3NTY3NDE1YzlmOTRmMDJhYjMyZGQ5NDk0OThlMDk3ZTM5NTIyNTlmYTQwZmQ5YzEzNDQwIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 04:57:52 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImJTZjhWL2VYMno0VE4wWitZYzN3Wmc9PSIsInZhbHVlIjoiOThTRld3NC9aaEx3Z1VScm9lUFlyVFNFcktqM05laExjNG9vN0pYU1NrUlVaNEI4cVlXTTJsSjBUOFYxdEE0ZVN4VDdQb ▶" 1 => "sports_forecaster_session=eyJpdiI6Ikl5ZDdlNmVuZlNUbTQ1NGpmdU43S3c9PSIsInZhbHVlIjoidXNoQmd2aHh5c1U3Sm1qSU9FQ0lpN2lrb1BZcXhIckR2eXRCZDVTeWQ0N2Z4QVI3UGJEYjBrRTlvNEpxQlMyOE9TQkJXNkZQUUZYMTdsWGZ4ZDZ2d2tJejNwTjJnekNPOGdSTE9oMEptb1lFYVNnSmg0NVFtYllFdS9qY2oyU3EiLCJtYWMiOiI1ZTkyYTNkOGVkMjY5NDIxNTBmN2U0NjY0Yjk1YmIzYWI0Zjk3ZjEwYTE0ZTdiNDA5Y2I3ZTNlNGUxNGNlZDg5IiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 04:57:52 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀sports_forecaster_session=eyJpdiI6Ikl5ZDdlNmVuZlNUbTQ1NGpmdU43S3c9PSIsInZhbHVlIjoidXNoQmd2aHh5c1U3Sm1qSU9FQ0lpN2lrb1BZcXhIckR2eXRCZDVTeWQ0N2Z4QVI3UGJEYjBrRTlvNE ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImJTZjhWL2VYMno0VE4wWitZYzN3Wmc9PSIsInZhbHVlIjoiOThTRld3NC9aaEx3Z1VScm9lUFlyVFNFcktqM05laExjNG9vN0pYU1NrUlVaNEI4cVlXTTJsSjBUOFYxdEE0ZVN4VDdQbVJ1MlJEc3c1THhqakt2SDQybkRWSEJHSklIR2lNWVQrTEQ5RXd1WFFBaGhyUlRURGtoM3VrUnRFMVEiLCJtYWMiOiIxMjMwZGM5NTYzNTc3NTY3NDE1YzlmOTRmMDJhYjMyZGQ5NDk0OThlMDk3ZTM5NTIyNTlmYTQwZmQ5YzEzNDQwIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 04:57:52 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImJTZjhWL2VYMno0VE4wWitZYzN3Wmc9PSIsInZhbHVlIjoiOThTRld3NC9aaEx3Z1VScm9lUFlyVFNFcktqM05laExjNG9vN0pYU1NrUlVaNEI4cVlXTTJsSjBUOFYxdEE0ZVN4VDdQb ▶" 1 => "sports_forecaster_session=eyJpdiI6Ikl5ZDdlNmVuZlNUbTQ1NGpmdU43S3c9PSIsInZhbHVlIjoidXNoQmd2aHh5c1U3Sm1qSU9FQ0lpN2lrb1BZcXhIckR2eXRCZDVTeWQ0N2Z4QVI3UGJEYjBrRTlvNEpxQlMyOE9TQkJXNkZQUUZYMTdsWGZ4ZDZ2d2tJejNwTjJnekNPOGdSTE9oMEptb1lFYVNnSmg0NVFtYllFdS9qY2oyU3EiLCJtYWMiOiI1ZTkyYTNkOGVkMjY5NDIxNTBmN2U0NjY0Yjk1YmIzYWI0Zjk3ZjEwYTE0ZTdiNDA5Y2I3ZTNlNGUxNGNlZDg5IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 04:57:52 GMT; path=/; secure; httponly ◀sports_forecaster_session=eyJpdiI6Ikl5ZDdlNmVuZlNUbTQ1NGpmdU43S3c9PSIsInZhbHVlIjoidXNoQmd2aHh5c1U3Sm1qSU9FQ0lpN2lrb1BZcXhIckR2eXRCZDVTeWQ0N2Z4QVI3UGJEYjBrRTlvNE ▶" ] ]
0 of 0array:3 [▼ "_token" => "vH508tQi6tQgvl7Nx5GDKkguTq9AkNmWZFNzbOSP" "_previous" => array:1 [▶ "url" => "https://site-dev.sportsforecaster.com/mlb/schedule/l.mlb.com-t.10/Minnesota_Twins" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]