Query Template: /baseball/players/yearly-stats.cfm:56 Execution Time: 19 ms Record Count: 18 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 = '8410' 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 | 349 | 32 | 10.90625 | 10 | 0 | 0 | 102 | 147 | 0 | 0 | 32 | 0 | Oak | 2009 | |
2 | 485 | 30 | 16.166666 | 18 | 0 | 1 | 222 | 78 | 0 | 0 | 30 | 0 | Oak | 2010 | |
3 | 414 | 34 | 12.176471 | 12 | 0 | 0 | 138 | 156 | 0 | 0 | 34 | 0 | Oak | 2011 | |
4 | 409 | 32 | 12.78125 | 13 | 0 | 2 | 128 | 141 | 0 | 0 | 32 | 0 | Ari | 2012 | |
5 | 284 | 25 | 11.36 | 7 | 0 | 0 | 58 | 156 | 0 | 0 | 22 | 3 | Ari | 2013 | |
6 | 181 | 30 | 6.0333333 | 3 | 1 | 0 | 24 | 117 | 0 | 0 | 21 | 9 | Ari | 2014 | |
7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2015 | ||
8 | 24 | 11 | 2.1818182 | 0 | 0 | 0 | 0 | 24 | 0 | 0 | 11 | 0 | Ari | 2015 | |
9 | 6 | 3 | 2 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 3 | Atl | 2015 | |
10 | 34 | 8 | 4.25 | 1 | 0 | 0 | 6 | 18 | 0 | 0 | 2 | 6 | ChN | 2015 | |
11 | 144 | 48 | 3 | 3 | 0 | 0 | 18 | 96 | 0 | 0 | 9 | 39 | ChN | 2016 | |
12 | 21 | 10 | 2.1 | 0 | 0 | 0 | 0 | 21 | 0 | 0 | 3 | 7 | KC | 2017 | |
13 | 120 | 11 | 10.909091 | 4 | 0 | 0 | 44 | 36 | 0 | 0 | 11 | 0 | SD | 2017 | |
14 | 18 | 1 | 18 | 1 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 1 | LAA | 2018 | |
15 | 204 | 20 | 10.2 | 6 | 0 | 1 | 54 | 90 | 0 | 0 | 20 | 0 | Oak | 2018 | |
16 | 159 | 37 | 4.2972975 | 4 | 0 | 0 | 20 | 99 | 0 | 0 | 11 | 26 | LAA | 2019 | |
17 | 50 | 11 | 4.5454545 | 1 | 0 | 0 | 4 | 36 | 0 | 0 | 6 | 5 | SF | 2020 | |
18 | 56 | 9 | 6.2222223 | 1 | 0 | 0 | 10 | 36 | 0 | 0 | 8 | 1 | Pit | 2021 |
General Info | Pitching Breakdown | ||||||||||
Year | Proteam | Points | Games | PPG | W | S | CG | W/S+ | Non W/S+ ` | No Hitter | Perfect Game |
2009 | Oak | 349 | 32 | 10.91 | 10 | 0 | 0 | 102 | 147 | 0 | 0 |
2010 | Oak | 485 | 30 | 16.17 | 18 | 0 | 1 | 222 | 78 | 0 | 0 |
2011 | Oak | 414 | 34 | 12.18 | 12 | 0 | 0 | 138 | 156 | 0 | 0 |
2012 | Ari | 409 | 32 | 12.78 | 13 | 0 | 2 | 128 | 141 | 0 | 0 |
2013 | Ari | 284 | 25 | 11.36 | 7 | 0 | 0 | 58 | 156 | 0 | 0 |
2014 | Ari | 181 | 30 | 6.03 | 3 | 1 | 0 | 24 | 117 | 0 | 0 |
2015 | Ari-Atl-ChN | 0 | 1 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2015 | Ari-Atl-ChN | 24 | 11 | 2.18 | 0 | 0 | 0 | 0 | 24 | 0 | 0 |
2015 | Ari-Atl-ChN | 6 | 3 | 2.00 | 0 | 0 | 0 | 0 | 6 | 0 | 0 |
2015 | Ari-Atl-ChN | 34 | 8 | 4.25 | 1 | 0 | 0 | 6 | 18 | 0 | 0 |
2016 | ChN | 144 | 48 | 3.00 | 3 | 0 | 0 | 18 | 96 | 0 | 0 |
2017 | SD-KC | 21 | 10 | 2.10 | 0 | 0 | 0 | 0 | 21 | 0 | 0 |
2017 | SD-KC | 120 | 11 | 10.91 | 4 | 0 | 0 | 44 | 36 | 0 | 0 |
2018 | Oak-LAA | 18 | 1 | 18.00 | 1 | 0 | 0 | 8 | 0 | 0 | 0 |
2018 | Oak-LAA | 204 | 20 | 10.20 | 6 | 0 | 1 | 54 | 90 | 0 | 0 |
2019 | LAA | 159 | 37 | 4.30 | 4 | 0 | 0 | 20 | 99 | 0 | 0 |
2020 | SF | 50 | 11 | 4.55 | 1 | 0 | 0 | 4 | 36 | 0 | 0 |
2021 | Pit | 56 | 9 | 6.22 | 1 | 0 | 0 | 10 | 36 | 0 | 0 |