Batting Game Finder — Bubba Starling

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      

Bubba Starling: For year 2020, sorted by greatest HR
Display Query »
SELECT /* br:game_finder:9 */     have_pbp,     result_batter,
     name_common as player,
     concat('/players/',left(bio.player_ID,1),'/',bio.player_ID,'.shtml') as player_link,
     A.year_game as year_game,
     A.batter_game as career_game_num,
     batting_team_id,
     pitching_team_id,
     A.date_game,
     A.date_game_number,
     A.game_id as date_game_link,
     A.game_id as game_id,
     pitching_team_id as opp_ID,
     concat('/teams/',pitching_team_id, '/', tgl_stats.year_game, '.shtml') as opp_ID_link,
     batting_team_id as team_id,
     concat('/teams/',batting_team_id,  '/', tgl_stats.year_game, '.shtml') as team_id_link,
     if(homeORvis = 'V','@',' ') as team_homeORaway, tgl_stats.game_length_outs,
     concat( if(tgl_stats.W=1, 'W ', if(tgl_stats.L=1,'L ','T ')), RS,'-',RA) as game_result, tgl_stats.W as teamW, tgl_stats.L as teamL, tgl_stats.RS as teamRS,  tgl_stats.RS, tgl_stats.RA, tgl_stats.RS - tgl_stats.RA as run_diff,
     PA, AB, R, H, 2B, 3B, HR, RBI, BB, IBB, SO, SB, CS, HBP, SH, SF, ROE, GIDP, XI,
     wpa_bat, wpa_li AS wpa_li_bat, re24_bat, leverage_index_avg,
	 IF(AB IS NULL, 'undef', ROUND(IF(AB = 0, NULL, ROUND(H  / AB,10)),3)) AS batting_avg,
	 IF(AB IS NULL, 'undef', ROUND(IF((AB + IFNULL(BB,0) + IFNULL(HBP,0) + IFNULL(SF,0)) = 0, NULL, ROUND((H + IFNULL(BB,0) + IFNULL(HBP,0)) / (AB + IFNULL(BB,0) + IFNULL(HBP,0) + IFNULL(SF,0)),10)),3)) AS onbase_perc,
	 IF(AB IS NULL, 'undef', ROUND(IF(AB = 0, NULL, ROUND((H + 2B + (2 * 3B) + (3 * HR)) / AB, 10)),3)) AS slugging_perc,
	 ROUND(IF((AB + IFNULL(BB,0) + IFNULL(HBP,0) + IFNULL(SF,0)) = 0, NULL, ROUND((H + IFNULL(BB,0) + IFNULL(HBP,0)) / (AB + IFNULL(BB,0) + IFNULL(HBP,0) + IFNULL(SF,0)),10)) + IF(AB = 0, NULL, ROUND((H + 2B + (2 * 3B) + (3 * HR)) / AB, 10)),3) AS onbase_plus_slugging,
     lineup_position as batting_order_position,
     pitcher, catcher, first_base, second_base, third_base, shortstop, left_field, center_field, right_field, designated_hitter, pinch_hitter, pinch_runner,
       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
,
     ROUND(draftkings_points, 2) AS draftkings_points,
     ROUND(fanduel_points, 2) AS fanduel_points
   from bgl as A 
 inner join bio on bio.player_ID=result_batter inner join tgl_stats as tgl_stats on tgl_stats.game_id=A.game_id and tgl_stats.team_id=A.batting_team_id inner join tgl as tgl on tgl_stats.game_id=tgl.game_id inner join players on players.player_ID=bio.player_ID   LEFT JOIN bgl_dfs AS dfs ON A.game_id = dfs.dfs_game_id AND A.result_batter = dfs.dfs_result_batter 

WHERE 
      A.year_game = 2020
  AND A.result_batter = 'starlbu01'
  AND    (1 > 0)   
ORDER BY A.HR DESC, A.date_game DESC, A.date_game_number DESC limit 0,100

Search Criteria

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

Sort By
Game Type
Series/Game
Years
Span of Games
In player's first career game(s)

Player's game # to

In teams's first game(s)

Team's game # to

Statistical Filters (PA, H, HR, RBI, etc.)

x

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

Player's League and Team
Opponent's League and Team
Team Success
Bats
Throws
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
Typically a Pitcher
This is determined by career games played. Note that a position switcher who started in the field and primarily became a pitcher (Ron Mahay or Bob Lemon) will be included in this list as a full-time pitcher.
Starter or Reserve
Finished Game
Batting Order Position
Is Birthday?
Place of Birth/Death

Game Filters (Length, Location, etc.)

Interleague Games
Game Result
DH Rule in Effect
Game Length
Game Location
Ballpark
Weather Options

Data coverage for weather data

Temp: To
Wind Speed: To
Wind Direction: /
To LF
To CF
To RF
From LF
From CF
From RF
L to R
R to L
Unknown
Precipitation: /
Unknown
None
Drizzle
Showers
Rain
Snow
Sky: /
Unknown
Sunny
Cloudy
Overcast
Night
Dome
Retractable

You have edited your search criteria

or keep editing your search

clear changes

Results

Subscribe to Stathead for full results.

Stathead users enjoy the most powerful research tools in sports for just $8/month. Learn More.

Subscribe Now (First Month Free)

Already a subscriber? Log in for full results.

Results
Rk Date Tm Opp Rslt PA AB R H 2B 3B HR RBI BB IBB SO HBP SH SF ROE GDP SB CS WPA RE24 aLI BOP Pos Summary DFS(DK) DFS(FD)
11
20
30
40
50
60
70
80
90
102020-09-10KCRCLEW 11-10000000000000004PR DH0.000.00
112020-09-09KCRCLEW 3-00000000000000006CF0.000.00
122020-09-08KCRCLEW 8-60000000000000006PR CF0.000.00
132020-09-07KCRCLEL 2-5440000000030000000-0.094-0.978.8556CF0.000.00
142020-09-06KCRCHWL 2-84412000000000010000.0030.835.6025CF8.009.20
152020-09-03KCRCHWL 6-11221100000010000000-0.025-0.428.7655LF5.006.20
162020-09-02KCRCLEL 0-5110000000010000000-0.006-0.260.2308PH0.000.00
172020-09-01KCRCLEL 1-10330100000010000000-0.005-0.296.3738CF3.003.00
182020-08-31KCRCLEW 2-11101000100000000000.2071.0003.5306PR CF5.006.50
192020-08-30KCRCHWL 2-50000000000000003PR DH0.000.00
202020-08-28KCRCHWL 5-60010000000000000.0000.0004PR CF2.003.20
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.