Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 23.6 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 = '11853' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
12282.751434017000001201Tor2020
2134582.31034572241901944000008808Tor2021
33801372.7737226195635906376000005019014Tor2022
42521202.113343340429900000171608Tor2023
544231.91304352110301023000000301Tor2024
Mr. Sports

Alejandro Kirk

Catcher
Toronto Blue Jays
Birthday: November 06, 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 Tor 22 8 2.75 2 0 1 14 3 4 0 1 7 0 0 0 0 0 1
2021 Tor 134 58 2.31 8 0 8 72 24 19 0 19 44 0 0 0 0 0 8
2022 Tor 380 137 2.77 19 0 14 195 63 59 0 63 76 0 0 0 0 0 50
2023 Tor 252 120 2.10 16 0 8 133 43 34 0 42 99 0 0 0 0 0 17
2024 Tor 44 23 1.91 3 0 1 21 10 3 0 10 23 0 0 0 0 0 0