Player Game Stats Finder - Pro Basketball

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

main

Page Setup Time: 0.00168 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, IF(comp_id="WNBA", year_id, CONCAT(year_id-1,"-",SUBSTRING(year_id,3,2))) as year_id, IF(home_away_neutral="H","",IF(home_away_neutral="A","@","N")) as game_location, (SELECT pts-opp_pts+IFNULL(pts,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, (SELECT CONCAT(IF(win=1,'W,',IF(loss=1,'L,','T,')),' ',pts,'-',opp_pts,IF(overtimes>0, ' (', ''),IF(overtimes>1, overtimes, ''),IF(overtimes>0, 'OT)', '')) FROM sup_team_games tg2 WHERE tg2.game_id=st.game_id AND tg2.team_id=st.team_id) as game_result, os.name_abbr as opp_name_abbr, primary_pos as pos_game, is_starter as is_starter_csk, IF(is_starter,'*','') AS is_starter, mp, fg, fga, IF(fga, fg / fga, NULL) as fg_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(fga, fg / fga, NULL),3)) AS fg_pct, (fg - IFNULL(fg3, 0)) AS fg2, (fga - IFNULL(fg3a, 0)) AS fg2a, (fg - IFNULL(fg3, 0)) / (fga - IFNULL(fg3a, 0)) as fg2_pct_csk, TRIM(LEADING '0' FROM ROUND((fg - IFNULL(fg3, 0)) / (fga - IFNULL(fg3a, 0)),3)) AS fg2_pct, fg3, fg3a, IF(fg3a, fg3 / fg3a, NULL) as fg3_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(fg3a, fg3 / fg3a, NULL),3)) AS fg3_pct, ft, fta, IF(fta, ft / fta, NULL) as ft_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(fta, ft / fta, NULL),3)) AS ft_pct, IF(fga + fta, pts / (2 * (fga + 0.44 * fta)), NULL) as ts_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(fga + fta, pts / (2 * (fga + 0.44 * fta)), NULL),3)) AS ts_pct, orb, trb - orb AS drb, trb, ast, stl, blk, tov, pf, pts, pts + 0.4 * fg - 0.7 * fga - 0.4 * (fta - ft) + 0.7 * orb + 0.3 * (trb - orb) + stl + 0.7 * ast + 0.7 * blk - 0.4 * pf - tov as game_score_csk, ROUND(pts + 0.4 * fg - 0.7 * fga - 0.4 * (fta - ft) + 0.7 * orb + 0.3 * (trb - orb) + stl + 0.7 * ast + 0.7 * blk - 0.4 * pf - tov,1) AS game_score, bpm as bpm_csk, ROUND(bpm,1) AS bpm, plus_minus
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 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, comp_id AS opp_comp_id, phase_id, name_abbr, link as opp_team_link FROM sup_team_seasons) as os USING (opp_team_id, year_id, opp_comp_id, phase_id)
WHERE year_id>=?
  AND year_id<=?
  AND type=?
  AND comp_id IN('NBA','BAA') 
ORDER BY pts DESC, person_id LIMIT 0, 20

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

Query Time: 0.23 seconds
Table Build Time: 0.05 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'team_game_min' => 1,
          'year_min' => 2026,
          'order_by' => 'pts',
          'year_max' => 2026,
          'team_game_max' => 84,
          'season_end' => -1,
          'comp_type' => 'reg',
          'player_game_max' => 9999,
          'timeframe' => 'seasons',
          'comp_id' => 'NBA',
          'season_start' => 1,
          'player_game_min' => 1,
          'match' => 'player_game'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'comp_id' => 'NBA',
          'year_min' => 2026,
          'year_max' => 2026
        };