Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 7.28 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 = '9413'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
138312.66666710010180030TB2013
247411.751018240040TB2014
3246425.85714360134147002022TB2015
4480568.5714282360643600650TB2016
5592659.1076932470782400263TB2017
61836100260003ChA2018
7160463.4782608420109000046Sea2018
8152217.23809532100201200021TB2018
9432626.9677424300563600062ChA2019
10184218.7619052120261800021ChA2020
11327664.95454554170368100066Col2021
1215953324069300053Col2022
13641.5000060013ChA2023
Mr. Sports

Alex Colome

Relief Pitcher
Free Agent
Birthday: December 31, 1988   Age: 35
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2013 TB 38 3 12.67 1 0 0 10 18 0 0
2014 TB 47 4 11.75 1 0 1 8 24 0 0
2015 TB 246 42 5.86 6 0 1 34 147 0 0
2016 TB 480 56 8.57 2 36 0 64 36 0 0
2017 TB 592 65 9.11 2 47 0 78 24 0 0
2018 TB-Sea-ChA 18 3 6.00 1 0 0 2 6 0 0
2018 TB-Sea-ChA 160 46 3.48 4 2 0 10 90 0 0
2018 TB-Sea-ChA 152 21 7.24 2 10 0 20 12 0 0
2019 ChA 432 62 6.97 4 30 0 56 36 0 0
2020 ChA 184 21 8.76 2 12 0 26 18 0 0
2021 Col 327 66 4.95 4 17 0 36 81 0 0
2022 Col 159 53 3.00 2 4 0 6 93 0 0
2023 ChA 6 4 1.50 0 0 0 0 6 0 0