Tom Brady vs. New Orleans Saints

Compare players and teams or see head to head results between teams, players, or player vs. team. Data Coverage

THIS QUESTION WAS ANSWERED USING

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

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

header_pvt_summary

WITH
  rspvt AS (
SELECT person_id, COUNT(*) as games, SUM(win=1) as wins, SUM(loss=1) as losses, SUM(tie=1) as ties, SUM(pass_cmp) AS pass_cmp, SUM(pass_att) AS pass_att, SUM(pass_yds) AS pass_yds, SUM(pass_td) AS pass_td, SUM(pass_int) AS pass_int
FROM sup_player_games as st
  JOIN (SELECT win, loss, tie, game_id, year_id, comp_id, phase_id, team_id, opp_team_id FROM sup_team_games) as tg USING (game_id, team_id)
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="reg"  
  ),
  popvt AS (
SELECT person_id, COUNT(*) as games, SUM(win=1) as wins, SUM(loss=1) as losses, SUM(pass_cmp) AS pass_cmp, SUM(pass_att) AS pass_att, SUM(pass_yds) AS pass_yds, SUM(pass_td) AS pass_td, SUM(pass_int) AS pass_int
FROM sup_player_games as st
  JOIN (SELECT win, loss, tie, game_id, year_id, comp_id, phase_id, team_id, opp_team_id FROM sup_team_games) as tg USING (game_id, team_id)
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="post"  
  )
SELECT rspvt.person_id, rspvt.games as rspvt_games, rspvt.wins as rspvt_wins, rspvt.losses as rspvt_losses, rspvt.ties as rspvt_ties, popvt.games as popvt_games, popvt.wins as popvt_wins, popvt.losses as popvt_losses, rspvt.pass_cmp AS rspvt_pass_cmp, popvt.pass_cmp AS popvt_pass_cmp, rspvt.pass_att AS rspvt_pass_att, popvt.pass_att AS popvt_pass_att, rspvt.pass_yds AS rspvt_pass_yds, popvt.pass_yds AS popvt_pass_yds, rspvt.pass_td AS rspvt_pass_td, popvt.pass_td AS popvt_pass_td, rspvt.pass_int AS rspvt_pass_int, popvt.pass_int AS popvt_pass_int
FROM rspvt
  JOIN popvt
WHERE 1  LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'BradTo00',
          'nor',
          'BradTo00',
          'nor'
        ];

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

pvt_pass

Page Setup Time: 0.00211 seconds

SELECT year_id as year_id_csk, year_id as year_id, GROUP_CONCAT(DISTINCT CONCAT('<a href="', 'DOMAIN', ts.link, '" target="_blank">', ts.name_abbr, '</a>')) as teams_played_for, COUNT(*) AS games, SUM(pass_cmp) AS pass_cmp, SUM(pass_att) AS pass_att, (SUM(pass_att)-SUM(pass_cmp)) AS pass_inc, IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL) as pass_cmp_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL)),1) AS pass_cmp_pct, SUM(pass_yds) AS pass_yds, SUM(pass_td) AS pass_td, SUM(pass_int) AS pass_int, SUM(pass_int_td) AS pass_int_td, IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL) as pass_td_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL)),1) AS pass_td_pct, IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL) as pass_int_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL)),1) AS pass_int_pct, IF(SUM(pass_att), 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((SUM(pass_cmp) / SUM(pass_att)) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((SUM(pass_yds) / SUM(pass_att)) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (SUM(pass_td)  / SUM(pass_att)) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (SUM(pass_int) / SUM(pass_att))) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  )
  as pass_rating_csk, ROUND(IF(SUM(pass_att), 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((SUM(pass_cmp) / SUM(pass_att)) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((SUM(pass_yds) / SUM(pass_att)) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (SUM(pass_td)  / SUM(pass_att)) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (SUM(pass_int) / SUM(pass_att))) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  ),
  1) AS pass_rating, SUM(pass_sacked) AS pass_sacked, SUM(pass_sacked_yds) AS pass_sacked_yds, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL) as pass_sacked_pct_csk, ROUND(100 * (IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL)),2) AS pass_sacked_pct, IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL) as pass_yds_per_att_csk, ROUND(IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL),1) AS pass_yds_per_att, IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL) as pass_adj_yds_per_att_csk, ROUND(IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL),2) AS pass_adj_yds_per_att, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL) as pass_adj_net_yds_per_att_csk, ROUND(IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL),2) AS pass_adj_net_yds_per_att, IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL) as pass_yds_per_cmp_csk, ROUND(IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL),1) AS pass_yds_per_cmp
