Arizona Diamondbacks vs. Philadelphia Phillies: Head-to-Head Reg Season and Playoffs Stats Comparison

Compare players and teams or see head to head results between teams, players, player vs. team, or batter vs. pitcher. • Tutorial Video • Sample Searches • Data Coverage

THIS QUESTION WAS ANSWERED USING

Your All Access Pass to the Baseball Database Go beyond the basics. Become a Stathead

Start Your FREE Trial

--------------------------------------

header_comp

WITH
  t1 AS (
SELECT team_id, SUM(win AND type="reg") as rsw, SUM(loss AND type="reg") as rsl, SUM(tie AND type="reg") as rst, SUM(win AND type="post") as pow, SUM(loss AND type="post") as pol
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?  
  ),
  t2 AS (
SELECT team_id, SUM(win AND type="reg") as rsw, SUM(loss AND type="reg") as rsl, SUM(tie AND type="reg") as rst, SUM(win AND type="post") as pow, SUM(loss AND type="post") as pol
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?  
  )
SELECT team_id, rs_wins, rs_losses, rs_ties, po_wins, po_losses, SUM(games) AS games, SUM(wins) AS wins, SUM(losses) AS losses, SUM(b_r)/SUM(b_games) as team_runs_pg_csk, ROUND(SUM(b_r)/SUM(b_games),1) AS team_runs_pg, SUM(p_r)/SUM(p_g) as team_ra_pg_csk, ROUND(SUM(p_r)/SUM(p_g),1) AS team_ra_pg, SUM(is_playoff_team) AS is_playoff_team, SUM(is_champion_league) AS is_champion_league, SUM(is_champion_ws) AS is_champion_ws
FROM sup_team_seasons as ts
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
  LEFT JOIN (SELECT t1.team_id, t1.rsw as rs_wins, t1.rsl as rs_losses, t1.rst as rs_ties, t1.pow as po_wins, t1.pol as po_losses FROM t1
  UNION SELECT t2.team_id, t2.rsw as rs_wins, t2.rsl as rs_losses, t2.rst as rs_ties, t2.pow as po_wins, t2.pol as po_losses
FROM t2) as xxx USING (team_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id
ORDER BY team_id 

SQL PARAMS -- $VAR1 = [
          'ARI',
          'PHI',
          'PHI',
          'ARI',
          'ARI',
          'PHI'
        ];

--------------------------------------

h2h_gamelogs

Page Setup Time: 0.00085 seconds

SELECT IF(away_team_id="ARI","@","") as loc, IF(away_team_id="ARI",away_score,home_score) as team1_score, IF(away_team_id="PHI",away_score,home_score) as team2_score, game_id, CONCAT(`date`,IF(date_game_number,CONCAT(" (",date_game_number,")"),"")) as date, game_id, sup_games.link as game_link, sup_venue_seasons.name as venue_name, city as venue_city, outs_played as overtimes_csk, IF( scheduled_innings != 9 OR outs_played < 6*IFNULL(scheduled_innings,9)-3 OR outs_played > 6*IFNULL(scheduled_innings,9), CONCAT(CEIL(outs_played / 6), " inn."), "" ) as overtimes
FROM sup_games
  JOIN (SELECT game_id, year_id, comp_id, phase_id, team_id as away_team_id, opp_team_id, opp_comp_id, opp_phase_id, team_game_num_season, home_away_neutral FROM sup_team_games) as tg USING (game_id, away_team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  LEFT JOIN sup_venues USING (venue_id)
  LEFT JOIN sup_venue_seasons USING (venue_id, year_id)
WHERE ((away_team_id=? AND home_team_id=?) OR (away_team_id=? AND home_team_id=?))
  AND home_score IS NOT NULL
  AND type="reg" 
ORDER BY date DESC LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'ARI',
          'PHI',
          'PHI',
          'ARI'
        ];

Query Time: 0.06 seconds
SELECT IF(away_team_id="ARI","@","") as loc, IF(away_team_id="ARI",away_score,home_score) as team1_score, IF(away_team_id="PHI",away_score,home_score) as team2_score, game_id, CONCAT(`date`,IF(date_game_number,CONCAT(" (",date_game_number,")"),"")) as date, game_id, sup_games.link as game_link, sup_venue_seasons.name as venue_name, city as venue_city, outs_played as overtimes_csk, IF( scheduled_innings != 9 OR outs_played < 6*IFNULL(scheduled_innings,9)-3 OR outs_played > 6*IFNULL(scheduled_innings,9), CONCAT(CEIL(outs_played / 6), " inn."), "" ) as overtimes
FROM sup_games
  JOIN (SELECT game_id, year_id, comp_id, phase_id, team_id as away_team_id, opp_team_id, opp_comp_id, opp_phase_id, team_game_num_season, home_away_neutral FROM sup_team_games) as tg USING (game_id, away_team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  LEFT JOIN sup_venues USING (venue_id)
  LEFT JOIN sup_venue_seasons USING (venue_id, year_id)
WHERE ((away_team_id=? AND home_team_id=?) OR (away_team_id=? AND home_team_id=?))
  AND home_score IS NOT NULL
  AND type="post" 
ORDER BY date DESC LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'ARI',
          'PHI',
          'PHI',
          'ARI'
        ];

Query Time: 0.06 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.04 seconds


--------------------------------------

h2h_records

Page Setup Time: 0.00064 seconds

WITH
  tr1 AS (
SELECT year_id, comp_id, COUNT(*) AS games, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(b_r) AS b_r, SUM(p_r) AS p_r
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?
  AND type="reg" 
GROUP BY year_id 
  ),
  tr2 AS (
SELECT year_id, comp_id, COUNT(*) AS games, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(b_r) AS b_r, SUM(p_r) AS p_r
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?
  AND type="reg" 
GROUP BY year_id 
  )
SELECT year_id as year_id_csk, year_id as year_id, tr1.comp_id, tr1.games AS tr1_games, tr2.games AS tr2_games, tr1.wins AS tr1_wins, tr2.wins AS tr2_wins, tr1.losses AS tr1_losses, tr2.losses AS tr2_losses, tr1.b_r AS tr1_b_r, tr2.b_r AS tr2_b_r, tr1.p_r AS tr1_p_r, tr2.p_r AS tr2_p_r
FROM tr1
  JOIN tr2 USING (year_id)
WHERE 1 
GROUP BY year_id
ORDER BY year_id 

SQL PARAMS -- $VAR1 = [
          'ARI',
          'PHI',
          'PHI',
          'ARI'
        ];

Query Time: 0.07 seconds
WITH
  tr1 AS (
SELECT year_id, comp_id, COUNT(*) AS games, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(b_r) AS b_r, SUM(p_r) AS p_r
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?
  AND type="post" 
GROUP BY year_id 
  ),
  tr2 AS (
SELECT year_id, comp_id, COUNT(*) AS games, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(b_r) AS b_r, SUM(p_r) AS p_r
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?
  AND type="post" 
GROUP BY year_id 
  )
SELECT year_id as year_id_csk, year_id as year_id, tr1.comp_id, tr1.games AS tr1_games, tr2.games AS tr2_games, tr1.wins AS tr1_wins, tr2.wins AS tr2_wins, tr1.losses AS tr1_losses, tr2.losses AS tr2_losses, tr1.b_r AS tr1_b_r, tr2.b_r AS tr2_b_r, tr1.p_r AS tr1_p_r, tr2.p_r AS tr2_p_r
FROM tr1
  JOIN tr2 USING (year_id)
WHERE 1 
GROUP BY year_id
ORDER BY year_id 

SQL PARAMS -- $VAR1 = [
          'ARI',
          'PHI',
          'PHI',
          'ARI'
        ];

Query Time: 0.06 seconds
Table Build Time: 0.05 seconds

Table Build Time: 0.03 seconds


--------------------------------------

h2h_sum

Page Setup Time: 0.00120 seconds

WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(win)/(SUM(win+loss)) as team_win_loss_perc_csk, TRIM(LEADING '0' FROM ROUND(SUM(win)/(SUM(win+loss)),3)) AS team_win_loss_perc, SUM(p_sho) AS p_sho, COUNT(*) AS games, SUM(b_r) AS b_r, SUM(b_h) AS b_h, SUM(b_doubles) AS b_doubles, SUM(b_triples) AS b_triples, SUM(b_hr) AS b_hr, SUM(b_sb) AS b_sb, IF(SUM(b_ab), SUM(b_h) / SUM(b_ab), NULL) as b_batting_avg_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab), SUM(b_h) / SUM(b_ab), NULL),3)) AS b_batting_avg, IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) as b_onbase_perc_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL),3)) AS b_onbase_perc, IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL) as b_slugging_perc_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL),3)) AS b_slugging_perc, IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) + IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL) as b_onbase_plus_slugging_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) + IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL),3)) AS b_onbase_plus_slugging
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'ARI',
          'PHI'
        ];

