Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 92.7 ms
Record Count: 12
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 = '9385' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
1188702.68571421073231513000006901743Mia2013
24581513.0331125257857234100000152026523Mia2014
32831152.4608696167414522800000116026010Mia2015
44391463.0068493249747304300000140022623Mia2016
56161593.8742143341249316400000153230237Mia2017
64451473.027211249876743800000146015223StL2018
74681283.656252288879126100000127023129StL2019
8273594.6271186142553803800000213814018Atl2020
9133482.770833367262101900000480607Atl2021
103281232.6666667187535523100000527118022Atl2022
115711473.88435363171069005800000214629140Atl2023
12160344.7058825823823017000000346012Atl2024
Mr. Sports

Marcell Ozuna

Designated Hitter
Atlanta Braves
Birthday: November 12, 1990   Age: 33
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
2013 Mia 188 70 2.69 17 4 3 107 32 31 5 13 0 0 0 0 0 69 0
2014 Mia 458 151 3.03 26 5 23 257 85 72 3 41 0 0 0 0 0 152 0
2015 Mia 283 115 2.46 26 0 10 167 41 45 2 28 0 0 0 0 0 116 0
2016 Mia 439 146 3.01 22 6 23 249 74 73 0 43 0 0 0 0 0 140 0
2017 Mia 616 159 3.87 30 2 37 334 124 93 1 64 0 0 0 0 0 153 2
2018 StL 445 147 3.03 15 2 23 249 87 67 4 38 0 0 0 0 0 146 0
2019 StL 468 128 3.66 23 1 29 228 88 79 12 61 0 0 0 0 0 127 0
2020 Atl 273 59 4.63 14 0 18 142 55 38 0 38 0 0 0 0 0 21 38
2021 Atl 133 48 2.77 6 0 7 67 26 21 0 19 0 0 0 0 0 48 0
2022 Atl 328 123 2.67 18 0 22 187 53 55 2 31 0 0 0 0 0 52 71
2023 Atl 571 147 3.88 29 1 40 317 106 90 0 58 0 0 0 0 0 2 146
2024 Atl 160 34 4.71 6 0 12 82 38 23 0 17 0 0 0 0 0 0 34