Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 317 ms
Record Count: 14
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 = '7812' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
141251.6423853200000250Sea2006
252271.925926264162400000380Sea2007
33411312.603053318957611024000001290Bal2008
44161203.46666672167183103600000120022319Bal2009
54301482.9054055256687672300000149025519Bal2010
64551463.11643842638368122900000149226225Bal2011
75591593.515723232581103163400000156139332Bal2012
85561553.587096731510698132400000125435132Bal2013
94941533.228758291918671900000149430227Bal2014
104311343.216418249837232400000131324326Bal2015
114781473.2517006269838523900000149019029Bal2016
124621473.142857278738222700000147028126Bal2017
133911442.7152777243635472400000138635015Bal2018
143671332.7593985201676623100000129025116Ari2019
Mr. Sports

Adam Jones

Outfielder

Birthday: August 01, 1985   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
2006 Sea 41 25 1.64 * * * 23 8 5 3 2 0 0 0 0 0 25 0
2007 Sea 52 27 1.93 * * * 26 4 16 2 4 0 0 0 0 0 38 0
2008 Bal 341 131 2.60 * * * 189 57 61 10 24 0 0 0 0 0 129 0
2009 Bal 416 120 3.47 22 3 19 216 71 83 10 36 0 0 0 0 0 120 0
2010 Bal 430 148 2.91 25 5 19 256 68 76 7 23 0 0 0 0 0 149 0
2011 Bal 455 146 3.12 26 2 25 263 83 68 12 29 0 0 0 0 0 149 2
2012 Bal 559 159 3.52 39 3 32 325 81 103 16 34 0 0 0 0 0 156 1
2013 Bal 556 155 3.59 35 1 32 315 106 98 13 24 0 0 0 0 0 125 4
2014 Bal 494 153 3.23 30 2 27 291 91 86 7 19 0 0 0 0 0 149 4
2015 Bal 431 134 3.22 24 3 26 249 83 72 3 24 0 0 0 0 0 131 3
2016 Bal 478 147 3.25 19 0 29 269 83 85 2 39 0 0 0 0 0 149 0
2017 Bal 462 147 3.14 28 1 26 278 73 82 2 27 0 0 0 0 0 147 0
2018 Bal 391 144 2.72 35 0 15 243 63 54 7 24 0 0 0 0 0 138 6
2019 Ari 367 133 2.76 25 1 16 201 67 66 2 31 0 0 0 0 0 129 0