Query Time: 0.08 seconds
WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(win)/(SUM(win+loss)) as team_win_loss_perc_csk, TRIM(LEADING '0' FROM ROUND(SUM(win)/(SUM(win+loss)),3)) AS team_win_loss_perc, SUM(p_sho) AS p_sho, COUNT(*) AS games, SUM(b_r) AS b_r, SUM(b_h) AS b_h, SUM(b_doubles) AS b_doubles, SUM(b_triples) AS b_triples, SUM(b_hr) AS b_hr, SUM(b_sb) AS b_sb, IF(SUM(b_ab), SUM(b_h) / SUM(b_ab), NULL) as b_batting_avg_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab), SUM(b_h) / SUM(b_ab), NULL),3)) AS b_batting_avg, IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) as b_onbase_perc_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL),3)) AS b_onbase_perc, IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL) as b_slugging_perc_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL),3)) AS b_slugging_perc, IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) + IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL) as b_onbase_plus_slugging_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) + IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL),3)) AS b_onbase_plus_slugging
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'ARI',
          'PHI'
        ];

Query Time: 0.03 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.04 seconds


--------------------------------------

overall_sum_bat

Page Setup Time: 0.00205 seconds

SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(wins IS NULL) as wins_incomplete, SUM(wins) AS wins, SUM(losses IS NULL) as losses_incomplete, SUM(losses) AS losses, NULL as games_incomplete, SUM(games) AS games, NULL as b_games_incomplete, SUM(b_games) AS b_games, SUM(b_pa IS NULL) as b_pa_incomplete, SUM(b_pa) AS b_pa, SUM(b_ab IS NULL) as b_ab_incomplete, SUM(b_ab) AS b_ab, SUM(b_r IS NULL) as b_r_incomplete, SUM(b_r) AS b_r, SUM(b_h IS NULL) as b_h_incomplete, SUM(b_h) AS b_h, SUM(b_doubles IS NULL) as b_doubles_incomplete, SUM(b_doubles) AS b_doubles, SUM(b_triples IS NULL) as b_triples_incomplete, SUM(b_triples) AS b_triples, SUM(b_hr IS NULL) as b_hr_incomplete, SUM(b_hr) AS b_hr, SUM(b_rbi IS NULL) as b_rbi_incomplete, SUM(b_rbi) AS b_rbi, SUM(b_sb IS NULL) as b_sb_incomplete, SUM(b_sb) AS b_sb, SUM(b_cs IS NULL) as b_cs_incomplete, SUM(b_cs) AS b_cs, SUM(b_bb IS NULL) as b_bb_incomplete, SUM(b_bb) AS b_bb, SUM(b_so IS NULL) as b_so_incomplete, SUM(b_so) AS b_so, IF(SUM(b_ab), SUM(b_h) / SUM(b_ab), NULL) as b_batting_avg_csk, SUM(b_h IS NULL)+SUM(b_ab IS NULL) as b_batting_avg_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab), SUM(b_h) / SUM(b_ab), NULL),3)) AS b_batting_avg, IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) as b_onbase_perc_csk, 0 as b_onbase_perc_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL),3)) AS b_onbase_perc, IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL) as b_slugging_perc_csk, SUM(b_hr IS NULL)+SUM(b_triples IS NULL)+SUM(b_h IS NULL)+SUM(b_doubles IS NULL)+SUM(b_ab IS NULL) as b_slugging_perc_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL),3)) AS b_slugging_perc, IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) + IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL) as b_onbase_plus_slugging_csk, 0 as b_onbase_plus_slugging_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) + IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL),3)) AS b_onbase_plus_slugging, SUM(b_tb IS NULL) as b_tb_incomplete, SUM(b_tb) AS b_tb, SUM(b_gidp IS NULL) as b_gidp_incomplete, SUM(b_gidp) AS b_gidp, SUM(b_hbp IS NULL) as b_hbp_incomplete, SUM(b_hbp) AS b_hbp, SUM(b_sh IS NULL) as b_sh_incomplete, SUM(b_sh) AS b_sh, SUM(b_sf IS NULL) as b_sf_incomplete, SUM(b_sf) AS b_sf, SUM(b_ibb IS NULL) as b_ibb_incomplete, SUM(b_ibb) AS b_ibb
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'ARI',
          'PHI'
        ];

