Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 20.5 ms
Record Count: 17
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 = '8099'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
133103.30000330091NYA2008
2313000030001NYA2009
33853212.031259008221300320Ari2010
45683317.212122210123012300330Ari2011
54003212.515001549600311Ari2012
6179208.953002012900200Ari2013
71051010.5300304500100SD2013
83993212.46875120010217700320SD2014
93182910.9655178007616200272SD2015
103863212.0625110210816800271KC2016
11236307.8666675004813800300KC2017
12218229.9090913003215600220KC2018
13448637.1111113300526600063KC2019
1421151.400002100114KC2020
15390557.0909093260524800055Ari2021
16227564.0535714100246300056Ari2022
1724161.500002400016Tex2023
Mr. Sports

Ian Kennedy

Relief Pitcher
Free Agent
Birthday: December 19, 1984   Age: 39
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2008 NYA 33 10 3.30 0 0 0 0 33 0 0
2009 NYA 3 1 3.00 0 0 0 0 3 0 0
2010 Ari 385 32 12.03 9 0 0 82 213 0 0
2011 Ari 568 33 17.21 21 0 1 230 123 0 0
2012 Ari 400 32 12.50 15 0 0 154 96 0 0
2013 Ari-SD 179 20 8.95 3 0 0 20 129 0 0
2013 Ari-SD 105 10 10.50 3 0 0 30 45 0 0
2014 SD 399 32 12.47 12 0 0 102 177 0 0
2015 SD 318 29 10.97 8 0 0 76 162 0 0
2016 KC 386 32 12.06 11 0 2 108 168 0 0
2017 KC 236 30 7.87 5 0 0 48 138 0 0
2018 KC 218 22 9.91 3 0 0 32 156 0 0
2019 KC 448 63 7.11 3 30 0 52 66 0 0
2020 KC 21 15 1.40 0 0 0 0 21 0 0
2021 Ari 390 55 7.09 3 26 0 52 48 0 0
2022 Ari 227 56 4.05 4 10 0 24 63 0 0
2023 Tex 24 16 1.50 0 0 0 0 24 0 0