Trevor Lawrence vs. Baker Mayfield: Head-to-Head Stats Comparison

Compare players and teams or see head to head results between teams, players, or player vs. team. Data Coverage
THIS QUESTION WAS ANSWERED USING
Stathead Football Logo POWERED BY Pro Football Reference Logo
Your All Access Pass to the Pro Football Database Go beyond the basics. Become a Stathead
Start Your FREE Trial
Display Query »
--------------------------------------

header_comp

WITH
  h2h_record AS (
SELECT p1.person_id as p1_person_id, SUM(p1.win  AND p1.type="reg")  as p1_rs_wins, SUM(p1.win  AND p1.type="post") as p1_po_wins, SUM(p1.loss AND p1.type="reg")  as p1_rs_losses, SUM(p1.loss AND p1.type="post") as p1_po_losses, SUM(p1.tie  AND p1.type="reg")  as p1_rs_ties, SUM(p1.tie  AND p1.type="post") as p1_po_ties, p2.person_id as p2_person_id, SUM(p2.win  AND p2.type="reg")  as p2_rs_wins, SUM(p2.win  AND p2.type="post") as p2_po_wins, SUM(p2.loss AND p2.type="reg")  as p2_rs_losses, SUM(p2.loss AND p2.type="post") as p2_po_losses, SUM(p2.tie  AND p2.type="reg")  as p2_rs_ties, SUM(p2.tie  AND p2.type="post") as p2_po_ties
FROM (SELECT person_id, win as win, loss as loss, tie as tie, game_id, type, team_id
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_player_games USING (game_id, team_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE person_id=?  ) as p1
  JOIN (SELECT person_id, win as win, loss as loss, tie as tie, game_id, type, team_id FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_player_games USING (game_id, team_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE person_id=?  ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
  ),
  h2h_record_tot AS (
SELECT person_id, rs_wins, rs_losses, rs_ties, po_wins, po_losses, po_ties
FROM (SELECT p1_person_id as person_id, p1_rs_wins as rs_wins, p1_rs_losses as rs_losses, p1_rs_ties as rs_ties, p1_po_wins as po_wins, p1_po_losses as po_losses, p1_po_ties as po_ties
FROM h2h_record
  UNION SELECT p2_person_id as person_id, p2_rs_wins as rs_wins, p2_rs_losses as rs_losses, p2_rs_ties as rs_ties, p2_po_wins as po_wins, p2_po_losses as po_losses, p2_po_ties as po_ties
FROM h2h_record) as zzz
WHERE 1  
  )
SELECT person_id, rs_wins, rs_losses, rs_ties, po_wins, po_losses, po_ties, SUM(games) AS games, SUM(av) AS av, IF(SUM(qb_w+qb_l+qb_t)=0,0,(SUM(qb_w)+(SUM(qb_t)*0.5)) / (SUM(qb_w+qb_l+qb_t))) as qb_rec_csk, CONCAT(SUM(qb_w),"-",SUM(qb_l),"-",SUM(qb_t)) AS qb_rec, 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, 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(games), SUM(pass_yds)/SUM(games), NULL) as pass_yds_per_g_csk, ROUND(IF(SUM(games), SUM(pass_yds)/SUM(games), NULL),1) AS pass_yds_per_g, SUM(pass_td) AS pass_td, SUM(pass_int) AS pass_int, 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(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(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
  LEFT JOIN h2h_record_tot USING (person_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'MayfBa00',
          'LawrTr00',
          'LawrTr00',
          'MayfBa00'
        ];
SELECT name_short, name, award_id FROM sup_awards WHERE award_id IN ("probowl","allpro","apmvp","apopoy","apdpoy","aafcmvp","appoy","upimvp","upipoy","upiopoy","upidpoy","sbmvp") GROUP BY award_id

SQL PARAMS -- $VAR1 = [];

WITH
  champ AS (
SELECT person_id, COUNT(*) as championships
FROM sup_player_team_seasons
  LEFT JOIN sup_team_seasons USING (team_id, year_id, comp_id, phase_id) 
WHERE person_id=? AND phase_id='reg' AND is_champion=1 
  ),
  awards AS (
SELECT person_id,
  SUM(award_id="aafcmvp") as `aafcmvp`, SUM(award_id="allpro") as `allpro`, SUM(award_id="apdpoy") as `apdpoy`, SUM(award_id="apmvp") as `apmvp`, SUM(award_id="apopoy") as `apopoy`, SUM(award_id="appoy") as `appoy`, SUM(award_id="probowl") as `probowl`, SUM(award_id="sbmvp") as `sbmvp`, SUM(award_id="upidpoy") as `upidpoy`, SUM(award_id="upimvp") as `upimvp`, SUM(award_id="upiopoy") as `upiopoy`, SUM(award_id="upipoy") as `upipoy`
FROM sup_awards_players
WHERE person_id=?  
  )
SELECT person_id, is_hof, championships, awards.* FROM sup_players
  LEFT JOIN awards USING (person_id)
  LEFT JOIN champ USING (person_id)
WHERE person_id=?


SQL PARAMS -- $VAR1 = [
          'MayfBa00',
          'MayfBa00',
          'MayfBa00'
        ];

WITH
  champ AS (
SELECT person_id, COUNT(*) as championships
FROM sup_player_team_seasons
  LEFT JOIN sup_team_seasons USING (team_id, year_id, comp_id, phase_id) 
WHERE person_id=? AND phase_id='reg' AND is_champion=1 
  ),
  awards AS (
SELECT person_id,
  SUM(award_id="aafcmvp") as `aafcmvp`, SUM(award_id="allpro") as `allpro`, SUM(award_id="apdpoy") as `apdpoy`, SUM(award_id="apmvp") as `apmvp`, SUM(award_id="apopoy") as `apopoy`, SUM(award_id="appoy") as `appoy`, SUM(award_id="probowl") as `probowl`, SUM(award_id="sbmvp") as `sbmvp`, SUM(award_id="upidpoy") as `upidpoy`, SUM(award_id="upimvp") as `upimvp`, SUM(award_id="upiopoy") as `upiopoy`, SUM(award_id="upipoy") as `upipoy`
FROM sup_awards_players
WHERE person_id=?  
  )
SELECT person_id, is_hof, championships, awards.* FROM sup_players
  LEFT JOIN awards USING (person_id)
  LEFT JOIN champ USING (person_id)
WHERE person_id=?


SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'LawrTr00',
          'LawrTr00'
        ];

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

h2h_sum_pass

Page Setup Time: 0.00216 seconds

WITH
  pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
  JOIN sup_player_games USING (game_id, team_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1  
  ),
  pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=?  ) as p1
  JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=?  ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
  )
SELECT person_id, COUNT(*) AS games, SUM(is_starter) AS games_started, 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, SUM(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  JOIN sup_games USING (game_id)
  JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
GROUP BY person_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'MayfBa00',
          'LawrTr00',
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.03 seconds
WITH
  pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
  JOIN sup_player_games USING (game_id, team_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1  
  ),
  pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=?  ) as p1
  JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=?  ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
  )
