Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 28.3 ms
Record Count: 15
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 = '8200' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
1220752.93333341044634135003494500Bos2008
240241.6666666181150600227400202Bos2009
3171543.16666679024311250728231001409Bos2010
4218882.477272711836401230415033021446Bos2011
5277942.946808614942422420008700018016Hou2012
64551493.05369142587176149002492001044214Oak2013
73251292.519379917146570510001230042637Oak2014
8182642.843759130341260001743021409Hou2015
9188842.23809531062729026007920051212Oak2016
104851533.16993472567086073001360101450314Oak2017
112263.6666667135301005000137123NYN2018
125001513.31125832549475077001310140337123Oak2018
13170.14285715000010000000000NYN2019
143551392.5539567182695504900710106028014Oak2021
1590501.844161411503200041503Oak2022
Mr. Sports

Jed Lowrie

3rd Baseman

Birthday: April 17, 1984   Age: 40
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 Bos 220 75 2.93 * * * 104 46 34 1 35 0 0 3 49 45 0 0
2009 Bos 40 24 1.67 2 0 2 18 11 5 0 6 0 0 2 27 4 0 0
2010 Bos 171 54 3.17 14 0 9 90 24 31 1 25 0 7 28 23 1 0 0
2011 Bos 218 88 2.48 14 4 6 118 36 40 1 23 0 4 1 50 33 0 2
2012 Hou 277 94 2.95 18 0 16 149 42 42 2 42 0 0 0 87 0 0 0
2013 Oak 455 149 3.05 44 2 14 258 71 76 1 49 0 0 24 92 0 0 10
2014 Oak 325 129 2.52 26 3 7 171 46 57 0 51 0 0 0 123 0 0 4
2015 Hou 182 64 2.84 14 0 9 91 30 34 1 26 0 0 0 17 43 0 2
2016 Oak 188 84 2.24 12 1 2 106 27 29 0 26 0 0 79 2 0 0 5
2017 Oak 485 153 3.17 50 3 14 256 70 86 0 73 0 0 136 0 1 0 14
2018 Oak 22 6 3.67 37 1 23 13 5 3 0 1 0 0 5 0 0 0 1
NYN 500 151 3.31 37 1 23 254 94 75 0 77 0 0 131 0 14 0 3
2019 NYN 1 7 0.14 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0
2021 Oak 355 139 2.55 28 0 14 182 69 55 0 49 0 0 71 0 1 0 60
2022 Oak 90 50 1.80 5 0 3 44 16 14 1 15 0 3 2 0 0 0 41