Player Game Stats Finder - Pro Football

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

main

Page Setup Time: 0.00155 seconds

SELECT name_display, name_display_csk, sup_players.link as name_display_link, person_id, age_on_day, ts.name_abbr as team_name_abbr, ts.link as team_link, opp_team_link, date, game_id, sup_games.link as game_link, 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, os.name_abbr as opp_name_abbr, season_pos as pos_game, LEFT(DAYNAME(`date`), 3) as game_day_of_week, team_game_num_season as game_num, week_num_season as week_num, fantasy_points as fantasy_points_csk, ROUND(fantasy_points,2) AS fantasy_points, IFNULL(rec,0) + fantasy_points as fantasy_points_ppr_csk, ROUND(IFNULL(rec,0) + fantasy_points,2) AS fantasy_points_ppr, IFNULL(4*pass_td + pass_yds/25 + IF(pass_yds>=300,3,0) -pass_int + rush_yds/10 + 6*rush_td + IF(rush_yds>=100,3,0) + rec_yds/10 + rec + 6*rec_td + IF(rec_yds>=100,3,0) + 6*punt_ret_td + 6*kick_ret_td - IF(year_id>=1994,IFNULL(fumbles_lost,0),fumbles/2) + 6*fumbles_rec_td + 2 * IFNULL(two_pt_md,0) + 2*IFNULL(two_pt_pass,0) + 3*(IFNULL(fgm1,0)+IFNULL(fgm2,0)+IFNULL(fgm3,0)) + 4*IFNULL(fgm4,0) + 5*IFNULL(fgm5,0) + xpm,0) as draftkings_points_csk, ROUND(IFNULL(4*pass_td + pass_yds/25 + IF(pass_yds>=300,3,0) -pass_int + rush_yds/10 + 6*rush_td + IF(rush_yds>=100,3,0) + rec_yds/10 + rec + 6*rec_td + IF(rec_yds>=100,3,0) + 6*punt_ret_td + 6*kick_ret_td - IF(year_id>=1994,IFNULL(fumbles_lost,0),fumbles/2) + 6*fumbles_rec_td + 2 * IFNULL(two_pt_md,0) + 2*IFNULL(two_pt_pass,0) + 3*(IFNULL(fgm1,0)+IFNULL(fgm2,0)+IFNULL(fgm3,0)) + 4*IFNULL(fgm4,0) + 5*IFNULL(fgm5,0) + xpm,0),1) AS draftkings_points, IFNULL(rush_yds/10 + 6*rush_td + pass_yds/25 + 4*pass_td - pass_int + rec_yds/10 + 6*rec_td + rec/2 + 6*kick_ret_td + 6*punt_ret_td - 2*IF(year_id>=1994,IFNULL(fumbles_lost,0),fumbles/2) + 6*fumbles_rec_td + 2*IFNULL(two_pt_md,0) + 2*IFNULL(two_pt_pass,0) + 3*(IFNULL(fgm1,0)+IFNULL(fgm2,0)+IFNULL(fgm3,0)) + 4*IFNULL(fgm4,0) + 5*IFNULL(fgm5,0) + xpm,0) as fanduel_points_csk, ROUND(IFNULL(rush_yds/10 + 6*rush_td + pass_yds/25 + 4*pass_td - pass_int + rec_yds/10 + 6*rec_td + rec/2 + 6*kick_ret_td + 6*punt_ret_td - 2*IF(year_id>=1994,IFNULL(fumbles_lost,0),fumbles/2) + 6*fumbles_rec_td + 2*IFNULL(two_pt_md,0) + 2*IFNULL(two_pt_pass,0) + 3*(IFNULL(fgm1,0)+IFNULL(fgm2,0)+IFNULL(fgm3,0)) + 4*IFNULL(fgm4,0) + 5*IFNULL(fgm5,0) + xpm,0),1) AS fanduel_points
FROM sup_player_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN (SELECT game_id, year_id, comp_id, phase_id, part_id, team_id, opp_team_id, opp_comp_id, opp_phase_id, team_game_num_season, home_away_neutral, win, loss, tie, points, points_opp FROM sup_team_games) as tg USING (game_id, team_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 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, year_id, name_abbr, link as opp_team_link FROM sup_team_seasons GROUP BY team_id, year_id ) as os USING (opp_team_id, year_id)
  JOIN (SELECT person_id, team_id, year_id, comp_id, phase_id, is_rookie, is_first_year, pos as season_pos, season_from_career_start, season_from_career_end FROM sup_player_team_seasons) as ps USING (person_id, team_id, year_id, comp_id, phase_id)
WHERE type="reg"
  AND comp_id=?
  AND year_id>=?
  AND year_id<=? 
ORDER BY fantasy_points_csk DESC, person_id LIMIT 0, 20

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

Query Time: 1.76 seconds
Table Build Time: 0.05 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'comp_type' => 'reg',
          'comp_id' => 'NFL',
          'season_start' => 1,
          'player_game_num_season_max' => 18,
          'draft_pick_type' => 'overall',
          'match' => 'player_game',
          'year_min' => 2025,
          'team_game_num_season_min' => 1,
          'week_num_season_max' => 22,
          'timeframe' => 'seasons',
          'qb_start_num_career_max' => 400,
          'rookie' => 'N',
          'year_max' => 2025,
          'season_end' => -1,
          'week_num_season_min' => 1,
          'order_by' => 'fantasy_points',
          'qb_start_num_career_min' => 1,
          'player_game_num_season_min' => 1,
          'player_game_num_career_max' => 400,
          'player_game_num_career_min' => 1,
          'team_game_num_season_max' => 17,
          'weight_max' => '500'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'year_max' => 2025,
          'comp_id' => 'NFL',
          'year_min' => 2025
        };