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 = '11473' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
156262.1538463285132801002700401KC2021
2109382.8684215618221120400290616312Ari2022
3135612.21311477822240110100570216312KC2022
4171812.11111129029320200120062091204Ari2023
534271.259259217451709001700200Mia2024
Mr. Sports

Emmanuel Rivera

3rd Baseman, 1st Baseman
Miami Marlins
Birthday: June 29, 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
2021 KC 56 26 2.15 4 0 1 28 5 13 2 8 0 1 0 0 27 0 0
2022 KC 109 38 2.87 16 3 12 56 18 22 1 12 0 4 0 0 29 0 6
Ari 135 61 2.21 16 3 12 78 22 24 0 11 0 1 0 0 57 0 2
2023 Ari 171 81 2.11 12 0 4 90 29 32 0 20 0 12 0 0 62 0 9
2024 Mia 34 27 1.26 2 0 0 17 4 5 1 7 0 9 0 0 17 0 0