Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 101 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 = '10964' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
174381.94736843616170500363000000Was2020
2119701.757222901100598000000Was2021
3231902.566666614345293110030590002227Was2022
43141202.616666617050608260012000001649Was2023
596313.096774522087900300000903Was2024
Mr. Sports

Luis Garcia

2nd Baseman
Washington Nationals
Birthday: May 16, 2000   Age: 23
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 Was 74 38 1.95 0 0 0 36 16 17 0 5 0 0 36 3 0 0 0
2021 Was 119 70 1.70 0 0 0 57 22 29 0 11 0 0 59 8 0 0 0
2022 Was 231 90 2.57 22 2 7 143 45 29 3 11 0 0 30 59 0 0 0
2023 Was 314 120 2.62 16 4 9 170 50 60 8 26 0 0 120 0 0 0 0
2024 Was 96 31 3.10 9 0 3 52 20 8 7 9 0 0 30 0 0 0 0