FROM sup_player_games as st
  JOIN (SELECT game_id, year_id, comp_id, phase_id, 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, team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link, phase_id FROM sup_team_seasons) as ts USING (team_id, year_id, phase_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="reg" 
GROUP BY year_id
ORDER BY year_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'BradTo00',
          'nor'
        ];

Query Time: 0.01 seconds
SELECT year_id as year_id_csk, year_id as year_id, GROUP_CONCAT(DISTINCT CONCAT('<a href="', 'DOMAIN', ts.link, '" target="_blank">', ts.name_abbr, '</a>')) as teams_played_for, COUNT(*) AS games, SUM(pass_cmp) AS pass_cmp, SUM(pass_att) AS pass_att, (SUM(pass_att)-SUM(pass_cmp)) AS pass_inc, IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL) as pass_cmp_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL)),1) AS pass_cmp_pct, SUM(pass_yds) AS pass_yds, SUM(pass_td) AS pass_td, SUM(pass_int) AS pass_int, SUM(pass_int_td) AS pass_int_td, IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL) as pass_td_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL)),1) AS pass_td_pct, IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL) as pass_int_pct_csk, ROUND(100 * (IF(SUM(pass_att), SUM(pass_int)/SUM(pass_att), NULL)),1) AS pass_int_pct, IF(SUM(pass_att), 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((SUM(pass_cmp) / SUM(pass_att)) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((SUM(pass_yds) / SUM(pass_att)) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (SUM(pass_td)  / SUM(pass_att)) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (SUM(pass_int) / SUM(pass_att))) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  )
  as pass_rating_csk, ROUND(IF(SUM(pass_att), 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((SUM(pass_cmp) / SUM(pass_att)) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((SUM(pass_yds) / SUM(pass_att)) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (SUM(pass_td)  / SUM(pass_att)) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (SUM(pass_int) / SUM(pass_att))) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  ),
  1) AS pass_rating, SUM(pass_sacked) AS pass_sacked, SUM(pass_sacked_yds) AS pass_sacked_yds, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL) as pass_sacked_pct_csk, ROUND(100 * (IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_sacked))/SUM(IF(pass_sacked IS NULL,0,pass_att+pass_sacked)) , NULL)),2) AS pass_sacked_pct, IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL) as pass_yds_per_att_csk, ROUND(IF(SUM(pass_att), (SUM(pass_yds)/SUM(pass_att)), NULL),1) AS pass_yds_per_att, IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL) as pass_adj_yds_per_att_csk, ROUND(IF(SUM(pass_att),(SUM(pass_yds) + 20.0 * SUM(pass_td) - 45.0 * SUM(pass_int))/SUM(pass_att),NULL),2) AS pass_adj_yds_per_att, IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL) as pass_adj_net_yds_per_att_csk, ROUND(IF(SUM(pass_sacked IS NOT NULL)>0,SUM(IF(pass_sacked IS NULL,0,pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int)))/SUM(IF(pass_sacked IS NULL,0,pass_sacked+pass_att)) ,NULL),2) AS pass_adj_net_yds_per_att, IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL) as pass_yds_per_cmp_csk, ROUND(IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL),1) AS pass_yds_per_cmp
