Query Template: /baseball/players/yearly-stats.cfm:56 Execution Time: 23.9 ms Record Count: 21 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 = '6603' 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 | 375 | 31 | 12.096774 | 15 | 0 | 0 | 114 | 111 | 0 | 0 | 31 | 0 | Cle | 2001 | |
2 | 391 | 33 | 11.848485 | 13 | 0 | 0 | 144 | 117 | 0 | 0 | 33 | 0 | Cle | 2002 | |
3 | 430 | 30 | 14.333333 | 13 | 0 | 2 | 128 | 162 | 0 | 0 | 30 | 0 | Cle | 2003 | |
4 | 373 | 30 | 12.433333 | 11 | 0 | 1 | 120 | 138 | 0 | 0 | 30 | 0 | Cle | 2004 | |
5 | 394 | 29 | 13.586206 | 14 | 0 | 1 | 156 | 93 | 0 | 0 | 29 | 0 | Cle | 2005 | |
6 | 458 | 28 | 16.357143 | 12 | 0 | 5 | 166 | 147 | 0 | 0 | 28 | 0 | Cle | 2006 | |
7 | 575 | 33 | 17.424242 | 19 | 0 | 3 | 190 | 180 | 0 | 0 | 33 | 0 | Cle | 2007 | |
8 | 267 | 18 | 14.833333 | 6 | 0 | 2 | 86 | 111 | 0 | 0 | 18 | 0 | Cle | 2008 | |
9 | 380 | 17 | 22.352942 | 11 | 0 | 7 | 160 | 75 | 0 | 0 | 17 | 0 | Mil | 2008 | |
10 | 533 | 35 | 15.228572 | 20 | 0 | 1 | 226 | 102 | 0 | 0 | 35 | 0 | NYA | 2009 | |
11 | 549 | 34 | 16.147058 | 21 | 0 | 1 | 232 | 102 | 0 | 0 | 34 | 0 | NYA | 2010 | |
12 | 552 | 33 | 16.727272 | 19 | 0 | 2 | 220 | 132 | 0 | 0 | 33 | 0 | NYA | 2011 | |
13 | 421 | 27 | 15.592592 | 14 | 0 | 2 | 148 | 123 | 0 | 0 | 27 | 0 | NYA | 2012 | |
14 | 383 | 32 | 11.96875 | 14 | 0 | 1 | 124 | 114 | 0 | 0 | 30 | 0 | NYA | 2013 | |
15 | 78 | 8 | 9.75 | 3 | 0 | 0 | 24 | 24 | 0 | 0 | 8 | 0 | NYA | 2014 | |
16 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2015 | ||
17 | 241 | 26 | 9.269231 | 5 | 0 | 0 | 44 | 147 | 0 | 0 | 26 | 0 | NYA | 2015 | |
18 | 337 | 29 | 11.620689 | 9 | 0 | 2 | 92 | 150 | 0 | 0 | 27 | 0 | NYA | 2016 | |
19 | 341 | 27 | 12.62963 | 14 | 0 | 0 | 138 | 63 | 0 | 0 | 27 | 0 | NYA | 2017 | |
20 | 322 | 29 | 11.103448 | 9 | 0 | 0 | 94 | 138 | 0 | 0 | 29 | 0 | NYA | 2018 | |
21 | 186 | 23 | 8.086957 | 5 | 0 | 0 | 34 | 102 | 0 | 0 | 22 | 1 | NYA | 2019 |
General Info | Pitching Breakdown | ||||||||||
Year | Proteam | Points | Games | PPG | W | S | CG | W/S+ | Non W/S+ ` | No Hitter | Perfect Game |
2001 | Cle | 375 | 31 | 12.10 | 15 | 0 | 0 | 114 | 111 | 0 | 0 |
2002 | Cle | 391 | 33 | 11.85 | 13 | 0 | 0 | 144 | 117 | 0 | 0 |
2003 | Cle | 430 | 30 | 14.33 | 13 | 0 | 2 | 128 | 162 | 0 | 0 |
2004 | Cle | 373 | 30 | 12.43 | 11 | 0 | 1 | 120 | 138 | 0 | 0 |
2005 | Cle | 394 | 29 | 13.59 | 14 | 0 | 1 | 156 | 93 | 0 | 0 |
2006 | Cle | 458 | 28 | 16.36 | 12 | 0 | 5 | 166 | 147 | 0 | 0 |
2007 | Cle | 575 | 33 | 17.42 | 19 | 0 | 3 | 190 | 180 | 0 | 0 |
2008 | Cle-Mil | 267 | 18 | 14.83 | 6 | 0 | 2 | 86 | 111 | 0 | 0 |
2008 | Cle-Mil | 380 | 17 | 22.35 | 11 | 0 | 7 | 160 | 75 | 0 | 0 |
2009 | NYA | 533 | 35 | 15.23 | 20 | 0 | 1 | 226 | 102 | 0 | 0 |
2010 | NYA | 549 | 34 | 16.15 | 21 | 0 | 1 | 232 | 102 | 0 | 0 |
2011 | NYA | 552 | 33 | 16.73 | 19 | 0 | 2 | 220 | 132 | 0 | 0 |
2012 | NYA | 421 | 27 | 15.59 | 14 | 0 | 2 | 148 | 123 | 0 | 0 |
2013 | NYA | 383 | 32 | 11.97 | 14 | 0 | 1 | 124 | 114 | 0 | 0 |
2014 | NYA | 78 | 8 | 9.75 | 3 | 0 | 0 | 24 | 24 | 0 | 0 |
2015 | NYA- | 0 | 1 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2015 | NYA- | 241 | 26 | 9.27 | 5 | 0 | 0 | 44 | 147 | 0 | 0 |
2016 | NYA | 337 | 29 | 11.62 | 9 | 0 | 2 | 92 | 150 | 0 | 0 |
2017 | NYA | 341 | 27 | 12.63 | 14 | 0 | 0 | 138 | 63 | 0 | 0 |
2018 | NYA | 322 | 29 | 11.10 | 9 | 0 | 0 | 94 | 138 | 0 | 0 |
2019 | NYA | 186 | 23 | 8.09 | 5 | 0 | 0 | 34 | 102 | 0 | 0 |