Drive Finder
Current Search
In 2025, any team vs. any team, in the regular season, started in the fourth quarter, sorted by Number of Plays descending
Display Query »
/* mysql8 */
SELECT /* drive_finder */ drives.game_id, drives.year_id as year_id,
games_team.game_date, drives.team_id, drives.opp_id,
is_home_game, drive_num, quarter_start, quarter_end,
play_count, pass_count, rush_count, pen_count,
net_yds, total_yds, penalty_yds,
first_downs, ifnull(start_at_field,'') as start_at_field,
ifnull(start_at_ydline,0) as start_at_ydline,
ifnull(end_at_field,'') as end_at_field,
ifnull(end_at_ydline,0) as end_at_ydline,
time_start, time_end, time_total, start_event, end_event,
team_pts_before, team_pts, opp_pts_before, opp_pts,
is_kneeldown, start_id, end_id, pass_count, rush_count, pen_count,
time_to_sec(concat('00:', time_start)) as start_sec,
time_to_sec(concat('00:', time_end)) as end_sec,
if(win,games_team.team_id,games_team.opp_id) as winning_team_id,
if(tie,1,0) as is_tie,
points, points_opp
FROM drives
RIGHT
JOIN games_team USING (game_id, team_id)
LEFT JOIN game_master USING (game_id)
WHERE drives.year_id = ?
AND games_team.is_playoff_game = 0
AND quarter_start in ('4')
ORDER BY play_count desc
$VAR1 = [
2025
];
/* mysql8 */
SELECT /* drive_finder */ drives.game_id, drives.year_id as year_id,
games_team.game_date, drives.team_id, drives.opp_id,
is_home_game, drive_num, quarter_start, quarter_end,
play_count, pass_count, rush_count, pen_count,
net_yds, total_yds, penalty_yds,
first_downs, ifnull(start_at_field,'') as start_at_field,
ifnull(start_at_ydline,0) as start_at_ydline,
ifnull(end_at_field,'') as end_at_field,
ifnull(end_at_ydline,0) as end_at_ydline,
time_start, time_end, time_total, start_event, end_event,
team_pts_before, team_pts, opp_pts_before, opp_pts,
is_kneeldown, start_id, end_id, pass_count, rush_count, pen_count,
time_to_sec(concat('00:', time_start)) as start_sec,
time_to_sec(concat('00:', time_end)) as end_sec,
if(win,games_team.team_id,games_team.opp_id) as winning_team_id,
if(tie,1,0) as is_tie,
points, points_opp
FROM drives
RIGHT
JOIN games_team USING (game_id, team_id)
LEFT JOIN game_master USING (game_id)
WHERE drives.year_id = ?
AND games_team.is_playoff_game = 0
AND quarter_start in ('4')
ORDER BY play_count desc
$VAR1 = [
2025
];
Data coverage: since 2001. Please see our data coverage page for details.

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.