Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 39.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 = '10919' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
172411.7560976311222070019231000000NYN2020
288651.3538462401423011002542001000Cle2021
33651402.60714318468651434001221800026317Cle2022
44201522.76315782216276303100149000027515Cle2023
597362.69444444619195800360000711Cle2024
Mr. Sports

Andrés Gimenez

2nd Baseman
Cleveland Guardians
Birthday: September 04, 1998   Age: 25
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 NYN 72 41 1.76 0 0 0 31 12 22 0 7 0 0 19 23 10 0 0
2021 Cle 88 65 1.35 0 0 0 40 14 23 0 11 0 0 25 42 0 0 1
2022 Cle 365 140 2.61 26 3 17 184 68 65 14 34 0 0 122 18 0 0 0
2023 Cle 420 152 2.76 27 5 15 221 62 76 30 31 0 0 149 0 0 0 0
2024 Cle 97 36 2.69 7 1 1 46 19 19 5 8 0 0 36 0 0 0 0