Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 19 ms
Record Count: 18
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 = '8410'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
13493210.90625100010214700320Oak2009
24853016.16666618012227800300Oak2010
34143412.176471120013815600340Oak2011
44093212.78125130212814100320Ari2012
52842511.367005815600223Ari2013
6181306.03333333102411700219Ari2014
70100000000102015
824112.181818200002400110Ari2015
9632000060003Atl2015
103484.251006180026ChN2015
11144483300189600939ChN2016
1221102.10000210037KC2017
131201110.909091400443600110SD2017
1418118100800001LAA2018
152042010.2601549000200Oak2018
16159374.29729754002099001126LAA2019
1750114.54545451004360065SF2020
185696.222222310010360081Pit2021
Mr. Sports

Trevor Cahill

Starting Pitcher
Free Agent
Birthday: March 01, 1988   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
2009 Oak 349 32 10.91 10 0 0 102 147 0 0
2010 Oak 485 30 16.17 18 0 1 222 78 0 0
2011 Oak 414 34 12.18 12 0 0 138 156 0 0
2012 Ari 409 32 12.78 13 0 2 128 141 0 0
2013 Ari 284 25 11.36 7 0 0 58 156 0 0
2014 Ari 181 30 6.03 3 1 0 24 117 0 0
2015 Ari-Atl-ChN 0 1 0.00 0 0 0 0 0 0 0
2015 Ari-Atl-ChN 24 11 2.18 0 0 0 0 24 0 0
2015 Ari-Atl-ChN 6 3 2.00 0 0 0 0 6 0 0
2015 Ari-Atl-ChN 34 8 4.25 1 0 0 6 18 0 0
2016 ChN 144 48 3.00 3 0 0 18 96 0 0
2017 SD-KC 21 10 2.10 0 0 0 0 21 0 0
2017 SD-KC 120 11 10.91 4 0 0 44 36 0 0
2018 Oak-LAA 18 1 18.00 1 0 0 8 0 0 0
2018 Oak-LAA 204 20 10.20 6 0 1 54 90 0 0
2019 LAA 159 37 4.30 4 0 0 20 99 0 0
2020 SF 50 11 4.55 1 0 0 4 36 0 0
2021 Pit 56 9 6.22 1 0 0 10 36 0 0