Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 39.1 ms
Record Count: 19
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 = '8619' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
1155463.3695652702223337400000051306Cle2010
25171553.3354838252798459795660000135227Cle2011
34541413.21985822127672391972100012627218Cle2012
44601483.1081082306970289781900003134119Cle2013
54881453.3655171227826741081190002602025027Cle2014
64591443.1875202786710101012300002125218Cle2015
75581553.6282858759906300009128334Cle2016
85141483.4729729254789058701340007737323Cle2017
9861.333333461001060000037323Phi2017
101772.428571593104000070026224Cle2018
114951543.214285621983812106014900120026224Phi2018
126091583.8544304295931103108013500002330134Cle2019
13183603.0572303404706000000708Cle2020
144141582.6202531926966186013600001915019KC2021
15134522.576923160211703604200001018019KC2022
16201742.716216397383303303300003818019Sea2022
17193533.641509510035370210520000332022Mil2023
18265902.944444412848416420820000832022Pit2023
1970322.18753713901103000002404Min2024
Mr. Sports

Carlos Santana

1st Baseman
Minnesota Twins
Birthday: April 08, 1986   Age: 38
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
2010 Cle 155 46 3.37 13 0 6 70 22 23 3 37 40 0 0 0 0 0 5
2011 Cle 517 155 3.34 35 2 27 252 79 84 5 97 95 66 0 0 0 0 1
2012 Cle 454 141 3.22 27 2 18 212 76 72 3 91 97 21 0 0 0 1 26
2013 Cle 460 148 3.11 34 1 19 230 69 70 2 89 78 19 0 0 0 0 31
2014 Cle 488 145 3.37 25 0 27 227 82 67 4 108 11 90 0 0 26 0 20
2015 Cle 459 144 3.19 25 2 18 202 78 67 10 101 0 123 0 0 0 0 21
2016 Cle 558 155 3.60 28 3 34 282 85 87 5 99 0 63 0 0 0 0 91
2017 Cle 514 148 3.47 37 3 23 254 78 90 5 87 0 134 0 0 0 7 7
Phi 8 6 1.33 37 3 23 6 1 0 0 1 0 6 0 0 0 0 0
2018 Phi 17 7 2.43 26 2 24 9 3 1 0 4 0 0 0 0 7 0 0
Cle 495 154 3.21 26 2 24 219 83 81 2 106 0 149 0 0 12 0 0
2019 Cle 609 158 3.85 30 1 34 295 93 110 3 108 0 135 0 0 0 0 23
2020 Cle 183 60 3.05 7 0 8 72 30 34 0 47 0 60 0 0 0 0 0
2021 KC 414 158 2.62 15 0 19 192 69 66 1 86 0 136 0 0 0 0 19
2022 KC 134 52 2.58 18 0 19 60 21 17 0 36 0 42 0 0 0 0 10
Sea 201 74 2.72 18 0 19 97 38 33 0 33 0 33 0 0 0 0 38
2023 Pit 193 53 3.64 32 0 22 100 35 37 0 21 0 52 0 0 0 0 3
Mil 265 90 2.94 32 0 22 128 48 41 6 42 0 82 0 0 0 0 8
2024 Min 70 32 2.19 4 0 4 37 13 9 0 11 0 30 0 0 0 0 2