Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 16.4 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 = '11206' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
176243.16666674512110800000230427Col2019
281352.31428584610133900000341226Col2020
3194782.4871795993432623000006317214Col2021
4114601.946142652300000680612Col2022
562331.8787879316154600000312503Atl2023
Mr. Sports

Sam Hilliard

Outfielder
Colorado Rockies
Birthday: February 21, 1994   Age: 30
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
2019 Col 76 24 3.17 4 2 7 45 12 11 0 8 0 0 0 0 0 23 0
2020 Col 81 35 2.31 2 2 6 46 10 13 3 9 0 0 0 0 0 34 1
2021 Col 194 78 2.49 7 2 14 99 34 32 6 23 0 0 0 0 0 63 1
2022 Col 114 60 1.90 6 1 2 46 14 26 5 23 0 0 0 0 0 68 0
2023 Atl 62 33 1.88 5 0 3 31 6 15 4 6 0 0 0 0 0 31 2