Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 19.5 ms
Record Count: 16
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 = '8185'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
1951.8000090050Phi2009
21929.5100630020Cle2010
3705141006540050Phi2010
42452111.666667800788700210Cle2011
565154.33333351004510096Cle2013
6272377.351351371176111001720Cle2014
74082814.571428140215010800280Cle2015
83092412.87510011208400240Cle2016
94793214.9687518011989600320Cle2017
104603214.375170416012000284Cle2018
11169237.3478266125242001111Cle2019
121511212.583333301348700120Cle2020
1381126.7510086300120NYN2021
143432812.2515001365700280NYN2022
15114205.7300364800200NYN2023
165778.14285820016210070Cle2024
Mr. Sports

Carlos Carrasco

Starting Pitcher
Cleveland Guardians
Birthday: March 21, 1987   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
2009 Phi 9 5 1.80 0 0 0 0 9 0 0
2010 Phi-Cle 19 2 9.50 1 0 0 6 3 0 0
2010 Phi-Cle 70 5 14.00 1 0 0 6 54 0 0
2011 Cle 245 21 11.67 8 0 0 78 87 0 0
2013 Cle 65 15 4.33 1 0 0 4 51 0 0
2014 Cle 272 37 7.35 7 1 1 76 111 0 0
2015 Cle 408 28 14.57 14 0 2 150 108 0 0
2016 Cle 309 24 12.88 10 0 1 120 84 0 0
2017 Cle 479 32 14.97 18 0 1 198 96 0 0
2018 Cle 460 32 14.38 17 0 4 160 120 0 0
2019 Cle 169 23 7.35 6 1 2 52 42 0 0
2020 Cle 151 12 12.58 3 0 1 34 87 0 0
2021 NYN 81 12 6.75 1 0 0 8 63 0 0
2022 NYN 343 28 12.25 15 0 0 136 57 0 0
2023 NYN 114 20 5.70 3 0 0 36 48 0 0
2024 Cle 57 7 8.14 2 0 0 16 21 0 0