Field Goal Finder

/* mysql8 */
  select /* fg_finder */ player_id, game_id, 
  CONCAT_WS(" ",name_first, name_last,name_suffix) as player, 
  CONCAT_WS("-",name_last, name_first) as player_csk,
  CONCAT('/players/',UPPER(LEFT(master.player_id,1)),'/',master.player_id,'.htm') as player_link, 
  distance, if(is_home_game=1,'','@') as at_or_vs, team_id, concat("/teams/", team_id, "/", year_id, ".htm") as team_link, 
  (select team_abb from teams where teams.team_id = field_goal_details.team_id and teams.year_id = games_team.year_id) as team, opp_id,
  concat("/teams/", opp_id, "/", year_id, ".htm") as opp_link, 
  (select team_abb from teams where teams.team_id = games_team.opp_id and teams.year_id = games_team.year_id) as opp, 
  concat("/boxscores/", game_id, ".htm") as game_date_link, 
  CONCAT(IF(points > points_opp, 'W', IF(points < points_opp, 'L', 'T')), ' ', points, '-', points_opp) AS game_result, 
  points - points_opp AS game_result_csk, 
  field_goal_details.game_date as game_date, 
  year_id, is_good, is_blocked 
  from field_goal_details 
  left join games_team using (game_id, team_id) 
  left join master using (player_id)
  where 1=1 and games_team.is_playoff_game = 0 and distance <= ? and distance >= ? and year_id = ? 
  order by game_date desc 


$VAR1 = [
          80,
          '50',
          2019
        ];