Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 29.5 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))),
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 = '10912' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
1313833.771084317949519250081000023219Mil2019
2167582.87931048732293160049000104013Mil2020
3104601.733333352191631404970010914Mil2021
4195752.6102323352303114004267114Mil2022
Mr. Sports

Keston Hiura

2nd Baseman
Detroit Tigers
Birthday: August 02, 1996   Age: 27
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 Mil 313 83 3.77 23 2 19 179 49 51 9 25 0 0 81 0 0 0 0
2020 Mil 167 58 2.88 4 0 13 87 32 29 3 16 0 0 49 0 0 0 10
2021 Mil 104 60 1.73 9 1 4 52 19 16 3 14 0 49 7 0 0 1 0
2022 Mil 195 75 2.60 7 1 14 102 32 33 5 23 0 31 14 0 0 4 26