Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 30.8 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 = '8762' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
12573.571428515621100000601011KC2010
281352.31428584571568000003301011Mil2010
31362.1666667714010000060100KC2011
4176602.9333334933127101500000601927KC2012
52771082.564814813245541333000009711934KC2013
63341222.737705182505127240000012512745KC2014
74661323.5303032426896263400000131330614KC2015
83201033.106796163565614310000010201919KC2016
94751553.0645162595086265400000151327515KC2017
104541403.24285722253890307100000138025210Mil2018
114011452.76551722104875185000000144030011Mil2019
121653.2724030000050100Mil2020
13218782.794871810336401326000007001308Mil2021
1470421.6666666349172800000420501Mil2022
Mr. Sports

Lorenzo Cain

Outfielder

Birthday: April 13, 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 Mil 25 7 3.57 10 1 1 15 6 2 1 1 0 0 0 0 0 6 0
KC 81 35 2.31 10 1 1 45 7 15 6 8 0 0 0 0 0 33 0
2011 KC 13 6 2.17 1 0 0 7 1 4 0 1 0 0 0 0 0 6 0
2012 KC 176 60 2.93 9 2 7 93 31 27 10 15 0 0 0 0 0 60 1
2013 KC 277 108 2.56 19 3 4 132 45 54 13 33 0 0 0 0 0 97 1
2014 KC 334 122 2.74 27 4 5 182 50 51 27 24 0 0 0 0 0 125 1
2015 KC 466 132 3.53 30 6 14 242 68 96 26 34 0 0 0 0 0 131 3
2016 KC 320 103 3.11 19 1 9 163 56 56 14 31 0 0 0 0 0 102 0
2017 KC 475 155 3.06 27 5 15 259 50 86 26 54 0 0 0 0 0 151 3
2018 Mil 454 140 3.24 25 2 10 225 38 90 30 71 0 0 0 0 0 138 0
2019 Mil 401 145 2.77 30 0 11 210 48 75 18 50 0 0 0 0 0 144 0
2020 Mil 16 5 3.20 1 0 0 7 2 4 0 3 0 0 0 0 0 5 0
2021 Mil 218 78 2.79 13 0 8 103 36 40 13 26 0 0 0 0 0 70 0
2022 Mil 70 42 1.67 5 0 1 34 9 17 2 8 0 0 0 0 0 42 0