Team Season Stats Finder - Hockey

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

main

Page Setup Time: 0.00109 seconds

SELECT year_id as year_id_csk, CONCAT(year_id-1,"-",SUBSTRING(year_id,3,2)) as year_id, ts.name_abbr 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(losses_ot) AS losses_ot, SUM(points) AS points, SUM(goals) AS goals, SUM(goals_pp) AS goals_pp, SUM(goals_sh) AS goals_sh, SUM(shots) AS shots, SUM(pen_min) AS pen_min, SUM(opp_goals) AS opp_goals, SUM(opp_goals_pp) AS opp_goals_pp, SUM(opp_goals_sh) AS opp_goals_sh, SUM(opp_shots) AS opp_shots, SUM(opp_pen_min) AS opp_pen_min, SUM(goals_pp*(year_id>=1964))/SUM(chances_pp*(year_id>=1964)) as pp_pct_csk, ROUND(100 * (SUM(goals_pp*(year_id>=1964))/SUM(chances_pp*(year_id>=1964))),1) AS pp_pct, (SUM(opp_chances_pp*(year_id>=1964)) - SUM(opp_goals_pp*(year_id>=1964)))/SUM(opp_chances_pp*(year_id>=1964)) as pk_pct_csk, ROUND(100 * ((SUM(opp_chances_pp*(year_id>=1964)) - SUM(opp_goals_pp*(year_id>=1964)))/SUM(opp_chances_pp*(year_id>=1964))),1) AS pk_pct, SUM(chances_pp) AS chances_pp, SUM(opp_chances_pp) AS opp_chances_pp, SUM(goals) - SUM(opp_goals) AS goals_diff, SUM(faceoff_wins) AS faceoff_wins, SUM(faceoff_losses) AS faceoff_losses, SUM(faceoff_wins)/(SUM(faceoff_wins)+SUM(faceoff_losses)) as faceoff_percentage_csk, ROUND(100 * (SUM(faceoff_wins)/(SUM(faceoff_wins)+SUM(faceoff_losses))),1) AS faceoff_percentage, SUM(hits) AS hits, SUM(blocks) AS blocks
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)
WHERE comp_id=?
  AND phase_id=?
  AND type=? 
GROUP BY year_id, team_id
ORDER BY wins DESC, year_id DESC, team_id LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'NHL',
          'NHL_RS',
          'reg'
        ];

Query Time: 0.03 seconds
Table Build Time: 0.05 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'comp_id' => 'NHL',
          'match' => 'team_season',
          'comp_type' => 'reg',
          'order_by' => 'wins',
          'type' => 'reg'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'comp_id' => 'NHL',
          'type' => 'reg'
        };