Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 7.03 ms
Record Count: 15
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 = '9017'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
18881140036120071Ari2011
24343114160016011400274Ari2012
33853112.419354100010218300310Ari2013
43533111.3870968008418900310Ari2014
53463011.533334110111411700300Bos2015
6113129.416667300325100120Bal2016
71901810.555555603585700180Sea2016
8277328.656258006213500320Bal2017
91961612.25501509600160Mil2018
103913311.848485140011613500330Hou2019
1124640000240042Cin2020
123892813.892858120614610810280ChN2021
138399.22222220018450081ChN2022
142792312.130435900909900230Mil2023
15924.5000090020Mil2024
Mr. Sports

Wade Miley

Starting Pitcher
Milwaukee Brewers
Birthday: November 13, 1986   Age: 37
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2011 Ari 88 8 11.00 4 0 0 36 12 0 0
2012 Ari 434 31 14.00 16 0 0 160 114 0 0
2013 Ari 385 31 12.42 10 0 0 102 183 0 0
2014 Ari 353 31 11.39 8 0 0 84 189 0 0
2015 Bos 346 30 11.53 11 0 1 114 117 0 0
2016 Sea-Bal 113 12 9.42 3 0 0 32 51 0 0
2016 Sea-Bal 190 18 10.56 6 0 3 58 57 0 0
2017 Bal 277 32 8.66 8 0 0 62 135 0 0
2018 Mil 196 16 12.25 5 0 1 50 96 0 0
2019 Hou 391 33 11.85 14 0 0 116 135 0 0
2020 Cin 24 6 4.00 0 0 0 0 24 0 0
2021 ChN 389 28 13.89 12 0 6 146 108 1 0
2022 ChN 83 9 9.22 2 0 0 18 45 0 0
2023 Mil 279 23 12.13 9 0 0 90 99 0 0
2024 Mil 9 2 4.50 0 0 0 0 9 0 0