Player Season & Career Stats Finder - Pro Football

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

main

Page Setup Time: 0.00079 seconds

SELECT name_display, name_display_csk, sup_players.link as name_display_link, IFNULL(age, "") as age, GROUP_CONCAT(DISTINCT CONCAT('<a href="', 'DOMAIN', ts.link, '" target="_blank">', ts.name_abbr, '</a>')) as teams_played_for, year_id as year_id_csk, year_id as year_id, is_complete_comp_season, pos, GROUP_CONCAT(DISTINCT sup_comp_seasons.name_abbr) as comp_name_abbr, person_id, comp_id, phase_id, SUM(games) AS games, SUM(games_started) AS games_started, SUM(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points, SUM(IFNULL(rec,0)) + SUM(fantasy_points) as fantasy_points_ppr_csk, ROUND(SUM(IFNULL(rec,0)) + SUM(fantasy_points),2) AS fantasy_points_ppr, SUM(fantasy_points)/SUM(games) as fantasy_points_per_game_csk, ROUND(SUM(fantasy_points)/SUM(games),2) AS fantasy_points_per_game, (SUM(rec)+SUM(fantasy_points))/SUM(games) as fantasy_points_ppr_per_game_csk, ROUND((SUM(rec)+SUM(fantasy_points))/SUM(games),2) AS fantasy_points_ppr_per_game
FROM sup_player_team_seasons as st
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_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, link, phase_id, comp_id FROM sup_team_seasons) as ts USING (team_id, year_id, phase_id, comp_id)
WHERE type="reg" 
GROUP BY person_id, year_id
ORDER BY fantasy_points_csk DESC, person_id LIMIT 0, 20

SQL PARAMS -- $VAR1 = [];

Query Time: 2.94 seconds
Table Build Time: 0.04 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'season_start' => 1,
          'comp_type' => 'reg',
          'weight_max' => '500',
          'order_by' => 'fantasy_points',
          'season_end' => -1,
          'draft_pick_type' => 'overall',
          'rookie' => 'N',
          'match' => 'player_season'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {};