Team Season Stats Finder - College Football

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

main

Page Setup Time: 0.00055 seconds

SELECT year_id as year_id_csk, year_id as year_id, ts.name_short as team_name_abbr, ts.link as team_link, comp_id, GROUP_CONCAT(DISTINCT sup_comp_seasons.name_abbr) as comp_name_abbr, SUM(games) AS games, SUM(wins) AS wins, SUM(losses) AS losses, SUM(ties) AS ties, SUM(IFNULL(wins,0) + 0.5 * IFNULL(ties,0)) / SUM(IFNULL(wins,0) + IFNULL(losses,0) + IFNULL(ties,0)) as win_loss_pct_csk, TRIM(LEADING '0' FROM ROUND(SUM(IFNULL(wins,0) + 0.5 * IFNULL(ties,0)) / SUM(IFNULL(wins,0) + IFNULL(losses,0) + IFNULL(ties,0)),3)) AS win_loss_pct, SUM(points) AS points, SUM(points_opp) AS points_opp, SUM(points - points_opp) AS points_diff
FROM sup_team_seasons as ts
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
  LEFT JOIN (SELECT parent_conf_id, conf_id, conf_name, conf_abbr, link, comp_id, year_id FROM sup_conference_seasons) as team_conf USING (conf_id, comp_id, year_id)
WHERE year_id>=?
  AND year_id<=?
  AND phase_id = 'season-total' 
GROUP BY year_id, team_id
ORDER BY wins DESC, year_id DESC, team_id LIMIT 0, 20

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

Query Time: 0.11 seconds
Table Build Time: 0.04 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'order_by' => 'wins',
          'year_min' => 1956,
          'match' => 'team_season',
          'year_max' => 2025,
          'phase_id' => 1
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'year_min' => 1956,
          'year_max' => 2025,
          'phase_id' => 1
        };