SELECT person_id, COUNT(*) AS games, SUM(is_starter) AS games_started, 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, SUM(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  JOIN sup_games USING (game_id)
  JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="post" 
GROUP BY person_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'MayfBa00',
          'LawrTr00',
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.03 seconds


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

h2h_sum_qbrush

Page Setup Time: 0.00055 seconds

WITH
  pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
  JOIN sup_player_games USING (game_id, team_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1  
  ),
  pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=?  ) as p1
  JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=?  ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
  )
SELECT person_id, COUNT(*) AS games, SUM(is_starter) AS games_started, 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(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  JOIN sup_games USING (game_id)
  JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
GROUP BY person_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'MayfBa00',
          'LawrTr00',
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.03 seconds
WITH
  pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
  JOIN sup_player_games USING (game_id, team_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1  
  ),
  pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=?  ) as p1
  JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=?  ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
  )
SELECT person_id, COUNT(*) AS games, SUM(is_starter) AS games_started, 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(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  JOIN sup_games USING (game_id)
  JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="post" 
GROUP BY person_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'MayfBa00',
          'LawrTr00',
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.03 seconds


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

h2h_gamelogs

Page Setup Time: 0.00212 seconds

WITH
  pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
  JOIN sup_player_games USING (game_id, team_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1  
  ),
  pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=?  ) as p1
  JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=?  ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
  )
SELECT person_id, ts.name_abbr as team_name_abbr, ts.link as team_link, game_id, date, sup_games.link as game_link, 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 (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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  JOIN sup_games USING (game_id)
  JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
ORDER BY date DESC, person_id LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'MayfBa00',
          'LawrTr00',
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.03 seconds
WITH
  pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
  JOIN sup_player_games USING (game_id, team_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1  
  ),
  pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=?  ) as p1
  JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=?  ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
  )
SELECT person_id, ts.name_abbr as team_name_abbr, ts.link as team_link, game_id, date, sup_games.link as game_link, 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
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  JOIN sup_games USING (game_id)
  JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="post" 
ORDER BY date DESC, person_id LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'MayfBa00',
          'LawrTr00',
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.03 seconds


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

player_comp_pass

Page Setup Time: 0.00221 seconds

SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(pass_cmp IS NULL) as pass_cmp_incomplete, SUM(pass_cmp) AS pass_cmp, SUM(pass_att IS NULL) as pass_att_incomplete, SUM(pass_att) AS pass_att, SUM(pass_att IS NULL)+SUM(pass_cmp IS NULL) as pass_inc_incomplete, (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, SUM(pass_att IS NULL)+SUM(pass_cmp IS NULL) as pass_cmp_pct_incomplete, ROUND(100 * (IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL)),1) AS pass_cmp_pct, SUM(pass_yds IS NULL) as pass_yds_incomplete, SUM(pass_yds) AS pass_yds, SUM(pass_td IS NULL) as pass_td_incomplete, SUM(pass_td) AS pass_td, SUM(pass_int IS NULL) as pass_int_incomplete, SUM(pass_int) AS pass_int, SUM(pass_int_td IS NULL) as pass_int_td_incomplete, SUM(pass_int_td) AS pass_int_td, IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL) as pass_td_pct_csk, SUM(pass_att IS NULL)+SUM(pass_td IS NULL) as pass_td_pct_incomplete, 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, SUM(pass_int IS NULL)+SUM(pass_att IS NULL) as pass_int_pct_incomplete, 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, SUM(pass_int IS NULL)+SUM(pass_td IS NULL)+SUM(pass_att IS NULL)+SUM(pass_yds IS NULL)+SUM(pass_cmp IS NULL) as pass_rating_incomplete, 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 IS NULL) as pass_sacked_incomplete, SUM(pass_sacked) AS pass_sacked, SUM(pass_sacked_yds IS NULL) as pass_sacked_yds_incomplete, 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, SUM(pass_att IS NULL)+SUM(pass_sacked IS NULL) as pass_sacked_pct_incomplete, 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, SUM(pass_att IS NULL)+SUM(pass_yds IS NULL) as pass_yds_per_att_incomplete, 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, SUM(pass_td IS NULL)+SUM(pass_int IS NULL)+SUM(pass_att IS NULL)+SUM(pass_yds IS NULL) as pass_adj_yds_per_att_incomplete, 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, SUM(pass_yds IS NULL)+SUM(pass_att IS NULL)+SUM(pass_sacked IS NULL)+SUM(pass_sacked_yds IS NULL)+SUM(pass_int IS NULL)+SUM(pass_td IS NULL) as pass_adj_net_yds_per_att_incomplete, 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, SUM(pass_cmp IS NULL)+SUM(pass_yds IS NULL) as pass_yds_per_cmp_incomplete, ROUND(IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL),1) AS pass_yds_per_cmp, SUM(av IS NULL) as av_incomplete, SUM(av) AS av, SUM(fantasy_points) as fantasy_points_csk, SUM(fantasy_points IS NULL) as fantasy_points_incomplete, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.01 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(pass_cmp IS NULL) as pass_cmp_incomplete, SUM(pass_cmp) AS pass_cmp, SUM(pass_att IS NULL) as pass_att_incomplete, SUM(pass_att) AS pass_att, SUM(pass_att IS NULL)+SUM(pass_cmp IS NULL) as pass_inc_incomplete, (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, SUM(pass_att IS NULL)+SUM(pass_cmp IS NULL) as pass_cmp_pct_incomplete, ROUND(100 * (IF(SUM(pass_att), SUM(pass_cmp)/SUM(pass_att), NULL)),1) AS pass_cmp_pct, SUM(pass_yds IS NULL) as pass_yds_incomplete, SUM(pass_yds) AS pass_yds, SUM(pass_td IS NULL) as pass_td_incomplete, SUM(pass_td) AS pass_td, SUM(pass_int IS NULL) as pass_int_incomplete, SUM(pass_int) AS pass_int, SUM(pass_int_td IS NULL) as pass_int_td_incomplete, SUM(pass_int_td) AS pass_int_td, IF(SUM(pass_att), SUM(pass_td)/SUM(pass_att), NULL) as pass_td_pct_csk, SUM(pass_att IS NULL)+SUM(pass_td IS NULL) as pass_td_pct_incomplete, 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, SUM(pass_int IS NULL)+SUM(pass_att IS NULL) as pass_int_pct_incomplete, 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, SUM(pass_int IS NULL)+SUM(pass_td IS NULL)+SUM(pass_att IS NULL)+SUM(pass_yds IS NULL)+SUM(pass_cmp IS NULL) as pass_rating_incomplete, 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 IS NULL) as pass_sacked_incomplete, SUM(pass_sacked) AS pass_sacked, SUM(pass_sacked_yds IS NULL) as pass_sacked_yds_incomplete, 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, SUM(pass_att IS NULL)+SUM(pass_sacked IS NULL) as pass_sacked_pct_incomplete, 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, SUM(pass_att IS NULL)+SUM(pass_yds IS NULL) as pass_yds_per_att_incomplete, 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, SUM(pass_td IS NULL)+SUM(pass_int IS NULL)+SUM(pass_att IS NULL)+SUM(pass_yds IS NULL) as pass_adj_yds_per_att_incomplete, 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, SUM(pass_yds IS NULL)+SUM(pass_att IS NULL)+SUM(pass_sacked IS NULL)+SUM(pass_sacked_yds IS NULL)+SUM(pass_int IS NULL)+SUM(pass_td IS NULL) as pass_adj_net_yds_per_att_incomplete, 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, SUM(pass_cmp IS NULL)+SUM(pass_yds IS NULL) as pass_yds_per_cmp_incomplete, ROUND(IF(SUM(pass_cmp), SUM(pass_yds)/SUM(pass_cmp), NULL),1) AS pass_yds_per_cmp, SUM(av IS NULL) as av_incomplete, SUM(av) AS av, SUM(fantasy_points) as fantasy_points_csk, SUM(fantasy_points IS NULL) as fantasy_points_incomplete, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="post" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.03 seconds

Table Build Time: 0.03 seconds


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

player_comp_qbrush

Page Setup Time: 0.00063 seconds

SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(rush_att IS NULL) as rush_att_incomplete, SUM(rush_att) AS rush_att, SUM(rush_yds IS NULL) as rush_yds_incomplete, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, SUM(rush_yds IS NULL)+SUM(rush_att IS NULL) as rush_yds_per_att_incomplete, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td IS NULL) as rush_td_incomplete, SUM(rush_td) AS rush_td, SUM(rush_first_down IS NULL) as rush_first_down_incomplete, SUM(rush_first_down) AS rush_first_down, SUM(av IS NULL) as av_incomplete, SUM(av) AS av, SUM(fantasy_points) as fantasy_points_csk, SUM(fantasy_points IS NULL) as fantasy_points_incomplete, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(rush_att IS NULL) as rush_att_incomplete, SUM(rush_att) AS rush_att, SUM(rush_yds IS NULL) as rush_yds_incomplete, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, SUM(rush_yds IS NULL)+SUM(rush_att IS NULL) as rush_yds_per_att_incomplete, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td IS NULL) as rush_td_incomplete, SUM(rush_td) AS rush_td, SUM(rush_first_down IS NULL) as rush_first_down_incomplete, SUM(rush_first_down) AS rush_first_down, SUM(av IS NULL) as av_incomplete, SUM(av) AS av, SUM(fantasy_points) as fantasy_points_csk, SUM(fantasy_points IS NULL) as fantasy_points_incomplete, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="post" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.03 seconds

Table Build Time: 0.03 seconds


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

player_comp_pass_adv1

Page Setup Time: 0.00078 seconds

SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(pass_target_yds IS NULL) as pass_target_yds_incomplete, SUM(pass_target_yds) AS pass_target_yds, SUM(pass_target_yds)/SUM(pass_att) as pass_tgt_yds_per_att_csk, SUM(pass_target_yds IS NULL)+SUM(pass_att IS NULL) as pass_tgt_yds_per_att_incomplete, ROUND(SUM(pass_target_yds)/SUM(pass_att),1) AS pass_tgt_yds_per_att, SUM(pass_air_yds IS NULL) as pass_air_yds_incomplete, SUM(pass_air_yds) AS pass_air_yds, SUM(pass_air_yds)/SUM(pass_cmp) as pass_air_yds_per_cmp_csk, SUM(pass_air_yds IS NULL)+SUM(pass_cmp IS NULL) as pass_air_yds_per_cmp_incomplete, ROUND(SUM(pass_air_yds)/SUM(pass_cmp),1) AS pass_air_yds_per_cmp, SUM(pass_air_yds)/SUM(pass_att) as pass_air_yds_per_att_csk, SUM(pass_air_yds IS NULL)+SUM(pass_att IS NULL) as pass_air_yds_per_att_incomplete, ROUND(SUM(pass_air_yds)/SUM(pass_att),1) AS pass_air_yds_per_att, SUM(pass_yds IS NULL)+SUM(pass_air_yds IS NULL) as pass_yac_incomplete, SUM(pass_yds)-SUM(pass_air_yds) AS pass_yac, (SUM(pass_yds)-SUM(pass_air_yds))/SUM(pass_cmp) as pass_yac_per_cmp_csk, SUM(pass_air_yds IS NULL)+SUM(pass_cmp IS NULL)+SUM(pass_yds IS NULL) as pass_yac_per_cmp_incomplete, ROUND((SUM(pass_yds)-SUM(pass_air_yds))/SUM(pass_cmp),1) AS pass_yac_per_cmp
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(pass_target_yds IS NULL) as pass_target_yds_incomplete, SUM(pass_target_yds) AS pass_target_yds, SUM(pass_target_yds)/SUM(pass_att) as pass_tgt_yds_per_att_csk, SUM(pass_target_yds IS NULL)+SUM(pass_att IS NULL) as pass_tgt_yds_per_att_incomplete, ROUND(SUM(pass_target_yds)/SUM(pass_att),1) AS pass_tgt_yds_per_att, SUM(pass_air_yds IS NULL) as pass_air_yds_incomplete, SUM(pass_air_yds) AS pass_air_yds, SUM(pass_air_yds)/SUM(pass_cmp) as pass_air_yds_per_cmp_csk, SUM(pass_air_yds IS NULL)+SUM(pass_cmp IS NULL) as pass_air_yds_per_cmp_incomplete, ROUND(SUM(pass_air_yds)/SUM(pass_cmp),1) AS pass_air_yds_per_cmp, SUM(pass_air_yds)/SUM(pass_att) as pass_air_yds_per_att_csk, SUM(pass_air_yds IS NULL)+SUM(pass_att IS NULL) as pass_air_yds_per_att_incomplete, ROUND(SUM(pass_air_yds)/SUM(pass_att),1) AS pass_air_yds_per_att, SUM(pass_yds IS NULL)+SUM(pass_air_yds IS NULL) as pass_yac_incomplete, SUM(pass_yds)-SUM(pass_air_yds) AS pass_yac, (SUM(pass_yds)-SUM(pass_air_yds))/SUM(pass_cmp) as pass_yac_per_cmp_csk, SUM(pass_air_yds IS NULL)+SUM(pass_cmp IS NULL)+SUM(pass_yds IS NULL) as pass_yac_per_cmp_incomplete, ROUND((SUM(pass_yds)-SUM(pass_air_yds))/SUM(pass_cmp),1) AS pass_yac_per_cmp
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="post" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.03 seconds

Table Build Time: 0.03 seconds


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

player_comp_pass_adv2

Page Setup Time: 0.00120 seconds

SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(pass_batted_passes IS NULL) as pass_batted_passes_incomplete, SUM(pass_batted_passes) AS pass_batted_passes, SUM(pass_throwaways IS NULL) as pass_throwaways_incomplete, SUM(pass_throwaways) AS pass_throwaways, SUM(pass_spikes IS NULL) as pass_spikes_incomplete, SUM(pass_spikes) AS pass_spikes, SUM(pass_drops IS NULL) as pass_drops_incomplete, SUM(pass_drops) AS pass_drops, SUM(pass_drops)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways)) as pass_drop_pct_csk, SUM(pass_spikes IS NULL)+SUM(pass_drops IS NULL)+SUM(pass_att IS NULL)+SUM(pass_throwaways IS NULL) as pass_drop_pct_incomplete, ROUND(100 * (SUM(pass_drops)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways))),1) AS pass_drop_pct, SUM(pass_poor_throws IS NULL) as pass_poor_throws_incomplete, SUM(pass_poor_throws) AS pass_poor_throws, SUM(pass_poor_throws)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways)) as pass_poor_throw_pct_csk, SUM(pass_throwaways IS NULL)+SUM(pass_att IS NULL)+SUM(pass_poor_throws IS NULL)+SUM(pass_spikes IS NULL) as pass_poor_throw_pct_incomplete, ROUND(100 * (SUM(pass_poor_throws)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways))),1) AS pass_poor_throw_pct, SUM(pass_on_target IS NULL) as pass_on_target_incomplete, SUM(pass_on_target) AS pass_on_target, SUM(pass_on_target)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways)) as pass_on_target_pct_csk, SUM(pass_throwaways IS NULL)+SUM(pass_att IS NULL)+SUM(pass_on_target IS NULL)+SUM(pass_spikes IS NULL) as pass_on_target_pct_incomplete, ROUND(100 * (SUM(pass_on_target)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways))),1) AS pass_on_target_pct
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(pass_batted_passes IS NULL) as pass_batted_passes_incomplete, SUM(pass_batted_passes) AS pass_batted_passes, SUM(pass_throwaways IS NULL) as pass_throwaways_incomplete, SUM(pass_throwaways) AS pass_throwaways, SUM(pass_spikes IS NULL) as pass_spikes_incomplete, SUM(pass_spikes) AS pass_spikes, SUM(pass_drops IS NULL) as pass_drops_incomplete, SUM(pass_drops) AS pass_drops, SUM(pass_drops)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways)) as pass_drop_pct_csk, SUM(pass_spikes IS NULL)+SUM(pass_drops IS NULL)+SUM(pass_att IS NULL)+SUM(pass_throwaways IS NULL) as pass_drop_pct_incomplete, ROUND(100 * (SUM(pass_drops)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways))),1) AS pass_drop_pct, SUM(pass_poor_throws IS NULL) as pass_poor_throws_incomplete, SUM(pass_poor_throws) AS pass_poor_throws, SUM(pass_poor_throws)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways)) as pass_poor_throw_pct_csk, SUM(pass_throwaways IS NULL)+SUM(pass_att IS NULL)+SUM(pass_poor_throws IS NULL)+SUM(pass_spikes IS NULL) as pass_poor_throw_pct_incomplete, ROUND(100 * (SUM(pass_poor_throws)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways))),1) AS pass_poor_throw_pct, SUM(pass_on_target IS NULL) as pass_on_target_incomplete, SUM(pass_on_target) AS pass_on_target, SUM(pass_on_target)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways)) as pass_on_target_pct_csk, SUM(pass_throwaways IS NULL)+SUM(pass_att IS NULL)+SUM(pass_on_target IS NULL)+SUM(pass_spikes IS NULL) as pass_on_target_pct_incomplete, ROUND(100 * (SUM(pass_on_target)/(SUM(pass_att)-SUM(pass_spikes)-SUM(pass_throwaways))),1) AS pass_on_target_pct
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="post" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.03 seconds

Table Build Time: 0.03 seconds


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

player_comp_pass_adv3

Page Setup Time: 0.00091 seconds

SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, avg(pocket_time) as pocket_time_csk, SUM(pocket_time IS NULL) as pocket_time_incomplete, ROUND(avg(pocket_time),1) AS pocket_time, SUM(pass_blitzed IS NULL) as pass_blitzed_incomplete, SUM(pass_blitzed) AS pass_blitzed, SUM(pass_hurried IS NULL) as pass_hurried_incomplete, SUM(pass_hurried) AS pass_hurried, SUM(pass_knockdowns IS NULL) as pass_hits_incomplete, SUM(pass_knockdowns) AS pass_hits, SUM(pass_knockdowns IS NULL)+SUM(pass_hurried IS NULL)+SUM(pass_sacked IS NULL) as pass_pressured_incomplete, SUM(pass_sacked)+SUM(pass_hurried)+SUM(pass_knockdowns) AS pass_pressured, (SUM(pass_sacked)+SUM(pass_hurried)+SUM(pass_knockdowns))/SUM(pass_dropbacks) as pass_pressured_pct_csk, SUM(pass_dropbacks IS NULL)+SUM(pass_hurried IS NULL)+SUM(pass_sacked IS NULL)+SUM(pass_knockdowns IS NULL) as pass_pressured_pct_incomplete, ROUND(100 * ((SUM(pass_sacked)+SUM(pass_hurried)+SUM(pass_knockdowns))/SUM(pass_dropbacks)),1) AS pass_pressured_pct, SUM(rush_scrambles IS NULL) as rush_scrambles_incomplete, SUM(rush_scrambles) AS rush_scrambles, SUM(rush_scrambles_yds)/SUM(rush_scrambles) as rush_scrambles_yds_per_att_csk, SUM(rush_scrambles_yds IS NULL)+SUM(rush_scrambles IS NULL) as rush_scrambles_yds_per_att_incomplete, ROUND(SUM(rush_scrambles_yds)/SUM(rush_scrambles),1) AS rush_scrambles_yds_per_att
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, avg(pocket_time) as pocket_time_csk, SUM(pocket_time IS NULL) as pocket_time_incomplete, ROUND(avg(pocket_time),1) AS pocket_time, SUM(pass_blitzed IS NULL) as pass_blitzed_incomplete, SUM(pass_blitzed) AS pass_blitzed, SUM(pass_hurried IS NULL) as pass_hurried_incomplete, SUM(pass_hurried) AS pass_hurried, SUM(pass_knockdowns IS NULL) as pass_hits_incomplete, SUM(pass_knockdowns) AS pass_hits, SUM(pass_knockdowns IS NULL)+SUM(pass_hurried IS NULL)+SUM(pass_sacked IS NULL) as pass_pressured_incomplete, SUM(pass_sacked)+SUM(pass_hurried)+SUM(pass_knockdowns) AS pass_pressured, (SUM(pass_sacked)+SUM(pass_hurried)+SUM(pass_knockdowns))/SUM(pass_dropbacks) as pass_pressured_pct_csk, SUM(pass_dropbacks IS NULL)+SUM(pass_hurried IS NULL)+SUM(pass_sacked IS NULL)+SUM(pass_knockdowns IS NULL) as pass_pressured_pct_incomplete, ROUND(100 * ((SUM(pass_sacked)+SUM(pass_hurried)+SUM(pass_knockdowns))/SUM(pass_dropbacks)),1) AS pass_pressured_pct, SUM(rush_scrambles IS NULL) as rush_scrambles_incomplete, SUM(rush_scrambles) AS rush_scrambles, SUM(rush_scrambles_yds)/SUM(rush_scrambles) as rush_scrambles_yds_per_att_csk, SUM(rush_scrambles_yds IS NULL)+SUM(rush_scrambles IS NULL) as rush_scrambles_yds_per_att_incomplete, ROUND(SUM(rush_scrambles_yds)/SUM(rush_scrambles),1) AS rush_scrambles_yds_per_att
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="post" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.03 seconds

Table Build Time: 0.03 seconds


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

player_comp_pass_adv4

Page Setup Time: 0.00078 seconds

SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(pass_rpo IS NULL) as pass_rpo_incomplete, SUM(pass_rpo) AS pass_rpo, SUM(pass_rpo_rush_yds IS NULL)+SUM(pass_rpo_pass_yds IS NULL) as pass_rpo_yds_incomplete, SUM(pass_rpo_pass_yds)+SUM(pass_rpo_rush_yds) AS pass_rpo_yds, SUM(pass_rpo_pass_att IS NULL) as pass_rpo_pass_att_incomplete, SUM(pass_rpo_pass_att) AS pass_rpo_pass_att, SUM(pass_rpo_pass_yds IS NULL) as pass_rpo_pass_yds_incomplete, SUM(pass_rpo_pass_yds) AS pass_rpo_pass_yds, SUM(pass_rpo_rush_att IS NULL) as pass_rpo_rush_att_incomplete, SUM(pass_rpo_rush_att) AS pass_rpo_rush_att, SUM(pass_rpo_rush_yds IS NULL) as pass_rpo_rush_yds_incomplete, SUM(pass_rpo_rush_yds) AS pass_rpo_rush_yds, SUM(pass_play_action IS NULL) as pass_play_action_incomplete, SUM(pass_play_action) AS pass_play_action, SUM(pass_play_action_pass_yds IS NULL) as pass_play_action_pass_yds_incomplete, SUM(pass_play_action_pass_yds) AS pass_play_action_pass_yds
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(pass_rpo IS NULL) as pass_rpo_incomplete, SUM(pass_rpo) AS pass_rpo, SUM(pass_rpo_rush_yds IS NULL)+SUM(pass_rpo_pass_yds IS NULL) as pass_rpo_yds_incomplete, SUM(pass_rpo_pass_yds)+SUM(pass_rpo_rush_yds) AS pass_rpo_yds, SUM(pass_rpo_pass_att IS NULL) as pass_rpo_pass_att_incomplete, SUM(pass_rpo_pass_att) AS pass_rpo_pass_att, SUM(pass_rpo_pass_yds IS NULL) as pass_rpo_pass_yds_incomplete, SUM(pass_rpo_pass_yds) AS pass_rpo_pass_yds, SUM(pass_rpo_rush_att IS NULL) as pass_rpo_rush_att_incomplete, SUM(pass_rpo_rush_att) AS pass_rpo_rush_att, SUM(pass_rpo_rush_yds IS NULL) as pass_rpo_rush_yds_incomplete, SUM(pass_rpo_rush_yds) AS pass_rpo_rush_yds, SUM(pass_play_action IS NULL) as pass_play_action_incomplete, SUM(pass_play_action) AS pass_play_action, SUM(pass_play_action_pass_yds IS NULL) as pass_play_action_pass_yds_incomplete, SUM(pass_play_action_pass_yds) AS pass_play_action_pass_yds
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="post" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.03 seconds

