Batting Streak Finder — Jeff Locke

Data runs from 1901 to 2020 for regular season data, 1933-Present for the All-Star Game, and 1903-Present for the Postseason.

Current Search      

Jeff Locke: Longest Streak with 1 or more hits For 2020, At least one AB or SF
Display Query »
set @count:=0; set @PYEAR:=0; set @GCOUNT:=0; set @STLEN := 0; set @previous := NULL; SET @ENTLEN:=0;
select /* br:streak_finder:2 */ t.result_batter, concat('/players/',left(t.result_batter,1),'/', t.result_batter, '.shtml') as player_link, min(t.entity_len) AS entity_check_start, date_format(max((t.streak=1)*t.date_game),"%Y-%m-%d") as streak_start, MAX( t.date_game) as streak_end, rpad(max((t.streak=1)*concat(t.year_game, '.' , lpad(t.batting_team_game,3,"0"))),8,"0") as first_tgame, rpad(MAX( concat(t.year_game, '.' , lpad(t.batting_team_game,3,"0"))),8,"0") as last_tgame, MAX((t.streak=1)*batter_game) as player_game_min, MAX(batter_game) as player_game_max, max(gcount) as player_gcount_max, max(t.streak) as Games_streak, min(t.streak) as min_Games_streak, group_concat(batter_game*(t.streak > 0) order by batter_game ASC separator ',') as gstreak, birth_year, birth_month, birth_day, death_year, if (birth_country = 'Canada' OR birth_country='United States',concat(birth_city,', ',birth_state),if(birth_city is null, birth_country, concat(birth_city,', ',birth_country))) as birth_location, if (death_country = 'Canada' OR death_country='United States',concat(death_city,', ',death_state),if(birth_city is null, death_country, concat(death_city,', ',death_country))) as death_location from ( select x.result_batter, x.batter_game, x.batting_team_game, x.year_game as year_game, x.date_game, @previous, @STAT := x.stat, if((x.result_batter = @previous), @GCOUNT := @GCOUNT + 1, @GCOUNT := 1) as gcount, if((@STAT >= 1) && (x.result_batter = @previous), @STLEN := @STLEN + 1, if( @STAT >= 1, @STLEN := 1, @STLEN := 0)) as streak, if((x.result_batter = @previous), @ENTLEN := @ENTLEN + 1, @ENTLEN := 0) as entity_len, if((@STAT >= 1) && (x.result_batter = @previous), @count, @count := @count + 1) as counter, @previous := x.result_batter, @PYEAR := x.year_game, birth_country, birth_state, birth_city, birth_year, birth_month, birth_day, death_country, death_state, death_city, death_year, death_month, death_day from ( select batter_game, A.year_game, batting_team_game, A.date_game, result_batter, ((H >= 1)) as stat, birth_country, birth_state, birth_city, birth_year, birth_month, birth_day, death_country, death_state, death_city, death_year, death_month, death_day from bgl as A inner join tgl_stats as tgl_stats on (A.game_id=tgl_stats.game_id and A.batting_team_id=tgl_stats.team_id) inner join players on (A.result_batter=players.player_ID) inner join bio on (A.result_batter=bio.player_ID) where A.year_game = 2020 AND A.result_batter = 'lockeje01' AND AB + IFNULL(SF,0) > 0 AND (1 > 0) order by result_batter, batter_game ASC) as x ) as t group by counter having Games_streak > 0 order by Games_streak desc, streak_end desc limit 0,1000

Search Criteria

Click on the red text to pre-fill the form with various values

Game Type

Searching all years, teams and positions? Divide into two runs.

Player Appearance MLB Rules
For consecutive hit and home run streaks only games where the batter had either an at bat or a sacrifice fly are considered.

For consecutive times on base streaks, generally, only games where the player had a plate appearance are considered.

MLB rulebook

Streak Stat Events (PA, H, HR, RBI, etc.)

Statistical Filters (for streak)

Search for streaks within streaks.
(Example, in 22 straight games where he was hitless, Jim Wynn reached base at least once.)

Player Filters (Team, Position, Bats, etc.)

Player's League and Team
Opponent's League and Team
Batter's Defensive Position

Played the position at any point in the game

Played any of those marked
Played exactly as marked or not
Played at least all those marked
Starter or Reserve
Batting Order Position
Streak Start or End
Place of Birth/Death

Game Filters (Location, Ballpark, etc.)

Game Location
Interleague Games

You have edited your search criteria

or keep editing your search

clear changes

No seasons match your search

Please let us know if this is an error.

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.