Query Template: /baseball/players/yearly-stats.cfm:56 Execution Time: 20.5 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 = '8099' 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 | 33 | 10 | 3.3 | 0 | 0 | 0 | 0 | 33 | 0 | 0 | 9 | 1 | NYA | 2008 | |
2 | 3 | 1 | 3 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 1 | NYA | 2009 | |
3 | 385 | 32 | 12.03125 | 9 | 0 | 0 | 82 | 213 | 0 | 0 | 32 | 0 | Ari | 2010 | |
4 | 568 | 33 | 17.212122 | 21 | 0 | 1 | 230 | 123 | 0 | 0 | 33 | 0 | Ari | 2011 | |
5 | 400 | 32 | 12.5 | 15 | 0 | 0 | 154 | 96 | 0 | 0 | 31 | 1 | Ari | 2012 | |
6 | 179 | 20 | 8.95 | 3 | 0 | 0 | 20 | 129 | 0 | 0 | 20 | 0 | Ari | 2013 | |
7 | 105 | 10 | 10.5 | 3 | 0 | 0 | 30 | 45 | 0 | 0 | 10 | 0 | SD | 2013 | |
8 | 399 | 32 | 12.46875 | 12 | 0 | 0 | 102 | 177 | 0 | 0 | 32 | 0 | SD | 2014 | |
9 | 318 | 29 | 10.965517 | 8 | 0 | 0 | 76 | 162 | 0 | 0 | 27 | 2 | SD | 2015 | |
10 | 386 | 32 | 12.0625 | 11 | 0 | 2 | 108 | 168 | 0 | 0 | 27 | 1 | KC | 2016 | |
11 | 236 | 30 | 7.866667 | 5 | 0 | 0 | 48 | 138 | 0 | 0 | 30 | 0 | KC | 2017 | |
12 | 218 | 22 | 9.909091 | 3 | 0 | 0 | 32 | 156 | 0 | 0 | 22 | 0 | KC | 2018 | |
13 | 448 | 63 | 7.111111 | 3 | 30 | 0 | 52 | 66 | 0 | 0 | 0 | 63 | KC | 2019 | |
14 | 21 | 15 | 1.4 | 0 | 0 | 0 | 0 | 21 | 0 | 0 | 1 | 14 | KC | 2020 | |
15 | 390 | 55 | 7.090909 | 3 | 26 | 0 | 52 | 48 | 0 | 0 | 0 | 55 | Ari | 2021 | |
16 | 227 | 56 | 4.053571 | 4 | 10 | 0 | 24 | 63 | 0 | 0 | 0 | 56 | Ari | 2022 | |
17 | 24 | 16 | 1.5 | 0 | 0 | 0 | 0 | 24 | 0 | 0 | 0 | 16 | Tex | 2023 |
General Info | Pitching Breakdown | ||||||||||
Year | Proteam | Points | Games | PPG | W | S | CG | W/S+ | Non W/S+ ` | No Hitter | Perfect Game |
2008 | NYA | 33 | 10 | 3.30 | 0 | 0 | 0 | 0 | 33 | 0 | 0 |
2009 | NYA | 3 | 1 | 3.00 | 0 | 0 | 0 | 0 | 3 | 0 | 0 |
2010 | Ari | 385 | 32 | 12.03 | 9 | 0 | 0 | 82 | 213 | 0 | 0 |
2011 | Ari | 568 | 33 | 17.21 | 21 | 0 | 1 | 230 | 123 | 0 | 0 |
2012 | Ari | 400 | 32 | 12.50 | 15 | 0 | 0 | 154 | 96 | 0 | 0 |
2013 | Ari-SD | 179 | 20 | 8.95 | 3 | 0 | 0 | 20 | 129 | 0 | 0 |
2013 | Ari-SD | 105 | 10 | 10.50 | 3 | 0 | 0 | 30 | 45 | 0 | 0 |
2014 | SD | 399 | 32 | 12.47 | 12 | 0 | 0 | 102 | 177 | 0 | 0 |
2015 | SD | 318 | 29 | 10.97 | 8 | 0 | 0 | 76 | 162 | 0 | 0 |
2016 | KC | 386 | 32 | 12.06 | 11 | 0 | 2 | 108 | 168 | 0 | 0 |
2017 | KC | 236 | 30 | 7.87 | 5 | 0 | 0 | 48 | 138 | 0 | 0 |
2018 | KC | 218 | 22 | 9.91 | 3 | 0 | 0 | 32 | 156 | 0 | 0 |
2019 | KC | 448 | 63 | 7.11 | 3 | 30 | 0 | 52 | 66 | 0 | 0 |
2020 | KC | 21 | 15 | 1.40 | 0 | 0 | 0 | 0 | 21 | 0 | 0 |
2021 | Ari | 390 | 55 | 7.09 | 3 | 26 | 0 | 52 | 48 | 0 | 0 |
2022 | Ari | 227 | 56 | 4.05 | 4 | 10 | 0 | 24 | 63 | 0 | 0 |
2023 | Tex | 24 | 16 | 1.50 | 0 | 0 | 0 | 0 | 24 | 0 | 0 |