FROM sup_player_games as st
  JOIN (SELECT game_id, year_id, comp_id, phase_id, 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, team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link, phase_id FROM sup_team_seasons) as ts USING (team_id, year_id, phase_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="post" 
GROUP BY year_id
ORDER BY year_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'BradTo00',
          'nor'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.03 seconds

Table Build Time: 0.03 seconds


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

pvt_rec

Page Setup Time: 0.00105 seconds

SELECT year_id as year_id_csk, year_id as year_id, GROUP_CONCAT(DISTINCT CONCAT('<a href="', 'DOMAIN', ts.link, '" target="_blank">', ts.name_abbr, '</a>')) as teams_played_for, COUNT(*) AS games, SUM(rush_att) AS rush_att, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td) AS rush_td, SUM(rush_first_down) AS rush_first_down, SUM(targets) AS targets, SUM(rec) AS rec, SUM(rec_yds) AS rec_yds, IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL) as rec_yds_per_rec_csk, ROUND(IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL),1) AS rec_yds_per_rec, SUM(rec_td) AS rec_td, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0))) as catch_pct_csk, ROUND(100 * (IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0)))),1) AS catch_pct, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))) as rec_yds_per_tgt_csk, ROUND(IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))),1) AS rec_yds_per_tgt, SUM(rec_first_down) AS rec_first_down
FROM sup_player_games as st
  JOIN (SELECT game_id, year_id, comp_id, phase_id, 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, team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link, phase_id FROM sup_team_seasons) as ts USING (team_id, year_id, phase_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="reg" 
GROUP BY year_id
ORDER BY year_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'BradTo00',
          'nor'
        ];

