Query Template: /baseball/players/yearly-stats.cfm:56 Execution Time: 14.4 ms Record Count: 16 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 = '8650' 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 | 87 | 18 | 4.8333335 | 1 | 1 | 0 | 10 | 57 | 0 | 0 | 2 | 16 | StL | 2011 | |
2 | 408 | 35 | 11.657143 | 18 | 0 | 0 | 162 | 66 | 0 | 0 | 30 | 5 | StL | 2012 | |
3 | 405 | 32 | 12.65625 | 14 | 0 | 0 | 136 | 129 | 0 | 0 | 32 | 0 | StL | 2013 | |
4 | 495 | 32 | 15.46875 | 15 | 0 | 1 | 154 | 186 | 0 | 0 | 31 | 1 | StL | 2014 | |
5 | 366 | 28 | 13.071428 | 11 | 0 | 0 | 130 | 126 | 0 | 0 | 26 | 1 | StL | 2015 | |
6 | 430 | 33 | 13.030303 | 11 | 0 | 0 | 110 | 210 | 0 | 0 | 32 | 1 | StL | 2017 | |
7 | 195 | 20 | 9.75 | 7 | 0 | 0 | 62 | 63 | 0 | 0 | 20 | 0 | Min | 2018 | |
8 | 96 | 10 | 9.6 | 2 | 0 | 0 | 22 | 54 | 0 | 0 | 9 | 1 | NYA | 2018 | |
9 | 14 | 1 | 14 | 1 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 1 | Tex | 2018 | |
10 | 447 | 32 | 13.96875 | 15 | 0 | 1 | 144 | 153 | 0 | 0 | 32 | 0 | Tex | 2019 | |
11 | 200 | 13 | 15.384615 | 6 | 0 | 5 | 66 | 69 | 0 | 0 | 13 | 0 | Tex | 2020 | |
12 | 395 | 28 | 14.107142 | 11 | 0 | 13 | 112 | 168 | 0 | 0 | 28 | 0 | ChA | 2021 | |
13 | 250 | 21 | 11.904762 | 8 | 0 | 1 | 80 | 90 | 0 | 0 | 21 | 0 | ChA | 2022 | |
14 | 167 | 20 | 8.35 | 6 | 0 | 0 | 38 | 69 | 0 | 0 | 20 | 0 | ChA | 2023 | |
15 | 159 | 12 | 13.25 | 7 | 0 | 0 | 56 | 33 | 0 | 0 | 12 | 0 | LAD | 2023 | |
16 | 70 | 7 | 10 | 1 | 0 | 0 | 12 | 48 | 0 | 0 | 7 | 0 | StL | 2024 |
General Info | Pitching Breakdown | ||||||||||
Year | Proteam | Points | Games | PPG | W | S | CG | W/S+ | Non W/S+ ` | No Hitter | Perfect Game |
2011 | StL | 87 | 18 | 4.83 | 1 | 1 | 0 | 10 | 57 | 0 | 0 |
2012 | StL | 408 | 35 | 11.66 | 18 | 0 | 0 | 162 | 66 | 0 | 0 |
2013 | StL | 405 | 32 | 12.66 | 14 | 0 | 0 | 136 | 129 | 0 | 0 |
2014 | StL | 495 | 32 | 15.47 | 15 | 0 | 1 | 154 | 186 | 0 | 0 |
2015 | StL | 366 | 28 | 13.07 | 11 | 0 | 0 | 130 | 126 | 0 | 0 |
2017 | StL | 430 | 33 | 13.03 | 11 | 0 | 0 | 110 | 210 | 0 | 0 |
2018 | Min-NYA-Tex | 195 | 20 | 9.75 | 7 | 0 | 0 | 62 | 63 | 0 | 0 |
2018 | Min-NYA-Tex | 96 | 10 | 9.60 | 2 | 0 | 0 | 22 | 54 | 0 | 0 |
2018 | Min-NYA-Tex | 14 | 1 | 14.00 | 1 | 0 | 0 | 4 | 0 | 0 | 0 |
2019 | Tex | 447 | 32 | 13.97 | 15 | 0 | 1 | 144 | 153 | 0 | 0 |
2020 | Tex | 200 | 13 | 15.38 | 6 | 0 | 5 | 66 | 69 | 0 | 0 |
2021 | ChA | 395 | 28 | 14.11 | 11 | 0 | 13 | 112 | 168 | 0 | 0 |
2022 | ChA | 250 | 21 | 11.90 | 8 | 0 | 1 | 80 | 90 | 0 | 0 |
2023 | ChA-LAD | 167 | 20 | 8.35 | 6 | 0 | 0 | 38 | 69 | 0 | 0 |
2023 | ChA-LAD | 159 | 12 | 13.25 | 7 | 0 | 0 | 56 | 33 | 0 | 0 |
2024 | StL | 70 | 7 | 10.00 | 1 | 0 | 0 | 12 | 48 | 0 | 0 |