Event Finder

/* mysql8 */
SELECT pbp.game_id,
  pbp.year_id,
  pbp.date_game,
  CONCAT('/boxscores/', pbp.game_id, '.html') AS date_game_link,
  pbp.play_id,
  CASE WHEN pbp.quarter = 1 THEN '1st' 
  WHEN pbp.quarter = 2 THEN '2nd' 
  WHEN pbp.quarter = 3 THEN '3rd' 
  WHEN pbp.quarter = 4 THEN '4th' 
  WHEN pbp.quarter = 5 THEN 'OT' 
  ELSE CONCAT(pbp.quarter - 4, 'OT') 
  END AS quarter,
  pbp.quarter AS quarter_csk,
  IF(pbp.quarter <= 4, pbp.quarter * 7200, 28800 + (pbp.quarter - 4) * 3000) - pbp.time_elapsed_game AS time_remain_quarter,
  IF(1 = 1, pbp.focus_team_id, pbp.other_team_id) AS team_id,
  IF(1 = 1, pbp.other_team_id, pbp.focus_team_id) AS opp_id,
  IF(pbp.visitor_team_id = IF(1 = 1, pbp.focus_team_id, pbp.other_team_id), '@', '') AS game_location,
  IF(1 = 1, IF(pbp.focus_team_id = pbp.visitor_team_id, pbp.visitor_pts, pbp.home_pts), IF(pbp.focus_team_id = pbp.visitor_team_id, pbp.home_pts, pbp.visitor_pts)) AS pts,
  IF(1 = 1, IF(pbp.focus_team_id = pbp.visitor_team_id, pbp.home_pts, pbp.visitor_pts), IF(pbp.focus_team_id = pbp.visitor_team_id, pbp.visitor_pts, pbp.home_pts)) AS opp_pts,
  #       IF(1 = 1 AND pbp.focus_team_id = pbp.visitor_team_id, pbp.visitor_pts, pbp.home_pts) AS pts,
  #       IF(1 = 1 AND pbp.focus_team_id = pbp.visitor_team_id, pbp.home_pts, pbp.visitor_pts) AS opp_pts,
  pbp.player1_id,
  pbp.player2_id,
  pbp.play_pts
FROM pbp
WHERE pbp.play_code IN ('fg2', 'fg3') AND pbp.year_id >= 2026 AND pbp.year_id <= 2026 AND pbp.is_playoffs = 0 AND pbp.focus_team_id IN ('SYR','PHI')
ORDER BY pbp.game_id, 
  pbp.play_id


$VAR1 = [];