Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 7.42 ms
Record Count: 9
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 = '9173'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
168242.833333320064200222SD2012
2321.5000030002SD2013
398109.8202264200100SD2014
44923215.375180118412300311StL2018
53583211.18759029217100320StL2019
67998.77777820020390090StL2021
74403213.75120013418600320StL2022
8317349.3235299009812900340StL2023
95586.87520014210080StL2024
Mr. Sports

Miles Mikolas

Starting Pitcher
St. Louis Cardinals
Birthday: August 23, 1988   Age: 35
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2012 SD 68 24 2.83 2 0 0 6 42 0 0
2013 SD 3 2 1.50 0 0 0 0 3 0 0
2014 SD 98 10 9.80 2 0 2 26 42 0 0
2018 StL 492 32 15.38 18 0 1 184 123 0 0
2019 StL 358 32 11.19 9 0 2 92 171 0 0
2021 StL 79 9 8.78 2 0 0 20 39 0 0
2022 StL 440 32 13.75 12 0 0 134 186 0 0
2023 StL 317 34 9.32 9 0 0 98 129 0 0
2024 StL 55 8 6.88 2 0 0 14 21 0 0