Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 680 ms
Record Count: 17
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 = '7914' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
14461233.62601642408667746000111902TB2008
26011573.828025630711310097200001510344033TB2009
35781513.827814629110496157200001510045522TB2010
44991333.7518797239997838000001310326131TB2011
5251713.5352113131523523100004702514014TB2012
65111513.3841062827783168000011401236329TB2013
74771563.0576923245908155600001500825122TB2014
84361522.8684212457168250000014201031119TB2015
95421573.4522293327967904000001500841634TB2016
101352.673201000040136220SF2017
114551513.0132452538369545000013801336220TB2017
123281242.6451614198545132200001230025416SF2018
133711272.9212599198695934200001170019220SF2019
14147512.8823528822826011000052001017SF2020
15249803.112512246451350000780017013SF2021
16220882.5120423102700006801713014SF2022
17168742.27027039030250230000400269011Ari2023
Mr. Sports

Evan Longoria

3rd Baseman
Free Agent
Birthday: October 07, 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
2008 TB 446 123 3.63 * * * 240 86 67 7 46 0 0 0 1 119 0 2
2009 TB 601 157 3.83 44 0 33 307 113 100 9 72 0 0 0 0 151 0 3
2010 TB 578 151 3.83 45 5 22 291 104 96 15 72 0 0 0 0 151 0 0
2011 TB 499 133 3.75 26 1 31 239 99 78 3 80 0 0 0 0 131 0 3
2012 TB 251 71 3.54 14 0 14 131 52 35 2 31 0 0 0 0 47 0 25
2013 TB 511 151 3.38 36 3 29 282 77 83 1 68 0 0 0 0 114 0 12
2014 TB 477 156 3.06 25 1 22 245 90 81 5 56 0 0 0 0 150 0 8
2015 TB 436 152 2.87 31 1 19 245 71 68 2 50 0 0 0 0 142 0 10
2016 TB 542 157 3.45 41 6 34 327 96 79 0 40 0 0 0 0 150 0 8
2017 TB 13 5 2.60 36 2 20 7 3 2 0 1 0 0 0 0 4 0 1
SF 455 151 3.01 36 2 20 253 83 69 5 45 0 0 0 0 138 0 13
2018 SF 328 124 2.65 25 4 16 198 54 51 3 22 0 0 0 0 123 0 0
2019 SF 371 127 2.92 19 2 20 198 69 59 3 42 0 0 0 0 117 0 0
2020 SF 147 51 2.88 10 1 7 82 28 26 0 11 0 0 0 0 52 0 0
2021 SF 249 80 3.11 17 0 13 122 46 45 1 35 0 0 0 0 78 0 0
2022 SF 220 88 2.50 13 0 14 120 42 31 0 27 0 0 0 0 68 0 17
2023 Ari 168 74 2.27 9 0 11 90 30 25 0 23 0 0 0 0 40 0 26