Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 49.5 ms
Record Count: 20
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 = '7278' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
1141622.274193579252121400004900Cin2005
23661123.2678571907260540020010800Cin2006
34061353.00740742207666638000013400Cin2007
44411453.04137922366875161000014300Cin2008
590392.3076923441571230000390011213Cin2009
6143463.10869577624281140000460011213Tor2009
71562.593300000050116021Oak2010
8273903.033333315148441290000900016021Tor2010
93941342.94029862185570843025003607036017Tor2011
106021513.98675530211093138406500138224042Tor2012
115651423.978873328310490682074001004629136Tor2013
124741213.9173553252917125808100023927233Tor2014
135371383.89130432711058737105700007929035Tor2015
146261573.9872613151269828507500008333241Tor2016
155731573.649681626410796210402300001327038Cle2017
164621313.526717722510071363022000011116132Cle2018
172263.6666667127300010000516132Sea2018
18181444.113636594373301701200003218034NYA2019
19266654.0923076128494804104510001918034Sea2019
20114442.590909601919016000000435010ChA2020
Mr. Sports

Edwin Encarnacion

Designated Hitter

Birthday: January 07, 1983   Age: 41
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
2005 Cin 141 62 2.27 * * * 79 25 21 2 14 0 0 0 0 49 0 0
2006 Cin 366 112 3.27 * * * 190 72 60 5 40 0 2 0 0 108 0 0
2007 Cin 406 135 3.01 * * * 220 76 66 6 38 0 0 0 0 134 0 0
2008 Cin 441 145 3.04 * * * 236 68 75 1 61 0 0 0 0 143 0 0
2009 Cin 90 39 2.31 11 2 13 44 15 7 1 23 0 0 0 0 39 0 0
Tor 143 46 3.11 11 2 13 76 24 28 1 14 0 0 0 0 46 0 0
2010 Tor 15 6 2.50 16 0 21 9 3 3 0 0 0 0 0 0 5 0 1
Oak 273 90 3.03 16 0 21 151 48 44 1 29 0 0 0 0 90 0 0
2011 Tor 394 134 2.94 36 0 17 218 55 70 8 43 0 25 0 0 36 0 70
2012 Tor 602 151 3.99 24 0 42 302 110 93 13 84 0 65 0 0 1 3 82
2013 Tor 565 142 3.98 29 1 36 283 104 90 6 82 0 74 0 0 10 0 46
2014 Tor 474 121 3.92 27 2 33 252 91 71 2 58 0 81 0 0 0 2 39
2015 Tor 537 138 3.89 29 0 35 271 105 87 3 71 0 57 0 0 0 0 79
2016 Tor 626 157 3.99 33 2 41 315 126 98 2 85 0 75 0 0 0 0 83
2017 Cle 573 157 3.65 7 0 38 264 107 96 2 104 0 23 0 0 0 0 132
2018 Cle 462 131 3.53 16 1 32 225 100 71 3 63 0 22 0 0 0 0 111
Sea 22 6 3.67 16 1 32 12 7 3 0 0 0 1 0 0 0 0 5
2019 Sea 181 44 4.11 18 0 34 94 37 33 0 17 0 12 0 0 0 0 32
NYA 266 65 4.09 18 0 34 128 49 48 0 41 0 45 1 0 0 0 19
2020 ChA 114 44 2.59 5 0 10 60 19 19 0 16 0 0 0 0 0 0 43