Query Time: 0.01 seconds
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(wins IS NULL) as wins_incomplete, SUM(wins) AS wins, SUM(losses IS NULL) as losses_incomplete, SUM(losses) AS losses, NULL as games_incomplete, SUM(games) AS games, NULL as b_games_incomplete, SUM(b_games) AS b_games, SUM(b_pa IS NULL) as b_pa_incomplete, SUM(b_pa) AS b_pa, SUM(b_ab IS NULL) as b_ab_incomplete, SUM(b_ab) AS b_ab, SUM(b_r IS NULL) as b_r_incomplete, SUM(b_r) AS b_r, SUM(b_h IS NULL) as b_h_incomplete, SUM(b_h) AS b_h, SUM(b_doubles IS NULL) as b_doubles_incomplete, SUM(b_doubles) AS b_doubles, SUM(b_triples IS NULL) as b_triples_incomplete, SUM(b_triples) AS b_triples, SUM(b_hr IS NULL) as b_hr_incomplete, SUM(b_hr) AS b_hr, SUM(b_rbi IS NULL) as b_rbi_incomplete, SUM(b_rbi) AS b_rbi, SUM(b_sb IS NULL) as b_sb_incomplete, SUM(b_sb) AS b_sb, SUM(b_cs IS NULL) as b_cs_incomplete, SUM(b_cs) AS b_cs, SUM(b_bb IS NULL) as b_bb_incomplete, SUM(b_bb) AS b_bb, SUM(b_so IS NULL) as b_so_incomplete, SUM(b_so) AS b_so, IF(SUM(b_ab), SUM(b_h) / SUM(b_ab), NULL) as b_batting_avg_csk, SUM(b_h IS NULL)+SUM(b_ab IS NULL) as b_batting_avg_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab), SUM(b_h) / SUM(b_ab), NULL),3)) AS b_batting_avg, IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) as b_onbase_perc_csk, 0 as b_onbase_perc_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL),3)) AS b_onbase_perc, IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL) as b_slugging_perc_csk, SUM(b_hr IS NULL)+SUM(b_triples IS NULL)+SUM(b_h IS NULL)+SUM(b_doubles IS NULL)+SUM(b_ab IS NULL) as b_slugging_perc_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL),3)) AS b_slugging_perc, IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) + IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL) as b_onbase_plus_slugging_csk, 0 as b_onbase_plus_slugging_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), SUM(b_h + IFNULL(b_bb,0) + IFNULL(b_hbp,0)) / SUM(b_ab + IFNULL(b_bb,0) + IFNULL(b_hbp,0) + IFNULL(b_sf,0)), NULL) + IF(SUM(b_ab), SUM(b_h + b_doubles + (2 * b_triples) + (3 * b_hr)) / SUM(b_ab), NULL),3)) AS b_onbase_plus_slugging, SUM(b_tb IS NULL) as b_tb_incomplete, SUM(b_tb) AS b_tb, SUM(b_gidp IS NULL) as b_gidp_incomplete, SUM(b_gidp) AS b_gidp, SUM(b_hbp IS NULL) as b_hbp_incomplete, SUM(b_hbp) AS b_hbp, SUM(b_sh IS NULL) as b_sh_incomplete, SUM(b_sh) AS b_sh, SUM(b_sf IS NULL) as b_sf_incomplete, SUM(b_sf) AS b_sf, SUM(b_ibb IS NULL) as b_ibb_incomplete, SUM(b_ibb) AS b_ibb
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="post" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'ARI',
          'PHI'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.04 seconds


