Pitching Game Finder

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      

For year 2020, Team Won, Pitcher Won, as Reliever, sorted by greatest IP
Display Query »
SELECT /* br:game_finder:7 */    have_pbp, result_pitcher, 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.pitcher_game as career_game_num,
pitching_team_id, batting_team_id,
A.date_game, A.date_game_number, A.game_id as date_game_link, A.game_id as game_id,
batting_team_id as opp_ID, concat('/teams/',batting_team_id,  '/', tgl_stats.year_game, '.shtml') as opp_ID_link, 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,if(homeORvis = 'V','@',' ') as team_homeORaway, tgl_stats.game_length_outs,
pitching_team_id as team_id, concat('/teams/',pitching_team_id, '/', tgl_stats.year_game, '.shtml') as team_id_link,
concat(
if(SHO=1,
   concat('SHO',if(inning_first is null OR floor(1 + (inning_last - (homeORvis='V'))/6)=9,
                   '',
                   CONCAT('(',floor(1 + (inning_last - (homeORvis='V'))/6),')'))),
if(CG=1,
   concat('CG',if(inning_first is null OR floor(1 + (inning_last - (homeORvis='V'))/6)=9,
                   '',
                   CONCAT('(',floor(1 + (inning_last - (homeORvis='V'))/6),')'))),
              concat(if(GS=1,
                        concat('GS-',if(inning_first is null,'   ',floor(1 + (inning_last - (homeORvis='V'))/6))),
                        if(inning_first is null,'',
                           concat(floor(1 + inning_first/6),'-',
                  if(GF=1,CONCAT('GF',
                                     if(inning_first is null OR floor(1 + (inning_last - (homeORvis='V'))/6)=9,
                                        '',
                                        CONCAT('(',floor(1 + (inning_last - (homeORvis='V'))/6),')'))),
                                     floor(1 + (inning_last - (homeORvis='V'))/6)))))))),
   if(A.W=1 AND A.BSv=1,', BW',
     if(A.L=1 AND A.BSv=1,', BL',
      if(A.W=1 AND A.Hold=1,', HW',
       if(A.L=1 AND A.Hold=1,', HL',
      if(A.W=1,', W',
         if(A.L=1,', L',
           if(A.S=1,', S',
              if(A.Hold=1,', H', if(A.BSv=1,',BS',''))))))))
      )
     ) as pitcher_game_result,
     if(A.W=1 AND A.BSv=1,  3,
     if(A.L=1 AND A.BSv=1, -3,
     if(A.W=1,              5,
     if(A.L=1,             -2,
     if(A.S=1,              4,
     if(A.Hold=1,           1,
     if(A.BSv=1,           -1, 0
      ))))))
      ) AS pitcher_game_result_csk
,
A.IPouts, A.BF, A.W, A.L, A.S, A.GS, A.GF, A.CG, A.SHO,  A.pitches, A.strikes, A.ER, A.R-A.ER as UER,
A.R, A.H, A.2B, A.3B, A.HR, A.BB, A.IBB, A.SO, A.SB, A.CS, A.HBP, A.SH, A.SF, A.ROE, A.GIDP, A.BK, A.WP,
A.PickOffs AS pickoffs, A.AB, DR AS days_rest,
A.wpa_def, A.wpa_li AS wpa_li_def,  A.re24_def, A.leverage_index_avg,
A.inherited_runners, A.inherited_score, A.event_num_start, A.event_num_finish, A.game_score,
tgl_stats.game_length_minutes as game_length_minutes,
tgl_stats.attendance as attendance,
  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 pgl as A 
 inner join bio on bio.player_ID=result_pitcher inner join tgl_stats as tgl_stats on tgl_stats.game_id=A.game_id and tgl_stats.team_id=A.pitching_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 pgl_dfs AS dfs ON A.game_id = dfs.dfs_game_id AND A.result_pitcher = dfs.dfs_result_pitcher 

WHERE 
      A.year_game = 2020
  AND tgl_stats.W=1
  AND A.W = 1
  AND A.GS = 0  
ORDER BY A.IPouts DESC, A.date_game DESC, A.date_game_number DESC limit 0,300
Show Criteria

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 (IP, R, BB, SO, etc.)

x

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

Player's League and Team
Opponent's League and Team
Pitcher's Role
Pitcher Decision
Team Success
Throws
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 Player Date Tm Opp Rslt App,Dec IP H R ER BB SO HR UER Pit Str GSc IR IS BF AB 2B 3B IBB HBP SH SF GDP SB CS PO BK WP ERA WPA RE24 aLI DFS(DK) DFS(FD)
1
2
3
4
5
6
7
8
9
10Luke Jackson2020-09-23ATLMIAW 9-42-5, W 4.032205004934001515000000000001 4.50-0.0170.2241.00417.2033.00
11Wes Benjamin2020-09-12 (1)TEXOAKW 5-22-6, W 4.032214005839001615100000000000 4.500.0811.046.58314.6030.00
12David Peterson2020-09-02NYMBALW 9-44-7, W 4.020021005936001513000000100000 0.000.2782.1881.19512.6027.00
13Shun Yamaguchi2020-08-26TORBOSW 9-13-6, W 4.021122105936001513000000100000 2.250.1131.143.90112.6027.00
14Tyler Alexander2020-08-30DETMINW 3-24-7, W 3.220003004933001313000000000000 0.000.2572.001.95317.0532.00
15Daniel Norris2020-08-23DETCLEW 7-43-6, W 3.220004005938201414100000000000 0.000.2442.7101.23619.0535.00
16Gio Gonzalez2020-08-22CHWCHCW 7-44-7, W 3.210032005833001310000000200000 0.000.3041.9091.36413.8529.00
17Jhoulys Chacin2020-07-26ATLNYMW 14-14-7, W 3.210011005435101312000000000000 0.000.0152.129.08413.0526.00
18Michael Lorenzen2020-09-25CINMINW 7-23-6, W 3.131114006237101413100000000000 2.700.2162.0361.28115.1031.00
19T.J. Zeuch2020-09-21TORNYYW 11-54-7, W 3.111110004929001211100000000000 2.700.0460.434.1798.3019.00
20Riley Smith2020-09-10ARILADW 5-26-9, W 3.120054007240001510000000001000 0.000.1711.5851.39415.3034.00
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.