Query Time: 0.01 seconds
SELECT year_id as year_id_csk, year_id as year_id, GROUP_CONCAT(DISTINCT CONCAT('<a href="', 'DOMAIN', ts.link, '" target="_blank">', ts.name_abbr, '</a>')) as teams_played_for, COUNT(*) AS games, SUM(rush_att) AS rush_att, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td) AS rush_td, SUM(rush_first_down) AS rush_first_down, SUM(targets) AS targets, SUM(rec) AS rec, SUM(rec_yds) AS rec_yds, IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL) as rec_yds_per_rec_csk, ROUND(IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL),1) AS rec_yds_per_rec, SUM(rec_td) AS rec_td, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0))) as catch_pct_csk, ROUND(100 * (IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0)))),1) AS catch_pct, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))) as rec_yds_per_tgt_csk, ROUND(IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))),1) AS rec_yds_per_tgt, SUM(rec_first_down) AS rec_first_down
FROM sup_player_games as st
  JOIN (SELECT game_id, year_id, comp_id, phase_id, 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, team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link, phase_id FROM sup_team_seasons) as ts USING (team_id, year_id, phase_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="post" 
GROUP BY year_id
ORDER BY year_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'BradTo00',
          'nor'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.03 seconds

Table Build Time: 0.03 seconds


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

pvt_gamelogs

Page Setup Time: 0.00236 seconds

SELECT age_on_day, ts.name_abbr as team_name_abbr, ts.link as team_link, opp_team_link, date, game_id, sup_games.link as game_link, year_id as year_id_csk, year_id as year_id, IF(home_away_neutral="H","",IF(home_away_neutral="A","@","N")) as game_location, (SELECT points-points_opp+ifnull(points,0)/100 FROM sup_team_games tg2 WHERE tg2.game_id=st.game_id AND tg2.team_id=st.team_id) as game_result_csk, CONCAT((SELECT CONCAT(IF(win=1,'W',IF(loss=1,'L','T')),', ',points,'-',points_opp) FROM sup_team_games tg2 WHERE tg2.game_id=st.game_id AND tg2.team_id=st.team_id),IF(overtimes>0,IF(overtimes>1,CONCAT(' (',overtimes,'OT)'),' (OT)'),'')) as game_result, os.name_abbr as opp_name_abbr, pass_cmp, pass_att, (pass_att-pass_cmp) AS pass_inc, IF(pass_att, pass_cmp/pass_att, NULL) as pass_cmp_pct_csk, ROUND(100 * (IF(pass_att, pass_cmp/pass_att, NULL)),1) AS pass_cmp_pct, pass_yds, pass_td, pass_int, pass_int_td, IF(pass_att, pass_td/pass_att, NULL) as pass_td_pct_csk, ROUND(100 * (IF(pass_att, pass_td/pass_att, NULL)),1) AS pass_td_pct, IF(pass_att, pass_int/pass_att, NULL) as pass_int_pct_csk, ROUND(100 * (IF(pass_att, pass_int/pass_att, NULL)),1) AS pass_int_pct, IF(pass_att, 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((pass_cmp / pass_att) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((pass_yds  / pass_att) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (pass_td  / pass_att) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (pass_int / pass_att)) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  ) 
  as pass_rating_csk, ROUND(IF(pass_att, 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((pass_cmp / pass_att) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((pass_yds  / pass_att) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (pass_td  / pass_att) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (pass_int / pass_att)) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  ) ,
  1) AS pass_rating, pass_sacked, pass_sacked_yds, IF(pass_sacked IS NULL, NULL, pass_sacked/(pass_sacked+pass_att) ) as pass_sacked_pct_csk, ROUND(100 * (IF(pass_sacked IS NULL, NULL, pass_sacked/(pass_sacked+pass_att) )),2) AS pass_sacked_pct, IF(pass_att, ((pass_yds)/(pass_att)), NULL) as pass_yds_per_att_csk, ROUND(IF(pass_att, ((pass_yds)/(pass_att)), NULL),1) AS pass_yds_per_att, IF(pass_att,((pass_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_att)),NULL) as pass_adj_yds_per_att_csk, ROUND(IF(pass_att,((pass_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_att)),NULL),2) AS pass_adj_yds_per_att, IF(pass_sacked IS NULL,NULL,((pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_sacked+pass_att))) as pass_adj_net_yds_per_att_csk, ROUND(IF(pass_sacked IS NULL,NULL,((pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_sacked+pass_att))),2) AS pass_adj_net_yds_per_att, IF(pass_cmp, pass_yds/pass_cmp, NULL) as pass_yds_per_cmp_csk, ROUND(IF(pass_cmp, pass_yds/pass_cmp, NULL),1) AS pass_yds_per_cmp, rush_att, rush_yds, IF(rush_att, rush_yds/rush_att, NULL) as rush_yds_per_att_csk, ROUND(IF(rush_att, rush_yds/rush_att, NULL),1) AS rush_yds_per_att, rush_td, rush_first_down
FROM sup_player_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN (SELECT game_id, year_id, comp_id, phase_id, part_id, team_id, opp_team_id, opp_comp_id, opp_phase_id, team_game_num_season, home_away_neutral, win, loss, tie FROM sup_team_games) as tg USING (game_id, team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  JOIN (SELECT team_id as opp_team_id, year_id, name_abbr, link as opp_team_link FROM sup_team_seasons GROUP BY team_id, year_id ) as os USING (opp_team_id, year_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="reg" 
ORDER BY date DESC LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'BradTo00',
          'nor'
        ];

Query Time: 0.06 seconds
SELECT age_on_day, ts.name_abbr as team_name_abbr, ts.link as team_link, opp_team_link, date, game_id, sup_games.link as game_link, year_id as year_id_csk, year_id as year_id, IF(home_away_neutral="H","",IF(home_away_neutral="A","@","N")) as game_location, (SELECT points-points_opp+ifnull(points,0)/100 FROM sup_team_games tg2 WHERE tg2.game_id=st.game_id AND tg2.team_id=st.team_id) as game_result_csk, CONCAT((SELECT CONCAT(IF(win=1,'W',IF(loss=1,'L','T')),', ',points,'-',points_opp) FROM sup_team_games tg2 WHERE tg2.game_id=st.game_id AND tg2.team_id=st.team_id),IF(overtimes>0,IF(overtimes>1,CONCAT(' (',overtimes,'OT)'),' (OT)'),'')) as game_result, os.name_abbr as opp_name_abbr, pass_cmp, pass_att, (pass_att-pass_cmp) AS pass_inc, IF(pass_att, pass_cmp/pass_att, NULL) as pass_cmp_pct_csk, ROUND(100 * (IF(pass_att, pass_cmp/pass_att, NULL)),1) AS pass_cmp_pct, pass_yds, pass_td, pass_int, pass_int_td, IF(pass_att, pass_td/pass_att, NULL) as pass_td_pct_csk, ROUND(100 * (IF(pass_att, pass_td/pass_att, NULL)),1) AS pass_td_pct, IF(pass_att, pass_int/pass_att, NULL) as pass_int_pct_csk, ROUND(100 * (IF(pass_att, pass_int/pass_att, NULL)),1) AS pass_int_pct, IF(pass_att, 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((pass_cmp / pass_att) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((pass_yds  / pass_att) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (pass_td  / pass_att) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (pass_int / pass_att)) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  ) 
  as pass_rating_csk, ROUND(IF(pass_att, 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((pass_cmp / pass_att) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST(((pass_yds  / pass_att) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (pass_td  / pass_att) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (pass_int / pass_att)) / 0.04, 0.0), 2.375)
  ),
   1), NULL
  ) ,
  1) AS pass_rating, pass_sacked, pass_sacked_yds, IF(pass_sacked IS NULL, NULL, pass_sacked/(pass_sacked+pass_att) ) as pass_sacked_pct_csk, ROUND(100 * (IF(pass_sacked IS NULL, NULL, pass_sacked/(pass_sacked+pass_att) )),2) AS pass_sacked_pct, IF(pass_att, ((pass_yds)/(pass_att)), NULL) as pass_yds_per_att_csk, ROUND(IF(pass_att, ((pass_yds)/(pass_att)), NULL),1) AS pass_yds_per_att, IF(pass_att,((pass_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_att)),NULL) as pass_adj_yds_per_att_csk, ROUND(IF(pass_att,((pass_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_att)),NULL),2) AS pass_adj_yds_per_att, IF(pass_sacked IS NULL,NULL,((pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_sacked+pass_att))) as pass_adj_net_yds_per_att_csk, ROUND(IF(pass_sacked IS NULL,NULL,((pass_yds-pass_sacked_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_sacked+pass_att))),2) AS pass_adj_net_yds_per_att, IF(pass_cmp, pass_yds/pass_cmp, NULL) as pass_yds_per_cmp_csk, ROUND(IF(pass_cmp, pass_yds/pass_cmp, NULL),1) AS pass_yds_per_cmp, rush_att, rush_yds, IF(rush_att, rush_yds/rush_att, NULL) as rush_yds_per_att_csk, ROUND(IF(rush_att, rush_yds/rush_att, NULL),1) AS rush_yds_per_att, rush_td, rush_first_down
FROM sup_player_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN (SELECT game_id, year_id, comp_id, phase_id, part_id, team_id, opp_team_id, opp_comp_id, opp_phase_id, team_game_num_season, home_away_neutral, win, loss, tie FROM sup_team_games) as tg USING (game_id, team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  JOIN (SELECT team_id as opp_team_id, year_id, name_abbr, link as opp_team_link FROM sup_team_seasons GROUP BY team_id, year_id ) as os USING (opp_team_id, year_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="post" 
ORDER BY date DESC LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'BradTo00',
          'nor'
        ];

Query Time: 0.06 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.03 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'player_id1' => 'BradTo00',
          't1yrto' => 2025,
          'team_id1' => 'nor',
          'match' => 'versus_playervteam'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'player_id1' => 'BradTo00',
          'match' => 'versus_playervteam',
          'team_id1' => 'nor'
        };

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

Search Criteria

Seasons

All seasons

Choose season(s) for each choice

Choose same season(s) for all choices

Player 1

Javascript is required for the selection of a player.

Choice is: Tom Brady

Team 1

Team 2

Clear All

You have edited your search criteria

or keep editing your search

clear changes

Fetching Results

Tom Brady vs. New Orleans Saints

Regular Season: 11 GP (6-5), 263 Cmp, 423 Att, 2941 Yds, 20 TD, 12 Int

Playoffs: 1 GP (1-0), 18 Cmp, 33 Att, 199 Yds, 2 TD, 0 Int

Tom Brady vs. New Orleans Saints: Passing Totals

Regular Season

Playoffs

Tom Brady vs. New Orleans Saints: Passing Totals Table
Rk	Season	Team	G	Cmp	Att	Inc	Cmp%	Yds	TD	Int	Pick6	TD%	Int%	Rate	Sk	Yds	Sk%	Y/A	AY/A	ANY/A	Y/C
1	2001	NWE	1	19	26	7	73.1	258	4	0	0	15.4	0.0	143.9	4	17	13.33	9.9	13.00	10.70	13.6
2	2005	NWE	1	15	29	14	51.7	222	3	0	0	10.3	0.0	111.6	3	28	9.38	7.7	9.72	7.94	14.8
3	2009	NWE	1	21	36	15	58.3	237	0	2	0	0.0	5.6	55.0	1	4	2.70	6.6	4.08	3.86	11.3
4	2013	NWE	1	25	43	18	58.1	269	1	1	0	2.3	2.3	74.7	5	34	10.42	6.3	5.67	4.38	10.8
5	2017	NWE	1	30	39	9	76.9	447	3	0	0	7.7	0.0	139.6	2	11	4.88	11.5	13.00	12.10	14.9
6	2020	TAM	2	45	74	29	60.8	448	2	5	1	2.7	6.8	58.8	6	38	7.50	6.1	3.55	2.81	10.0
7	2021	TAM	2	54	88	34	61.4	589	4	3	1	4.5	3.4	82.1	7	55	7.37	6.7	6.07	5.04	10.9
8	2022	TAM	2	54	88	34	61.4	471	3	1	0	3.4	1.1	82.1	2	9	2.22	5.4	5.52	5.30	8.7
9	Totals		11	263	423	160	62.2	2941	20	12	2	4.7	2.8	86.8	30	196	6.62	7.0	6.62	5.75	11.2

Tom Brady vs. New Orleans Saints: Passing Totals Table
Rk	Season	Team	G	Cmp	Att	Inc	Cmp%	Yds	TD	Int	Pick6	TD%	Int%	Rate	Sk	Yds	Sk%	Y/A	AY/A	ANY/A	Y/C
1	2020	TAM	1	18	33	15	54.5	199	2	0	0	6.1	0.0	92.9	1	10	2.94	6.0	7.24	6.74	11.1
2	Totals		1	18	33	15	54.5	199	2	0	0	6.1	0.0	92.9	1	10	2.94	6.0	7.24	6.74	11.1

Tom Brady vs. New Orleans Saints: Rushing & Receiving Totals

Regular Season

Playoffs

Tom Brady vs. New Orleans Saints: Rushing & Receiving Totals Table
				Rushing					Receiving
Rk	Season	Team	G	Att	Yds	Y/A	TD	1D	Tgt	Rec	Yds	Y/R	TD	Ctch%	Y/Tgt	1D
1	2001	NWE	1	4	14	3.5	0	1	0	0	0		0			0
2	2005	NWE	1	1	5	5.0	0	1	0	0	0		0			0
3	2009	NWE	1	1	2	2.0	0	1	0	0	0		0			0
4	2013	NWE	1	2	16	8.0	0	1	0	0	0		0			0
5	2017	NWE	1	2	9	4.5	0	1	0	0	0		0			0
6	2020	TAM	2	3	9	3.0	1	2	0	0	0		0			0
7	2021	TAM	2	2	4	2.0	0	1	0	0	0		0			0
8	2022	TAM	2	4	-3	-0.8	0	0	0	0	0		0			0
9	Totals		11	19	56	2.9	1	8	0	0	0		0			0

Tom Brady vs. New Orleans Saints: Rushing & Receiving Totals Table
				Rushing					Receiving
Rk	Season	Team	G	Att	Yds	Y/A	TD	1D	Tgt	Rec	Yds	Y/R	TD	Ctch%	Y/Tgt	1D
1	2020	TAM	1	5	2	0.4	1	2	0	0	0		0			0
2	Totals		1	5	2	0.4	1	2	0	0	0		0			0

Tom Brady vs. New Orleans Saints: Game Logs

Regular Season

Subscribe to Stathead Pro Football for full results.

Go inside the Pro Football 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.

Tom Brady vs. New Orleans Saints: Game Logs Table
							Passing																		Rushing
Rk	Date	Age	Team		Opp	Result	Cmp	Att	Inc	Cmp%	Yds	TD	Int	Pick6	TD%	Int%	Rate	Sk	Yds	Sk%	Y/A	AY/A	ANY/A	Y/C	Att	Yds	Y/A	TD	1D
1	2022-12-05	45-124	TAM		NOR	W, 17-16	36	54	18	66.7	281	2	1	0	3.7	1.9	84.0	1	7	1.82	5.2	5.11	4.89	7.8	1	-1	-1.0	0	0
2	2022-09-18	45-046	TAM	@	NOR	W, 20-10	18	34	16	52.9	190	1	0	0	2.9	0.0	79.3	1	2	2.86	5.6	6.18	5.94	10.6	3	-2	-0.7	0	0
3	2021-12-19	44-138	TAM		NOR	L, 0-9	26	48	22	54.2	214	0	1	0	0.0	2.1	57.1	4	30	7.69	4.5	3.52	2.67	8.2	1	2	2.0	0	0
4	2021-10-31	44-089	TAM	@	NOR	L, 27-36	28	40	12	70.0	375	4	2	1	10.0	5.0	112.0	3	25	6.98	9.4	9.13	7.91	13.4	1	2	2.0	0	1
5	2020-11-08	43-097	TAM		NOR	L, 3-38	22	38	16	57.9	209	0	3	0	0.0	7.9	40.4	3	23	7.32	5.5	1.95	1.24	9.5	0	0		0	0
6	2020-09-13	43-041	TAM	@	NOR	L, 23-34	23	36	13	63.9	239	2	2	1	5.6	5.6	78.4	3	15	7.69	6.6	5.25	4.46	10.4	3	9	3.0	1	2
7	2017-09-17	40-045	NWE	@	NOR	W, 36-20	30	39	9	76.9	447	3	0	0	7.7	0.0	139.6	2	11	4.88	11.5	13.00	12.10	14.9	2	9	4.5	0	1
8	2013-10-13	36-071	NWE		NOR	W, 30-27	25	43	18	58.1	269	1	1	0	2.3	2.3	74.7	5	34	10.42	6.3	5.67	4.38	10.8	2	16	8.0	0	1
9	2009-11-30	32-119	NWE	@	NOR	L, 17-38	21	36	15	58.3	237	0	2	0	0.0	5.6	55.0	1	4	2.70	6.6	4.08	3.86	11.3	1	2	2.0	0	1
10	2005-11-20	28-109	NWE		NOR	W, 24-17	15	29	14	51.7	222	3	0	0	10.3	0.0	111.6	3	28	9.38	7.7	9.72	7.94	14.8	1	5	5.0	0	1

Data coverage:

Player game data: since 1933. Scoring statistics (TD, XP, FG) are complete. Yardage and attempts statistics are nearly complete. Game participation data since 1970.

Player season data: all-time (since 1920). Scoring statistics (TD, XP, FG) are complete all-time. Yardage and attempts statistics were not recorded until 1932. Advanced stats since 2018.

Team Game data: since 1920. Before 1940, only wins, losses, points for, and points allowed are available. Scoring statistics (TD, XP, FG) are complete since 1920. Yardage and attempts statistics are nearly complete since 1933.

Team Season data: since 1940. Scoring statistics (TD, XP, FG) are complete all-time.

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.

Tom Brady vs. New Orleans Saints

Compare Players

Compare Teams

Player vs. Team

Search Criteria

Tom Brady vs. New Orleans Saints

Tom Brady vs. New Orleans Saints: Passing Totals

Tom Brady vs. New Orleans Saints: Passing Totals

Tom Brady vs. New Orleans Saints: Rushing & Receiving Totals

Tom Brady vs. New Orleans Saints: Rushing & Receiving Totals

Tom Brady vs. New Orleans Saints: Game Logs

Tom Brady vs. New Orleans Saints: Game Logs

Subscribe to Stathead Pro Football for full results.

Full Site Menu

FAQs, Tip & Tricks