--------------------------------------

overall_sum_pit

Page Setup Time: 0.00207 seconds

SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(wins IS NULL) as wins_incomplete, SUM(wins) AS wins, SUM(losses IS NULL) as losses_incomplete, SUM(losses) AS losses, NULL as games_incomplete, SUM(games) AS games, IF(SUM(p_ip_outs), 27 * SUM(p_er) /SUM(p_ip_outs), IF(SUM(p_er), 1e20, NULL)) as p_earned_run_avg_csk, SUM(p_er IS NULL)+SUM(p_ip_outs IS NULL) as p_earned_run_avg_incomplete, ROUND(IF(SUM(p_ip_outs), 27 * SUM(p_er)/SUM(p_ip_outs), NULL),2) AS p_earned_run_avg, SUM(p_cg IS NULL) as p_cg_incomplete, SUM(p_cg) AS p_cg, SUM(p_sho IS NULL) as p_sho_incomplete, SUM(p_sho) AS p_sho, SUM(p_sv IS NULL) as p_sv_incomplete, SUM(p_sv) AS p_sv, SUM(p_ip_outs) as p_ip_csk, SUM(p_ip_outs IS NULL) as p_ip_incomplete, SUM(p_ip_outs) DIV 3 + 0.1 * MOD(SUM(p_ip_outs),3) AS p_ip, SUM(p_h IS NULL) as p_h_incomplete, SUM(p_h) AS p_h, SUM(p_r IS NULL) as p_r_incomplete, SUM(p_r) AS p_r, SUM(p_er IS NULL) as p_er_incomplete, SUM(p_er) AS p_er, SUM(p_hr IS NULL) as p_hr_incomplete, SUM(p_hr) AS p_hr, SUM(p_bb IS NULL) as p_bb_incomplete, SUM(p_bb) AS p_bb, SUM(p_ibb IS NULL) as p_ibb_incomplete, SUM(p_ibb) AS p_ibb, SUM(p_so IS NULL) as p_so_incomplete, SUM(p_so) AS p_so, SUM(p_hbp IS NULL) as p_hbp_incomplete, SUM(p_hbp) AS p_hbp, SUM(p_bk IS NULL) as p_bk_incomplete, SUM(p_bk) AS p_bk, SUM(p_wp IS NULL) as p_wp_incomplete, SUM(p_wp) AS p_wp, SUM(p_bfp IS NULL) as p_bfp_incomplete, SUM(p_bfp) AS p_bfp, SUM(p_h IS NULL)+SUM(p_hbp IS NULL)+SUM(p_roe IS NULL)+SUM(p_bb IS NULL)+SUM(p_reached_on_strikeout IS NULL) as p_baserunners_incomplete, SUM(p_h + IFNULL(p_bb,0) + IFNULL(p_hbp,0) + IFNULL(p_roe,0) + IFNULL(p_reached_on_strikeout,0)) AS p_baserunners, IF(SUM(IFNULL(p_er,0)) = 0, NULL, 100*(SUM(p_er_lg_avg) / SUM(p_er))) as p_earned_run_avg_plus_csk, SUM(p_er_lg_avg IS NULL)+SUM(p_er IS NULL) as p_earned_run_avg_plus_incomplete, ROUND(IF(SUM(IFNULL(p_er,0)) = 0, NULL, 100*(SUM(p_er_lg_avg) / SUM(p_er))),0) AS p_earned_run_avg_plus, IF(SUM(p_ip_outs) = 0, NULL, 3 * SUM(p_h + p_bb) / SUM(p_ip_outs)) as p_whip_csk, SUM(p_bb IS NULL)+SUM(p_h IS NULL)+SUM(p_ip_outs IS NULL) as p_whip_incomplete, ROUND(IF(SUM(p_ip_outs) = 0, NULL, 3 * SUM(p_h + p_bb) / SUM(p_ip_outs)),3) AS p_whip, IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_h) / SUM(p_ip_outs)) as p_hits_per_nine_csk, SUM(p_ip_outs IS NULL)+SUM(p_h IS NULL) as p_hits_per_nine_incomplete, ROUND(IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_h) / SUM(p_ip_outs)),1) AS p_hits_per_nine, IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_hr) / SUM(p_ip_outs)) as p_hr_per_nine_csk, SUM(p_hr IS NULL)+SUM(p_ip_outs IS NULL) as p_hr_per_nine_incomplete, ROUND(IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_hr) / SUM(p_ip_outs)),1) AS p_hr_per_nine, IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_bb) / SUM(p_ip_outs)) as p_bb_per_nine_csk, SUM(p_bb IS NULL)+SUM(p_ip_outs IS NULL) as p_bb_per_nine_incomplete, ROUND(IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_bb) / SUM(p_ip_outs)),1) AS p_bb_per_nine, IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_so) / SUM(p_ip_outs)) as p_so_per_nine_csk, SUM(p_so IS NULL)+SUM(p_ip_outs IS NULL) as p_so_per_nine_incomplete, ROUND(IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_so) / SUM(p_ip_outs)),1) AS p_so_per_nine
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'ARI',
          'PHI'
        ];

