Pivotal Play Finder

/* mysql8 */
SELECT p.game_id, p.event_num, p.series_name, p.series_game_num, p.year_game, p.season_type, 
  p.result_batter, p.result_batter_name AS batter, CONCAT(b1.name_last,b1.name_first) as batter_csk,
  p.result_pitcher, p.result_pitcher_name AS pitcher, CONCAT(b2.name_last,b2.name_first) as pitcher_csk,
  p.end_game_flag, p.new_game_flag, p.relative_score, p.runs_on_play, 
  batting_team_id AS batting_team, pitching_team_id AS pitching_team, p.team_rel_score,
  p.date_game, p.pitches, p.half_inning, p.inning, p.outs, p.ball_strike_count, 
  p.runners_on_bases, p.event_type, p.play_desc, 
  ROUND(wpa_abs,3) AS wpa, li AS leverage_index,
  ROUND(cwpa_abs*100,2) AS cwpa, cli, 
  ROUND(batting_cwpa*100,2) AS batting_cwpa, batting_cli, 
  ROUND(pitching_cwpa*100,2) AS pitching_cwpa, pitching_cli
FROM plays p
  JOIN bio as b1 ON b1.player_ID=result_batter
  JOIN bio as b2 ON b2.player_ID=result_pitcher
WHERE 1>0 AND year_game BETWEEN ? AND ?
ORDER BY cwpa_abs DESC
LIMIT 0,300


$VAR1 = [
          1903,
          2025
        ];