Event Finder
Current Search
In 2025-26, Field Goals, in the regular season, playing for the 76ers/Nationals
Display Query »
/* 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 = [];
In 2025-26, Field Goals, in the regular season, playing for the 76ers/Nationals
/* 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 = [];
Data coverage: since 1996-97. Please see our data coverage page for details.
If you utilize material unique to a Sports Reference
site for a tweet, an article, or for research for a
broadcast or podcast, please strongly consider citing this site as the
source for the material. It would be greatly appreciated and would
help us continue to produce this material.

We're Social...for Statheads
Site Last Updated:
Question, Comment, Feedback, or Correction?
Subscribe to our Free Email Newsletter
Do you have a sports website? Or write about sports? We have tools and resources that can help you use sports data. Find out more.