Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 34.1 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 = '9867' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
13001112.7027028168405613500000102816117KC2017
2168672.5074627852331029000005961624KC2018
31753.41033010000050300KC2019
458292281780500000290302Det2020
5450.8120010000050000Phi2021
Mr. Sports

Jorge Bonifacio

Outfielder
Free Agent
Birthday: June 04, 1993   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
2017 KC 300 111 2.70 16 1 17 168 40 56 1 35 0 0 0 0 0 102 8
2018 KC 168 67 2.51 16 2 4 85 23 31 0 29 0 0 0 0 0 59 6
2019 KC 17 5 3.40 3 0 0 10 3 3 0 1 0 0 0 0 0 5 0
2020 Det 58 29 2.00 3 0 2 28 17 8 0 5 0 0 0 0 0 29 0
2021 Phi 4 5 0.80 0 0 0 1 2 0 0 1 0 0 0 0 0 5 0