Team Season Stats Finder - FBref

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

main

Page Setup Time: 0.00120 seconds

SELECT year_id as year_id_csk, year_id as year_id, IFNULL(ts.name_short, ts.name) as team_name_abbr, ts.link as team_link, comp_id, IF(COUNT(DISTINCT sup_comps.comp_id) > 1, CONCAT(COUNT(DISTINCT sup_comps.comp_id), ' Comps'), GROUP_CONCAT(DISTINCT sup_comps.name)) as comp_name_abbr_csk, IF(COUNT(DISTINCT sup_comps.comp_id) > 1, CONCAT(COUNT(DISTINCT sup_comps.comp_id), ' Comps'), GROUP_CONCAT(DISTINCT sup_comps.name)) as comp_name_abbr, is_big5, SUM(games) AS games, SUM(wins) AS wins, SUM(ties) AS ties, SUM(losses) AS losses, SUM(points) AS points, SUM(points) / SUM(games) as points_avg_csk, ROUND(SUM(points) / SUM(games),2) AS points_avg, SUM(minutes) AS minutes, SUM(games_sub) AS games_subs, CAST(`rank` AS unsigned) AS lg_finish, SUM(goals_for) AS goals_for, SUM(goals_against) AS goals_against, (SUM(goals_for) - SUM(goals_against)) AS goal_diff, AVG(possession) as possession_csk, ROUND(AVG(possession),1) AS possession, SUM(gk_clean_sheets) AS gk_clean_sheets, IF(games, ROUND(SUM(gk_clean_sheets)/SUM(games)*100,1), NULL) as clean_sheets_pct_csk, ROUND(IF(games, ROUND(SUM(gk_clean_sheets)/SUM(games)*100,1), NULL),1) AS clean_sheets_pct, SUM(goals - pens_made) AS goals_pens, SUM(pens_made) AS pens_made, SUM(pens_att) AS pens_att, SUM((pens_att IS NOT NULL AND pens_made IS NOT NULL)*pens_att) - SUM((pens_att IS NOT NULL AND pens_made IS NOT NULL)*pens_made) AS pens_missed, IF(COUNT(DISTINCT sup_comps.comp_id) > 1, '', comp_flag) AS comp_name_abbr_flag, SUM(minutes) / 90 as minutes_90s_csk, ROUND(SUM(minutes) / 90,1) AS minutes_90s
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)
  JOIN sup_comps USING (comp_id)
  JOIN sup_approved_comp_seasons USING (comp_id, year_id)
  JOIN sup_teams USING (team_id)
  LEFT JOIN (SELECT org_id AS governing_org, fifa_id, flag AS comp_flag FROM orgs
  JOIN fifa_members USING (fifa_id)) as comp_flags USING (governing_org)
WHERE sup_comps.age_level='senior'
  AND is_big5=1
  AND year_id>=?
  AND year_id<=?
  AND sup_comps.gender='m'
  AND year_id >= '1988-1989'
  AND phase_id=? 
GROUP BY year_id, team_id
ORDER BY wins DESC, year_id DESC, team_id LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          '2025-2026',
          '2025-2026',
          '0'
        ];

Query Time: 0.01 seconds
Table Build Time: 0.05 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'order_by' => 'wins',
          'comp_type' => 'b5',
          'per90min_val' => 5,
          'year_min' => '2025-2026',
          'year_max' => '2025-2026',
          'comp_gender' => 'm',
          'match' => 'team_season',
          'force_year_min' => 1,
          'phase_id' => '0'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'year_max' => '2025-2026',
          'phase_id' => '0',
          'comp_type' => 'b5',
          'force_year_min' => 1,
          'year_min' => '2025-2026'
        };