Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 16.1 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 = '11268' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
1632510004000000100Atl2020
2122502.4461231901949000000317Atl2021
3294943.1276596163444823758000013312120Atl2022
44621383.3478262367784461108000003234116Mil2023
5159374.2972975763032318310000061105Mil2024
Mr. Sports

William Contreras

Catcher
Milwaukee Brewers
Birthday: December 24, 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 Atl 6 3 2.00 1 0 0 5 1 0 0 0 4 0 0 0 0 0 0
2021 Atl 122 50 2.44 3 1 7 61 23 19 0 19 49 0 0 0 0 0 0
2022 Atl 294 94 3.13 12 1 20 163 44 48 2 37 58 0 0 0 0 1 33
2023 Mil 462 138 3.35 34 1 16 236 77 84 4 61 108 0 0 0 0 0 32
2024 Mil 159 37 4.30 11 0 5 76 30 32 3 18 31 0 0 0 0 0 6