Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 7.9 ms
Record Count: 13
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 = '8680'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
12722411.3333338006612600222Cin2010
23572912.310345120012011700263Cin2011
33323011.0666678019415300291Cin2012
44313014.366667140015014100300Cin2013
54063212.6875110011018600311Cin2014
62571913.526316700949300170Cin2015
796910.66666720022540090SF2015
83113010.3666679009212900300StL2016
98051630026240050Sea2017
102962611.3846157018214400250StL2017
113623111.67742100310615600310Sea2018
12107119.727273300205700110Ari2019
132782113.238095902889000210Sea2019
Mr. Sports

Mike Leake

Starting Pitcher

Birthday: November 12, 1987   Age: 36
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2010 Cin 272 24 11.33 8 0 0 66 126 0 0
2011 Cin 357 29 12.31 12 0 0 120 117 0 0
2012 Cin 332 30 11.07 8 0 1 94 153 0 0
2013 Cin 431 30 14.37 14 0 0 150 141 0 0
2014 Cin 406 32 12.69 11 0 0 110 186 0 0
2015 Cin-SF 257 19 13.53 7 0 0 94 93 0 0
2015 Cin-SF 96 9 10.67 2 0 0 22 54 0 0
2016 StL 311 30 10.37 9 0 0 92 129 0 0
2017 StL-Sea 80 5 16.00 3 0 0 26 24 0 0
2017 StL-Sea 296 26 11.38 7 0 1 82 144 0 0
2018 Sea 362 31 11.68 10 0 3 106 156 0 0
2019 Sea-Ari 107 11 9.73 3 0 0 20 57 0 0
2019 Sea-Ari 278 21 13.24 9 0 2 88 90 0 0