Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 16.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 = '11239' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
11791.8888888933020045000000Bal2020
2172832.07228927338330280033481000000Bal2021
32451162.1120691035150030002189802001Bal2022
42521122.25135424532701322091032234Bal2023
527201.3515380101001602201Bal2024
Mr. Sports

Ramon Urias

Shortstop, 3rd Baseman
Baltimore Orioles
Birthday: June 03, 1994   Age: 29
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
2020 Bal 17 9 1.89 0 0 0 9 3 3 0 2 0 0 4 5 0 0 0
2021 Bal 172 83 2.07 0 0 0 73 38 33 0 28 0 0 33 48 10 0 0
2022 Bal 245 116 2.11 0 0 1 103 51 50 0 30 0 0 21 8 98 0 2
2023 Bal 252 112 2.25 22 3 4 135 42 45 3 27 0 13 22 0 91 0 3
2024 Bal 27 20 1.35 2 0 1 15 3 8 0 1 0 1 0 0 16 0 2