Query Time: 0.01 seconds
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(wins IS NULL) as wins_incomplete, SUM(wins) AS wins, SUM(losses IS NULL) as losses_incomplete, SUM(losses) AS losses, NULL as games_incomplete, SUM(games) AS games, IF(SUM(p_ip_outs), 27 * SUM(p_er) /SUM(p_ip_outs), IF(SUM(p_er), 1e20, NULL)) as p_earned_run_avg_csk, SUM(p_er IS NULL)+SUM(p_ip_outs IS NULL) as p_earned_run_avg_incomplete, ROUND(IF(SUM(p_ip_outs), 27 * SUM(p_er)/SUM(p_ip_outs), NULL),2) AS p_earned_run_avg, SUM(p_cg IS NULL) as p_cg_incomplete, SUM(p_cg) AS p_cg, SUM(p_sho IS NULL) as p_sho_incomplete, SUM(p_sho) AS p_sho, SUM(p_sv IS NULL) as p_sv_incomplete, SUM(p_sv) AS p_sv, SUM(p_ip_outs) as p_ip_csk, SUM(p_ip_outs IS NULL) as p_ip_incomplete, SUM(p_ip_outs) DIV 3 + 0.1 * MOD(SUM(p_ip_outs),3) AS p_ip, SUM(p_h IS NULL) as p_h_incomplete, SUM(p_h) AS p_h, SUM(p_r IS NULL) as p_r_incomplete, SUM(p_r) AS p_r, SUM(p_er IS NULL) as p_er_incomplete, SUM(p_er) AS p_er, SUM(p_hr IS NULL) as p_hr_incomplete, SUM(p_hr) AS p_hr, SUM(p_bb IS NULL) as p_bb_incomplete, SUM(p_bb) AS p_bb, SUM(p_ibb IS NULL) as p_ibb_incomplete, SUM(p_ibb) AS p_ibb, SUM(p_so IS NULL) as p_so_incomplete, SUM(p_so) AS p_so, SUM(p_hbp IS NULL) as p_hbp_incomplete, SUM(p_hbp) AS p_hbp, SUM(p_bk IS NULL) as p_bk_incomplete, SUM(p_bk) AS p_bk, SUM(p_wp IS NULL) as p_wp_incomplete, SUM(p_wp) AS p_wp, SUM(p_bfp IS NULL) as p_bfp_incomplete, SUM(p_bfp) AS p_bfp, SUM(p_h IS NULL)+SUM(p_hbp IS NULL)+SUM(p_roe IS NULL)+SUM(p_bb IS NULL)+SUM(p_reached_on_strikeout IS NULL) as p_baserunners_incomplete, SUM(p_h + IFNULL(p_bb,0) + IFNULL(p_hbp,0) + IFNULL(p_roe,0) + IFNULL(p_reached_on_strikeout,0)) AS p_baserunners, IF(SUM(IFNULL(p_er,0)) = 0, NULL, 100*(SUM(p_er_lg_avg) / SUM(p_er))) as p_earned_run_avg_plus_csk, SUM(p_er_lg_avg IS NULL)+SUM(p_er IS NULL) as p_earned_run_avg_plus_incomplete, ROUND(IF(SUM(IFNULL(p_er,0)) = 0, NULL, 100*(SUM(p_er_lg_avg) / SUM(p_er))),0) AS p_earned_run_avg_plus, IF(SUM(p_ip_outs) = 0, NULL, 3 * SUM(p_h + p_bb) / SUM(p_ip_outs)) as p_whip_csk, SUM(p_bb IS NULL)+SUM(p_h IS NULL)+SUM(p_ip_outs IS NULL) as p_whip_incomplete, ROUND(IF(SUM(p_ip_outs) = 0, NULL, 3 * SUM(p_h + p_bb) / SUM(p_ip_outs)),3) AS p_whip, IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_h) / SUM(p_ip_outs)) as p_hits_per_nine_csk, SUM(p_ip_outs IS NULL)+SUM(p_h IS NULL) as p_hits_per_nine_incomplete, ROUND(IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_h) / SUM(p_ip_outs)),1) AS p_hits_per_nine, IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_hr) / SUM(p_ip_outs)) as p_hr_per_nine_csk, SUM(p_hr IS NULL)+SUM(p_ip_outs IS NULL) as p_hr_per_nine_incomplete, ROUND(IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_hr) / SUM(p_ip_outs)),1) AS p_hr_per_nine, IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_bb) / SUM(p_ip_outs)) as p_bb_per_nine_csk, SUM(p_bb IS NULL)+SUM(p_ip_outs IS NULL) as p_bb_per_nine_incomplete, ROUND(IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_bb) / SUM(p_ip_outs)),1) AS p_bb_per_nine, IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_so) / SUM(p_ip_outs)) as p_so_per_nine_csk, SUM(p_so IS NULL)+SUM(p_ip_outs IS NULL) as p_so_per_nine_incomplete, ROUND(IF(SUM(p_ip_outs) = 0, NULL, 27 * SUM(p_so) / SUM(p_ip_outs)),1) AS p_so_per_nine
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="post" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'ARI',
          'PHI'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.04 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          't1yrto' => 2025,
          'team_id1' => 'ARI',
          'team_id2' => 'PHI',
          'match' => 'versus_teamvteam',
          't2yrto' => 2025
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'match' => 'versus_teamvteam',
          'team_id2' => 'PHI',
          'team_id1' => 'ARI'
        };

