Player Quarter Finder

/* mysql8 */
  SET SQL_BIG_SELECTS = 1

$VAR1 = [];
/* mysql8 */
SELECT /* BBR: quarter_finder (1) */
  name_common AS player,
  CONCAT('/players/', LEFT(player_id, 1), '/', player_id, '.html') AS player_link,
  CONCAT_WS(' ', name_last, name_first) AS player_csk,
  (SELECT age FROM gamelogs_pgl WHERE player_id = quarterlogs.player_id AND game_id=quarterlogs.game_id) AS age,
  pos,
  date_game,
  quarter,
  CONCAT('/boxscores/', game_id, '.html') AS date_game_link,
  is_playoffs,
  team_id AS team_id,
  CONCAT('/teams/', team_id, '/', year_id, '.html') AS team_id_link,
  IF(game_location = 'A', '@', '') AS game_location,
  opp_id AS opp_id,
  CONCAT('/teams/', opp_id, '/', year_id, '.html') AS opp_id_link,
  game_result,
  gs,
  ROUND(time_on_court / 60) AS mp,
  fg,
  fga,
  TRIM(LEADING '0' FROM ROUND(IF(fga = 0, NULL, fg / fga), 3)) AS fg_pct,
  IF(fga = 0, NULL, fg / fga) AS fg_pct_csk,
  (fg - IFNULL(fg3, 0)) AS fg2,
  (fga - IFNULL(fg3a, 0)) AS fg2a,
  TRIM(LEADING '0' FROM ROUND(IF((fga - IFNULL(fg3a, 0)) = 0, NULL, (fg - IFNULL(fg3, 0)) / (fga - IFNULL(fg3a, 0))), 3)) AS fg2_pct,
  IF((fga - IFNULL(fg3a, 0)) = 0, NULL, (fg - IFNULL(fg3, 0)) / (fga - IFNULL(fg3a, 0))) AS fg2_pct_csk,
  fg3,
  fg3a,
  TRIM(LEADING '0' FROM ROUND(IF(fg3a = 0, NULL, fg3 / fg3a), 3)) AS fg3_pct,
  IF(fg3a = 0, NULL, fg3 / fg3a) AS fg3_pct_csk,
  ft,
  fta,
  TRIM(LEADING '0' FROM ROUND(IF(fta = 0, NULL, ft / fta), 3)) AS ft_pct,
  IF(fta = 0, NULL, ft / fta) AS ft_pct_csk,
  orb,
  trb - orb AS drb,
  trb,
  ast,
  stl,
  blk,
  tov,
  pf,
  pts,
  plus_minus
FROM quarterlogs
  JOIN master USING (player_id)
WHERE year_id BETWEEN 2026 AND 2026 AND is_playoffs = 0 AND quarter!='h1' AND quarter!='h2'
ORDER BY  pts DESC, player_csk ASC
LIMIT 0, 20


$VAR1 = [];