Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 368 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 = '9098' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
1178573.12280787342802952000000718SD2012
270282.53091301826100000801SD2013
32761212.2809918138414235275310000119113SD2014
42931062.7641509142474306110140000012016LAD2015
53691213.0495868187724816111240000014227LAD2016
63491292.7054265201585004011700000027022LAD2017
73911332.9398496191686226812820000023224LAD2018
82072.857143140303700000023224Mil2018
95101533.333333324077795109137200000126228Mil2019
10152463.304347868272703032600007708ChA2020
11354923.8478261456260087808000099023ChA2021
12173971.7835052862714145705000025705ChA2022
132251151.956521712333330369160000161408ChA2023
14230.6666667100013000000000Pit2024
Mr. Sports

Yasmani Grandal

Catcher
Pittsburgh Pirates
Birthday: November 08, 1988   Age: 35
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
2012 SD 178 57 3.12 7 1 8 87 34 28 0 29 52 0 0 0 0 0 0
2013 SD 70 28 2.50 8 0 1 30 9 13 0 18 26 1 0 0 0 0 0
2014 SD 276 121 2.28 19 1 13 138 41 42 3 52 75 31 0 0 0 0 1
2015 LAD 293 106 2.76 12 0 16 142 47 43 0 61 101 4 0 0 0 0 0
2016 LAD 369 121 3.05 14 2 27 187 72 48 1 61 112 4 0 0 0 0 0
2017 LAD 349 129 2.71 27 0 22 201 58 50 0 40 117 0 0 0 0 0 0
2018 LAD 391 133 2.94 23 2 24 191 68 62 2 68 128 2 0 0 0 0 0
Mil 20 7 2.86 23 2 24 14 0 3 0 3 7 0 0 0 0 0 0
2019 Mil 510 153 3.33 26 2 28 240 77 79 5 109 137 20 0 0 0 0 1
2020 ChA 152 46 3.30 7 0 8 68 27 27 0 30 32 6 0 0 0 0 7
2021 ChA 354 92 3.85 9 0 23 145 62 60 0 87 80 8 0 0 0 0 9
2022 ChA 173 97 1.78 7 0 5 86 27 14 1 45 70 5 0 0 0 0 25
2023 ChA 225 115 1.96 14 0 8 123 33 33 0 36 91 6 0 0 0 0 16
2024 Pit 2 3 0.67 0 0 0 1 0 0 0 1 3 0 0 0 0 0 0