Show Criteria

Compare Players

Head-to-head stats or multi-player comparisons

Compare Teams

Head-to-head results and comparisons

Player vs. Team

Head-to-head stats for a single player against a team

Today's Probables

Today's starting pitchers vs. opponents

Search Criteria

Seasons

All seasons

Choose season(s) for each choice

Choose same season(s) for all choices

Team 1

Team 2

Clear All

You have edited your search criteria

or keep editing your search

clear changes

Fetching Results

Philadelphia Phillies

Arizona Diamondbacks

89-92

3-4

Reg Season

Playoffs

92-89

4-3

21810

10303

11392

4.4

4.7

R/Gm

RA/Gm

Playoff Apps.

WS Apps.

WS Championships

4434

2167

2267

4.6

Arizona Diamondbacks vs. Philadelphia Phillies: Head-to-Head Stats

Arizona Diamondbacks vs. Philadelphia Phillies: Recent Games

Regular Season

Subscribe to Stathead Baseball for full results.

Go inside the Baseball Reference database and access the sports search engine that was made for fans like you. Subscriptions start at just $9/month. Learn More.

Get your first month FREE

Already a paid subscriber? Log in for full results.

Arizona Diamondbacks vs. Philadelphia Phillies: Recent Games Table
Rk	Date	ARI		PHI		Venue
1	2025-09-21	9		2		Chase Field
2	2025-09-20	4		3		Chase Field
3	2025-09-19	2		8		Chase Field
4	2025-05-04	11	@	9	10 inn.	Citizens Bank Park
5	2025-05-03	2	@	7		Citizens Bank Park
6	2025-05-02	2	@	3		Citizens Bank Park
7	2024-08-11	12		5		Chase Field
8	2024-08-10	11		1		Chase Field
9	2024-08-09	3		2		Chase Field
10	2024-08-08	4		6		Chase Field

