Query Template: /baseball/players/yearly-stats.cfm:56 Execution Time: 7.77 ms Record Count: 17 Cached: No Lazy: No SQL: SELECT ptsR=SUM(feeds.scored_points), gmsR=SUM(feeds.games), ppgR=(convert(real,SUM(feeds.scored_points)) / convert(real,SUM(feeds.games))), wR=SUM(feeds.wins), sR=SUM(feeds.saves), cgR=SUM(feeds.complete_game), wsbR=SUM(feeds.ws_points), nwsR=SUM(feeds.nws_points), nohR=SUM(feeds.no_hitter), pfgR=SUM(feeds.perfect_game),startR=sum(feeds.starts), reliefR=sum(feeds.relief),proteam,year=substring(period,1,4) from feeds WHERE player = '8458' group by substring(period,1,4),proteam order by substring(period,1,4) asc | |||||||||||||||
ptsR | gmsR | ppgR | wR | sR | cgR | wsbR | nwsR | nohR | pfgR | startR | reliefR | proteam | year | ||
1 | 27 | 13 | 2.0769231 | 0 | 0 | 0 | 0 | 27 | 0 | 0 | 0 | 13 | NYA | 2009 | |
2 | 49 | 22 | 2.2272727 | 2 | 0 | 0 | 2 | 27 | 0 | 0 | 0 | 22 | NYA | 2010 | |
3 | 362 | 55 | 6.581818 | 6 | 20 | 0 | 48 | 54 | 0 | 0 | 0 | 55 | Hou | 2011 | |
4 | 49 | 16 | 3.0625 | 2 | 0 | 0 | 2 | 27 | 0 | 0 | 0 | 16 | NYA | 2011 | |
5 | 87 | 39 | 2.2307692 | 0 | 1 | 0 | 2 | 75 | 0 | 0 | 4 | 35 | Bos | 2012 | |
6 | 335 | 69 | 4.8550725 | 2 | 15 | 0 | 30 | 135 | 0 | 0 | 8 | 61 | Pit | 2013 | |
7 | 475 | 69 | 6.884058 | 3 | 31 | 0 | 60 | 75 | 0 | 0 | 3 | 66 | Pit | 2014 | |
8 | 682 | 75 | 9.093333 | 3 | 51 | 0 | 88 | 54 | 0 | 0 | 7 | 68 | Pit | 2015 | |
9 | 383 | 44 | 8.704545 | 1 | 30 | 0 | 46 | 27 | 0 | 0 | 4 | 40 | Pit | 2016 | |
10 | 220 | 27 | 8.148149 | 1 | 15 | 0 | 26 | 24 | 0 | 0 | 2 | 21 | Was | 2016 | |
11 | 180 | 32 | 5.625 | 1 | 11 | 0 | 18 | 42 | 0 | 0 | 2 | 30 | SF | 2017 | |
12 | 117 | 41 | 2.8536584 | 1 | 3 | 0 | 8 | 69 | 0 | 0 | 0 | 41 | SF | 2018 | |
13 | 161 | 23 | 7 | 1 | 11 | 0 | 20 | 21 | 0 | 0 | 0 | 23 | Atl | 2019 | |
14 | 142 | 42 | 3.3809524 | 4 | 1 | 0 | 8 | 84 | 0 | 0 | 0 | 42 | SF | 2019 | |
15 | 172 | 23 | 7.478261 | 2 | 11 | 0 | 24 | 18 | 0 | 0 | 0 | 23 | Atl | 2020 | |
16 | 539 | 63 | 8.555555 | 4 | 38 | 0 | 80 | 39 | 0 | 0 | 0 | 63 | Ari | 2021 | |
17 | 314 | 62 | 5.064516 | 3 | 18 | 0 | 38 | 66 | 0 | 0 | 0 | 62 | Ari | 2022 |
General Info | Pitching Breakdown | ||||||||||
Year | Proteam | Points | Games | PPG | W | S | CG | W/S+ | Non W/S+ ` | No Hitter | Perfect Game |
2009 | NYA | 27 | 13 | 2.08 | 0 | 0 | 0 | 0 | 27 | 0 | 0 |
2010 | NYA | 49 | 22 | 2.23 | 2 | 0 | 0 | 2 | 27 | 0 | 0 |
2011 | NYA-Hou | 362 | 55 | 6.58 | 6 | 20 | 0 | 48 | 54 | 0 | 0 |
2011 | NYA-Hou | 49 | 16 | 3.06 | 2 | 0 | 0 | 2 | 27 | 0 | 0 |
2012 | Bos | 87 | 39 | 2.23 | 0 | 1 | 0 | 2 | 75 | 0 | 0 |
2013 | Pit | 335 | 69 | 4.86 | 2 | 15 | 0 | 30 | 135 | 0 | 0 |
2014 | Pit | 475 | 69 | 6.88 | 3 | 31 | 0 | 60 | 75 | 0 | 0 |
2015 | Pit | 682 | 75 | 9.09 | 3 | 51 | 0 | 88 | 54 | 0 | 0 |
2016 | Pit-Was | 383 | 44 | 8.70 | 1 | 30 | 0 | 46 | 27 | 0 | 0 |
2016 | Pit-Was | 220 | 27 | 8.15 | 1 | 15 | 0 | 26 | 24 | 0 | 0 |
2017 | SF | 180 | 32 | 5.63 | 1 | 11 | 0 | 18 | 42 | 0 | 0 |
2018 | SF | 117 | 41 | 2.85 | 1 | 3 | 0 | 8 | 69 | 0 | 0 |
2019 | SF-Atl | 161 | 23 | 7.00 | 1 | 11 | 0 | 20 | 21 | 0 | 0 |
2019 | SF-Atl | 142 | 42 | 3.38 | 4 | 1 | 0 | 8 | 84 | 0 | 0 |
2020 | Atl | 172 | 23 | 7.48 | 2 | 11 | 0 | 24 | 18 | 0 | 0 |
2021 | Ari | 539 | 63 | 8.56 | 4 | 38 | 0 | 80 | 39 | 0 | 0 |
2022 | Ari | 314 | 62 | 5.06 | 3 | 18 | 0 | 38 | 66 | 0 | 0 |