Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 33 ms
Record Count: 19
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 = '7345' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
188471.872340448151201351000000StL2004
22401062.26415091334834223108100000StL2005
32351191.97478991324729126121400000StL2006
42321042.23076921274030134102100000StL2007
52991232.43089441745637032119200001StL2008
63471412.460992818755469501416000002316StL2009
73051312.328244215962348421357000001906StL2010
83771362.7720587219655553313720000031114StL2011
94481363.29411772527564124513130000028022StL2012
103991303.0692308229716633010450000040012StL2013
112531052.409523715136381271021100022007StL2014
122961322.242424216660343321310000012224StL2015
133851442.673611223058553391442000003838StL2016
143991362.9338236220826092813310000027118StL2017
153591222.942623199725542912050000019020StL2018
162921102.6545455166574452010940010024010StL2019
1786412.0975615216120642200000204StL2020
183001222.4590163163654532411910000020011StL2021
19130721.80555567925192577200000805StL2022
Mr. Sports

Yadier Molina

Catcher

Birthday: July 13, 1982   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
2004 StL 88 47 1.87 * * * 48 15 12 0 13 51 0 0 0 0 0 0
2005 StL 240 106 2.26 * * * 133 48 34 2 23 108 1 0 0 0 0 0
2006 StL 235 119 1.97 * * * 132 47 29 1 26 121 4 0 0 0 0 0
2007 StL 232 104 2.23 * * * 127 40 30 1 34 102 1 0 0 0 0 0
2008 StL 299 123 2.43 * * * 174 56 37 0 32 119 2 0 0 0 0 1
2009 StL 347 141 2.46 23 1 6 187 55 46 9 50 141 6 0 0 0 0 0
2010 StL 305 131 2.33 19 0 6 159 62 34 8 42 135 7 0 0 0 0 0
2011 StL 377 136 2.77 31 1 14 219 65 55 5 33 137 2 0 0 0 0 0
2012 StL 448 136 3.29 28 0 22 252 75 64 12 45 131 3 0 0 0 0 0
2013 StL 399 130 3.07 40 0 12 229 71 66 3 30 104 5 0 0 0 0 0
2014 StL 253 105 2.41 20 0 7 151 36 38 1 27 102 1 1 0 0 0 2
2015 StL 296 132 2.24 22 2 4 166 60 34 3 32 131 0 0 0 0 0 1
2016 StL 385 144 2.67 38 3 8 230 58 55 3 39 144 2 0 0 0 0 0
2017 StL 399 136 2.93 27 1 18 220 82 60 9 28 133 1 0 0 0 0 0
2018 StL 359 122 2.94 19 0 20 199 72 55 4 29 120 5 0 0 0 0 0
2019 StL 292 110 2.65 24 0 10 166 57 44 5 20 109 4 0 0 1 0 0
2020 StL 86 41 2.10 2 0 4 52 16 12 0 6 42 2 0 0 0 0 0
2021 StL 300 122 2.46 20 0 11 163 65 45 3 24 119 1 0 0 0 0 0
2022 StL 130 72 1.81 8 0 5 79 25 19 2 5 77 2 0 0 0 0 0