Arizona Diamondbacks vs. Philadelphia Phillies: Yearly Records

Regular Season

Playoffs

Arizona Diamondbacks vs. Philadelphia Phillies: Yearly Records Table
		Arizona Diamondbacks					Philadelphia Phillies
Rk	Season	GP	W	L	R	R	GP	W	L	R	R
1	1998	9	2	7	33	51	9	7	2	51	33
2	1999	9	8	1	44	16	9	1	8	16	44
3	2000	9	8	1	64	30	9	1	8	30	64
4	2001	7	3	4	26	27	7	4	3	27	26
5	2002	7	4	3	31	31	7	3	4	31	31
6	2003	6	4	2	30	18	6	2	4	18	30
7	2004	6	1	5	20	33	6	5	1	33	20
8	2005	7	3	4	40	46	7	4	3	46	40
9	2006	6	1	5	19	37	6	5	1	37	19
10	2007	6	5	1	30	26	6	1	5	26	30
11	2008	7	3	4	40	39	7	4	3	39	40
12	2009	6	1	5	14	35	6	5	1	35	14
13	2010	6	2	4	25	32	6	4	2	32	25
14	2011	6	3	3	21	28	6	3	3	28	21
15	2012	6	2	4	24	30	6	4	2	30	24
16	2013	7	3	4	28	30	7	4	3	30	28
17	2014	6	2	4	27	31	6	4	2	31	27
18	2015	6	2	4	40	28	6	4	2	28	40
19	2016	7	4	3	33	26	7	3	4	26	33
20	2017	7	6	1	33	19	7	1	6	19	33
21	2018	6	4	2	30	18	6	2	4	18	30
22	2019	6	4	2	36	27	6	2	4	27	36
23	2021	7	4	3	31	34	7	3	4	34	31
24	2022	6	3	3	45	40	6	3	3	40	45
25	2023	7	3	4	34	44	7	4	3	44	34
26	2024	7	4	3	37	34	7	3	4	34	37
27	2025	6	3	3	30	32	6	3	3	32	30
	Totals	181	92	89	865	842	181	89	92	842	865

Arizona Diamondbacks vs. Philadelphia Phillies: Yearly Records Table
		Arizona Diamondbacks					Philadelphia Phillies
Rk	Season	GP	W	L	R	R	GP	W	L	R	R
1	2023	7	4	3	21	30	7	3	4	30	21
	Totals	7	4	3	21	30	7	3	4	30	21

Arizona Diamondbacks vs. Philadelphia Phillies: Head-to-Head Stats Totals

Regular Season

Playoffs

Arizona Diamondbacks vs. Philadelphia Phillies: Head-to-Head Stats Totals Table
Rk	Team	From	To	W	L	WL%	SHO	GP	R	H	2B	3B	HR	SB	BA	OBP	SLG	OPS
1	ARI	1998	2025	92	89	.508	8	181	865	1641	340	49	221	77	.262	.327	.438	.765
2	PHI	1998	2025	89	92	.492	10	181	842	1648	344	35	205	106	.261	.329	.425	.754

Arizona Diamondbacks vs. Philadelphia Phillies: Head-to-Head Stats Totals Table
Rk	Team	From	To	W	L	WL%	SHO	GP	R	H	2B	3B	HR	SB	BA	OBP	SLG	OPS
1	ARI	2023	2023	4	3	.571	0	7	21	55	9	1	5	9	.236	.294	.348	.642
2	PHI	2023	2023	3	4	.429	1	7	30	51	12	1	11	7	.231	.315	.443	.758

Arizona Diamondbacks vs. Philadelphia Phillies: Team Comparison

Arizona Diamondbacks vs. Philadelphia Phillies: Overall Batting Totals

Regular Season

Playoffs

