Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 15.7 ms
Record Count: 6
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 = '11289' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
18100.8322010000080100Ari2021
262282.2142856406100600000310305Cin2022
3030000000000020305Sea2022
4140.25001000000050305SF2022
5182902.02222238528341025000009431625Cin2023
639241.62516675500000222101Cin2024
Mr. Sports

Stuart Fairchild

Outfielder
Cincinnati Reds
Birthday: March 17, 1996   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
2021 Ari 8 10 0.80 1 0 0 3 2 2 0 1 0 0 0 0 0 8 0
2022 Sea 62 28 2.21 3 0 5 40 6 10 0 6 0 0 0 0 0 31 0
SF 0 3 0.00 3 0 5 0 0 0 0 0 0 0 0 0 0 2 0
Cin 1 4 0.25 3 0 5 0 0 1 0 0 0 0 0 0 0 5 0
2023 Cin 182 90 2.02 16 2 5 85 28 34 10 25 0 0 0 0 0 94 3
2024 Cin 39 24 1.63 1 0 1 16 6 7 5 5 0 0 0 0 0 22 2