Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 6.11 ms
Record Count: 4
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 = '11926'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
120541021000050LAA2021
22682510.727017810510250LAA2022
3259289.254004217700280LAA2023
481711.57142830030210070LAA2024
Mr. Sports

Reid Detmers

Starting Pitcher
Los Angeles Angels
Birthday: July 08, 1999   Age: 24
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2021 LAA 20 5 4.00 1 0 2 10 0 0 0
2022 LAA 268 25 10.72 7 0 1 78 105 1 0
2023 LAA 259 28 9.25 4 0 0 42 177 0 0
2024 LAA 81 7 11.57 3 0 0 30 21 0 0