Arizona Diamondbacks vs. Philadelphia Phillies: Overall Batting Totals Table
Rk	Team	From	To	W	L	GP	G	PA	AB	R	H	2B	3B	HR	RBI	SB	CS	BB	SO	BA	OBP	SLG	OPS	TB	GIDP	HBP	SH	SF	IBB
1	ARI	1998	2025	2167	2267	4434	4434	170108	151251	20296	38521	7894	1095	4759	19348	2586	930	14724	33571	.255	.324	.416	.740	62882	3158	1482	1354	1249	1105
2	PHI	1883	2025	10303	11392	21810	21806	835280	746248	96891	194313	33608	6695	14354	87745	15042	4847	68097	109676	.260	.326	.381	.707	284373	10635	5457	11929	3045	4738

Arizona Diamondbacks vs. Philadelphia Phillies: Overall Batting Totals Table
Rk	Team	From	To	W	L	GP	G	PA	AB	R	H	2B	3B	HR	RBI	SB	CS	BB	SO	BA	OBP	SLG	OPS	TB	GIDP	HBP	SH	SF	IBB
1	ARI	1999	2023	28	29	57	57	2160	1920	235	476	76	10	65	229	40	13	183	482	.248	.319	.399	.718	767	43	21	25	11	21
2	PHI	1915	2025	70	71	141	141	5257	4635	573	1101	216	27	150	543	95	32	488	1025	.238	.315	.393	.708	1821	91	48	55	30	65

Arizona Diamondbacks vs. Philadelphia Phillies: Overall Pitching Totals

Regular Season

Playoffs

Arizona Diamondbacks vs. Philadelphia Phillies: Overall Pitching Totals Table
Rk	Team	From	To	W	L	GP	ERA	CG	SHO	SV	IP	H	R	ER	HR	BB	IBB	SO	HBP	BK	WP	BF	BR	ERA+	WHIP	H9	HR9	BB9	SO9
1	ARI	1998	2025	2167	2267	4434	4.30	139	55	1070	39603.2	39153	20575	18903	5004	14021	1051	33642	1548	179	1498	169844	56209	102	1.343	8.9	1.1	3.2	7.6
2	PHI	1883	2025	10303	11392	21810	3.99	7666	1047	2981	194124.2	199926	102500	86020	14718	67944	4502	105559	5826	763	5726	835703	282791	96	1.380	9.3	0.7	3.2	4.9

Arizona Diamondbacks vs. Philadelphia Phillies: Overall Pitching Totals Table
Rk	Team	From	To	W	L	GP	ERA	CG	SHO	SV	IP	H	R	ER	HR	BB	IBB	SO	HBP	BK	WP	BF	BR	ERA+	WHIP	H9	HR9	BB9	SO9
1	ARI	1999	2023	28	29	57	3.63	5	3	10	508.0	435	225	205	59	195	12	461	17	1	21	2135	647		1.240	7.7	1.0	3.5	8.2
2	PHI	1915	2025	70	71	141	3.57	12	3	35	1251.1	1125	536	496	117	432	50	1094	46	2	40	5262	1603		1.244	8.1	0.8	3.1	7.9

Data coverage:

Game data: Game data is only available for the American League, National League, and Federal League. Since 1901 for regular season data, since 1933 for the All-Star Game, and since 1903 for the Postseason.

Season data: Since 1871. Stats relying on play-by-play data are complete back to 1969, nearly complete back to 1950, and mostly complete back to 1912. Postseason data since 1903.

Please see our data coverage page for details.

If you utilize material unique to a Sports Reference site for a tweet, an article, or for research for a broadcast or podcast, please strongly consider citing this site as the source for the material. It would be greatly appreciated and would help us continue to produce this material.

Arizona Diamondbacks vs. Philadelphia Phillies: Head-to-Head Reg Season and Playoffs Stats Comparison

Compare Players

Compare Teams

Player vs. Team

Today's Probables

Search Criteria

Arizona Diamondbacks vs. Philadelphia Phillies: Head-to-Head Stats

Arizona Diamondbacks vs. Philadelphia Phillies: Recent Games

Arizona Diamondbacks vs. Philadelphia Phillies: Recent Games

Subscribe to Stathead Baseball for full results.

Arizona Diamondbacks vs. Philadelphia Phillies: Yearly Records

Arizona Diamondbacks vs. Philadelphia Phillies: Yearly Records

Arizona Diamondbacks vs. Philadelphia Phillies: Head-to-Head Stats Totals

Arizona Diamondbacks vs. Philadelphia Phillies: Head-to-Head Stats Totals

Arizona Diamondbacks vs. Philadelphia Phillies: Team Comparison

Arizona Diamondbacks vs. Philadelphia Phillies: Overall Batting Totals

Arizona Diamondbacks vs. Philadelphia Phillies: Overall Batting Totals

Arizona Diamondbacks vs. Philadelphia Phillies: Overall Pitching Totals

Arizona Diamondbacks vs. Philadelphia Phillies: Overall Pitching Totals

Full Site Menu

FAQs, Tip & Tricks