Aaron Donald vs. New England Patriots

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

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(sacks) as sacks_csk, ROUND(SUM(sacks),1) AS sacks, SUM(def_int) AS def_int, SUM(fumbles_rec) AS fumbles_rec
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(sacks) as sacks_csk, ROUND(SUM(sacks),1) AS sacks, SUM(def_int) AS def_int, SUM(fumbles_rec) AS fumbles_rec
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.sacks AS rspvt_sacks, popvt.sacks AS popvt_sacks, rspvt.def_int AS rspvt_def_int, popvt.def_int AS popvt_def_int, rspvt.fumbles_rec AS rspvt_fumbles_rec, popvt.fumbles_rec AS popvt_fumbles_rec
FROM rspvt
  JOIN popvt
WHERE 1  LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'DonaAa00',
          'nwe',
          'DonaAa00',
          'nwe'
        ];

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

pvt_defense

Page Setup Time: 0.00111 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(sacks) as sacks_csk, ROUND(SUM(sacks),1) AS sacks, SUM(tackles_solo) AS tackles_solo, SUM(tackles_assists) AS tackles_assists, SUM(tackles_combined) AS tackles_combined, SUM(tackles_loss) AS tackles_loss, SUM(qb_hits) AS qb_hits, SUM(def_int) AS def_int, SUM(def_int_yds) AS def_int_yds, SUM(def_int_td) AS def_int_td, SUM(pass_defended) AS pass_defended, SUM(fumbles) AS fumbles, SUM(fumbles_rec) AS fumbles_rec, SUM(fumbles_rec_yds) AS fumbles_rec_yds, SUM(fumbles_rec_td) AS fumbles_rec_td, SUM(fumbles_forced) AS fumbles_forced
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 = [
          'DonaAa00',
          'nwe'
        ];

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(sacks) as sacks_csk, ROUND(SUM(sacks),1) AS sacks, SUM(tackles_solo) AS tackles_solo, SUM(tackles_assists) AS tackles_assists, SUM(tackles_combined) AS tackles_combined, SUM(tackles_loss) AS tackles_loss, SUM(qb_hits) AS qb_hits, SUM(def_int) AS def_int, SUM(def_int_yds) AS def_int_yds, SUM(def_int_td) AS def_int_td, SUM(pass_defended) AS pass_defended, SUM(fumbles) AS fumbles, SUM(fumbles_rec) AS fumbles_rec, SUM(fumbles_rec_yds) AS fumbles_rec_yds, SUM(fumbles_rec_td) AS fumbles_rec_td, SUM(fumbles_forced) AS fumbles_forced
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 = [
          'DonaAa00',
          'nwe'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.08 seconds

Table Build Time: 0.04 seconds


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

pvt_gamelogs

Page Setup Time: 0.00145 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, sacks as sacks_csk, ROUND(sacks,1) AS sacks, tackles_solo, tackles_assists, tackles_combined, tackles_loss, qb_hits, def_int, def_int_yds, def_int_td, pass_defended, fumbles, fumbles_rec, fumbles_rec_yds, fumbles_rec_td, fumbles_forced
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 = [
          'DonaAa00',
          'nwe'
        ];

Query Time: 0.07 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, sacks as sacks_csk, ROUND(sacks,1) AS sacks, tackles_solo, tackles_assists, tackles_combined, tackles_loss, qb_hits, def_int, def_int_yds, def_int_td, pass_defended, fumbles, fumbles_rec, fumbles_rec_yds, fumbles_rec_td, fumbles_forced
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 = [
          'DonaAa00',
          'nwe'
        ];

Query Time: 0.07 seconds
Table Build Time: 0.07 seconds

Table Build Time: 0.10 seconds


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