Team Game Stats Finder - College Football

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

main

Page Setup Time: 0.00147 seconds

SELECT ts.name_short as team_name_abbr, ts.link as team_link, IFNULL(os.name_short,(SELECT IFNULL(name_short,name) FROM sup_teams WHERE sup_teams.team_id=opp_team_id)) as opp_name_abbr, os.opp_team_link as opp_team_link, date, game_id, 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, sup_games.link as game_link, comp_id, LEFT(dayname(`date`), 3) as game_day_of_week, team_game_num_season as game_num, 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, 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 > 0, (8.4 * pass_yds + 330 * pass_td - 200 * pass_int + 100 * pass_cmp) / pass_att, NULL) as pass_rating_csk, ROUND(IF(pass_att > 0, (8.4 * pass_yds + 330 * pass_td - 200 * pass_int + 100 * pass_cmp) / pass_att, NULL),1) AS pass_rating, 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_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_team_games as st
  JOIN sup_games USING (game_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, name_short, conf_id as season_conf_id FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  LEFT JOIN (SELECT team_id as opp_team_id, link as opp_team_link, year_id, name_abbr, name_short, conf_id as opp_season_conf_id FROM sup_team_seasons GROUP BY team_id, year_id ) as os USING (opp_team_id, year_id)
  LEFT JOIN (SELECT parent_conf_id, conf_id as season_conf_id, conf_name, conf_abbr, link, comp_id, year_id FROM sup_conference_seasons) as team_conf USING (season_conf_id, comp_id, year_id)
  LEFT JOIN (SELECT parent_conf_id as opp_parent_conf_id, conf_id as opp_season_conf_id, conf_name, conf_abbr, link, comp_id, year_id FROM sup_conference_seasons) as opp_team_conf USING (opp_season_conf_id, comp_id, year_id)
WHERE sup_games.status = 'Played'
  AND year_id>=?
  AND year_id<=?
  AND date < current_date() 
ORDER BY pass_td DESC, date DESC, team_id LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          2025,
          2025
        ];

Query Time: 0.38 seconds
Table Build Time: 0.04 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'game_status' => 1,
          'team_game_min' => 1,
          'team_game_max' => 16,
          'timeframe' => 'seasons',
          'match' => 'team_game',
          'year_min' => 2025,
          'order_by' => 'pass_td',
          'year_max' => 2025
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'game_status' => 1,
          'year_max' => 2025,
          'year_min' => 2025
        };