Shot Finder

/* mysql8 */
SELECT player_id,
  name_common AS player,
  CONCAT('/players/', LEFT(player_id, 1), '/', player_id, '.html') AS player_link,
  game_id,
  year_id,
  CONCAT_WS('-', (year_id - 1), RIGHT(year_id, 2)) AS season,
  IF(lg_id = 'TOT', '', CONCAT('/leagues/', lg_id, '_', year_id, '.html')) AS season_link,
  date_game,
  CONCAT('/boxscores/', game_id, '.html') AS date_game_link,
  IF(COUNT(DISTINCT team_id) = 1, team_id, 'TOT') AS team_id,
  IF(COUNT(DISTINCT team_id) = 1, IF(team_id = 'TOT', '', CONCAT('/teams/', team_id, '/', year_id, '.html')), '') AS team_id_link,
  IF(game_location = 'H', '', IF(game_location = 'N', 'N', '@')) AS game_location,
  opp_id,
  CONCAT('/teams/', opp_id, '/', year_id, '.html') AS opp_id_link,
  game_result,
  COUNT(DISTINCT game_id) AS g,
  COUNT(*) AS fga,
  SUM(play_code IN ('fg2', 'fg3')) AS fg,
  SUM(play_code IN ('fg2x', 'fg3x')) AS fgx,
  TRIM(LEADING '0' FROM ROUND(SUM(play_code IN ('fg2', 'fg3')) / COUNT(*), 3)) AS fg_pct,
  SUM(play_code IN ('fg2', 'fg3')) / COUNT(*) AS fg_pct_csk,
  SUM(play_code IN ('fg3', 'fg3x')) AS fg3a,
  SUM(play_code = 'fg3') AS fg3,
  SUM(play_code = 'fg3x') AS fg3x,
  TRIM(LEADING '0' FROM ROUND(SUM(play_code = 'fg3') / SUM(play_code IN ('fg3', 'fg3x')), 3)) AS fg3_pct,
  SUM(play_code = 'fg3') / SUM(play_code IN ('fg3', 'fg3x')) AS fg3_pct_csk,
  TRIM(LEADING '0' FROM ROUND(SUM((play_code = 'fg2') + 1.5 * (play_code = 'fg3')) / COUNT(*), 3)) AS efg_pct,
  SUM((play_code = 'fg2') + 1.5 * (play_code = 'fg3')) / COUNT(*) AS efg_pct_csk,
  SUM(assist_id IS NOT NULL) AS fg_ast,
  TRIM(LEADING '0' FROM ROUND(SUM(assist_id IS NOT NULL) / SUM(play_code IN ('fg2', 'fg3')), 3)) AS fg_ast_pct,
  SUM(assist_id IS NOT NULL) / SUM(play_code IN ('fg2', 'fg3')) AS fg_ast_pct_csk,
   CONCAT_WS('-', name_last, name_first) AS player_csk,
  time_elapsed_game
FROM shooting
  JOIN master
  ON(shooting.shooter_id = master.player_id)
WHERE year_id BETWEEN 2026 AND 2026 AND is_playoffs = 0 AND play_type LIKE '%DUNK%'
GROUP BY shooter_id, year_id
ORDER BY fg DESC, player_id
LIMIT 0, 20


$VAR1 = [];