Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 1682 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 = '10765' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
1181563.232143883133920000005608011ChA2020
2260683.823529515543426140000067122113ChA2021
3300933.2258065162565411170000091418012ChA2022
45091423.5845072898090203000000142035136ChA2023
52373.28571441443110000070202ChA2024
Mr. Sports

Luis Robert

Outfielder
Chicago White Sox
Birthday: August 03, 1997   Age: 26
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 ChA 181 56 3.23 8 0 11 88 31 33 9 20 0 0 0 0 0 56 0
2021 ChA 260 68 3.82 22 1 13 155 43 42 6 14 0 0 0 0 0 67 1
2022 ChA 300 93 3.23 18 0 12 162 56 54 11 17 0 0 0 0 0 91 4
2023 ChA 509 142 3.58 35 1 36 289 80 90 20 30 0 0 0 0 0 142 0
2024 ChA 23 7 3.29 2 0 2 14 4 3 1 1 0 0 0 0 0 7 0