Table Build Time: 0.03 seconds


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

player_comp_adv_rush

Page Setup Time: 0.00073 seconds

SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(rush_yds IS NULL)+SUM(rush_yac IS NULL) as rush_yds_before_contact_incomplete, SUM(rush_yds)-SUM(rush_yac) AS rush_yds_before_contact, (SUM(rush_yds)-SUM(rush_yac))/SUM(rush_att) as rush_yds_bc_per_rush_csk, SUM(rush_yac IS NULL)+SUM(rush_att IS NULL)+SUM(rush_yds IS NULL) as rush_yds_bc_per_rush_incomplete, ROUND((SUM(rush_yds)-SUM(rush_yac))/SUM(rush_att),1) AS rush_yds_bc_per_rush, SUM(rush_yac IS NULL) as rush_yac_incomplete, SUM(rush_yac) AS rush_yac, SUM(rush_yac)/SUM(rush_att) as rush_yac_per_rush_csk, SUM(rush_att IS NULL)+SUM(rush_yac IS NULL) as rush_yac_per_rush_incomplete, ROUND(SUM(rush_yac)/SUM(rush_att),1) AS rush_yac_per_rush, SUM(rush_broken_tackles IS NULL) as rush_broken_tackles_incomplete, SUM(rush_broken_tackles) AS rush_broken_tackles, SUM(rush_att)/SUM(rush_broken_tackles) as rush_broken_tackles_per_rush_csk, SUM(rush_att IS NULL)+SUM(rush_broken_tackles IS NULL) as rush_broken_tackles_per_rush_incomplete, ROUND(SUM(rush_att)/SUM(rush_broken_tackles),1) AS rush_broken_tackles_per_rush
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(rush_yds IS NULL)+SUM(rush_yac IS NULL) as rush_yds_before_contact_incomplete, SUM(rush_yds)-SUM(rush_yac) AS rush_yds_before_contact, (SUM(rush_yds)-SUM(rush_yac))/SUM(rush_att) as rush_yds_bc_per_rush_csk, SUM(rush_yac IS NULL)+SUM(rush_att IS NULL)+SUM(rush_yds IS NULL) as rush_yds_bc_per_rush_incomplete, ROUND((SUM(rush_yds)-SUM(rush_yac))/SUM(rush_att),1) AS rush_yds_bc_per_rush, SUM(rush_yac IS NULL) as rush_yac_incomplete, SUM(rush_yac) AS rush_yac, SUM(rush_yac)/SUM(rush_att) as rush_yac_per_rush_csk, SUM(rush_att IS NULL)+SUM(rush_yac IS NULL) as rush_yac_per_rush_incomplete, ROUND(SUM(rush_yac)/SUM(rush_att),1) AS rush_yac_per_rush, SUM(rush_broken_tackles IS NULL) as rush_broken_tackles_incomplete, SUM(rush_broken_tackles) AS rush_broken_tackles, SUM(rush_att)/SUM(rush_broken_tackles) as rush_broken_tackles_per_rush_csk, SUM(rush_att IS NULL)+SUM(rush_broken_tackles IS NULL) as rush_broken_tackles_per_rush_incomplete, ROUND(SUM(rush_att)/SUM(rush_broken_tackles),1) AS rush_broken_tackles_per_rush
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="post" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.03 seconds


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

player_comp_snaps

Page Setup Time: 0.00108 seconds

SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(snap_counts_offense IS NULL) as snaps_offense_incomplete, SUM(snap_counts_offense) AS snaps_offense, SUM(snap_counts_offense)/SUM(team_snap_counts_off) as snaps_off_pct_csk, SUM(team_snap_counts_off IS NULL)+SUM(snap_counts_offense IS NULL) as snaps_off_pct_incomplete, ROUND(100 * (SUM(snap_counts_offense)/SUM(team_snap_counts_off)),1) AS snaps_off_pct, SUM(snap_counts_defense IS NULL) as snaps_defense_incomplete, SUM(snap_counts_defense) AS snaps_defense, SUM(snap_counts_defense)/SUM(team_snap_counts_def) as snaps_def_pct_csk, SUM(team_snap_counts_def IS NULL)+SUM(snap_counts_defense IS NULL) as snaps_def_pct_incomplete, ROUND(100 * (SUM(snap_counts_defense)/SUM(team_snap_counts_def)),1) AS snaps_def_pct, SUM(snap_counts_special_teams IS NULL) as snaps_special_teams_incomplete, SUM(snap_counts_special_teams) AS snaps_special_teams, SUM(snap_counts_special_teams)/SUM(team_snap_counts_st) as snaps_st_pct_csk, SUM(snap_counts_special_teams IS NULL)+SUM(team_snap_counts_st IS NULL) as snaps_st_pct_incomplete, ROUND(100 * (SUM(snap_counts_special_teams)/SUM(team_snap_counts_st)),1) AS snaps_st_pct
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
  LEFT JOIN (SELECT team_id, year_id, phase_id, snap_counts_offense as team_snap_counts_off, snap_counts_defense as team_snap_counts_def, snap_counts_special_teams as team_snap_counts_st FROM sup_team_seasons) as tg_snap_counts USING (year_id, team_id, phase_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="reg" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(snap_counts_offense IS NULL) as snaps_offense_incomplete, SUM(snap_counts_offense) AS snaps_offense, SUM(snap_counts_offense)/SUM(team_snap_counts_off) as snaps_off_pct_csk, SUM(team_snap_counts_off IS NULL)+SUM(snap_counts_offense IS NULL) as snaps_off_pct_incomplete, ROUND(100 * (SUM(snap_counts_offense)/SUM(team_snap_counts_off)),1) AS snaps_off_pct, SUM(snap_counts_defense IS NULL) as snaps_defense_incomplete, SUM(snap_counts_defense) AS snaps_defense, SUM(snap_counts_defense)/SUM(team_snap_counts_def) as snaps_def_pct_csk, SUM(team_snap_counts_def IS NULL)+SUM(snap_counts_defense IS NULL) as snaps_def_pct_incomplete, ROUND(100 * (SUM(snap_counts_defense)/SUM(team_snap_counts_def)),1) AS snaps_def_pct, SUM(snap_counts_special_teams IS NULL) as snaps_special_teams_incomplete, SUM(snap_counts_special_teams) AS snaps_special_teams, SUM(snap_counts_special_teams)/SUM(team_snap_counts_st) as snaps_st_pct_csk, SUM(snap_counts_special_teams IS NULL)+SUM(team_snap_counts_st IS NULL) as snaps_st_pct_incomplete, ROUND(100 * (SUM(snap_counts_special_teams)/SUM(team_snap_counts_st)),1) AS snaps_st_pct
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
  LEFT JOIN (SELECT team_id, year_id, phase_id, snap_counts_offense as team_snap_counts_off, snap_counts_defense as team_snap_counts_def, snap_counts_special_teams as team_snap_counts_st FROM sup_team_seasons) as tg_snap_counts USING (year_id, team_id, phase_id)
WHERE ((person_id=?) OR (person_id=?))
  AND type="post" 
GROUP BY person_id
ORDER BY person_id 

SQL PARAMS -- $VAR1 = [
          'LawrTr00',
          'MayfBa00'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.03 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'player_id2' => 'MayfBa00',
          'player_id1' => 'LawrTr00',
          'match' => 'versus_playervplayer'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'player_id1' => 'LawrTr00',
          'player_id2' => 'MayfBa00'
        };
Show Criteria
➦Share Results

Search Criteria

Seasons
Player 1
Javascript is required for the selection of a player.
Choice is: Trevor Lawrence 
Player 2
Javascript is required for the selection of a player.
Choice is: Baker Mayfield 
Player 3
Javascript is required for the selection of a player.
Player 4
Javascript is required for the selection of a player.
Player 5
Javascript is required for the selection of a player.
Player 6
Javascript is required for the selection of a player.
Team 1
Team 2

Clear All

You have edited your search criteria

or keep editing your search

clear changes

Head-to-Head
0-1
Reg Season
1-0
Overall Stats
 72 
 41 
 30-42-0 
 62.7 
 16451 
 6.8 
 228.5 
 85 
 57 
 84.5 
 288 
 1318 
 4.6 
 19 
 1099.2 
G
AV
QBrec
Cmp%
Pass Yds
Pass Y/A
Pass Y/G
Pass TD
Int
Rate
Rush Att
Rush Yds
Rush Y/A
Rush TD
FantPt
 118 
 81 
 57-58-0 
 63.5 
 27432 
 7.3 
 232.5 
 190 
 95 
 91.5 
 348 
 1444 
 4.1 
 11 
 1857.4 
Awards & Honors
 
1
Championships
Pro Bowl
 
2

Trevor Lawrence vs. Baker Mayfield: Head-to-Head Stats

Trevor Lawrence vs. Baker Mayfield: Passing Totals

Regular Season

Trevor Lawrence vs. Baker Mayfield: Rushing Totals

Regular Season

Trevor Lawrence vs. Baker Mayfield: 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.

Trevor Lawrence vs. Baker Mayfield: Player Comparison

Trevor Lawrence vs. Baker Mayfield: Passing Totals

Regular Season

Trevor Lawrence vs. Baker Mayfield: Rushing Totals

Regular Season

Trevor Lawrence vs. Baker Mayfield: Advanced Passing: Air Yards

Regular Season

Trevor Lawrence vs. Baker Mayfield: Advanced Passing: Accuracy

Regular Season

Trevor Lawrence vs. Baker Mayfield: Advanced Passing: Pressure

Regular Season

Trevor Lawrence vs. Baker Mayfield: Advanced Passing: Play Type

Regular Season

Trevor Lawrence vs. Baker Mayfield: Advanced Rushing

Regular Season

Trevor Lawrence vs. Baker Mayfield: Snap Counts

Regular Season

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.