Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 17.5 ms
Record Count: 5
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))),
tbR=SUM(feeds.total_bases),
rbiR=SUM(feeds.rbi),
runR=SUM(feeds.runs),
sbR=SUM(feeds.stolen_bases),
bbR=SUM(feeds.bb),
cR=SUM(feeds.c_games),
b1R=SUM(feeds.fb_games),
b2R=SUM(feeds.sb_games),
ssR=SUM(feeds.ss_games),
b3R=SUM(feeds.tb_games),
outR=SUM(feeds.of_games),
dhR=SUM(feeds.dh_games),
(select sum(dailystats.doubles) from dailystats where player=feeds.player and date like CONCAT(substring(feeds.period,1,4), '%')) as doubler,
(select sum(dailystats.triples) from dailystats where player=feeds.player and date like CONCAT(substring(feeds.period,1,4), '%')) as tripler,
(select sum(dailystats.hr) from dailystats where player=feeds.player and date like CONCAT(substring(feeds.period,1,4), '%')) as hrr,
proteam,year=substring(period,1,4)
from feeds
WHERE player = '11662' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
118121.57540211000001000Oak2020
2167782.14102559532223157800000213010Tex2021
32951212.4380164155475024110800000820115Tex2022
43851273.031496193915924012300000827017Tex2023
5102333.0909095125181732000003304Tex2024
Mr. Sports

Jonah Heim

Catcher
Texas Rangers
Birthday: June 27, 1995   Age: 28
Yearly Stats
General Info Hitting Breakdown Games by Position Breakdown
Year Proteam Points Games PPG Doubles Triples HR Total Bases RBI Run SB BB C 1B 2B SS 3B OF DH
2020 Oak 18 12 1.50 0 0 0 7 5 4 0 2 11 0 0 0 0 0 1
2021 Tex 167 78 2.14 13 0 10 95 32 22 3 15 78 0 0 0 0 0 2
2022 Tex 295 121 2.44 20 1 15 155 47 50 2 41 108 0 0 0 0 0 8
2023 Tex 385 127 3.03 27 0 17 193 91 59 2 40 123 0 0 0 0 0 8
2024 Tex 102 33 3.09 3 0 4 51 25 18 1 7 32 0 0 0 0 0 3