Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 42.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 = '10239' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
115151724110050063300SD2020
2121811.49382717014199900181892401004Bal2021
33561442.47222231845062342600014600024713Bal2022
42551102.3181818109345832220001090421427Bal2023
550212.3809524265105400151032602Bal2024
Mr. Sports

Jorge Mateo

2nd Baseman
Baltimore Orioles
Birthday: June 23, 1995   Age: 28
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 SD 15 15 1.00 3 0 0 7 2 4 1 1 0 0 5 0 0 6 3
2021 Bal 121 81 1.49 10 0 4 70 14 19 9 9 0 0 18 18 9 24 0
2022 Bal 356 144 2.47 24 7 13 184 50 62 34 26 0 0 0 146 0 0 0
2023 Bal 255 110 2.32 14 2 7 109 34 58 32 22 0 0 0 109 0 4 2
2024 Bal 50 21 2.38 6 0 2 26 5 10 5 4 0 0 15 1 0 3 2