Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 3636 ms
Record Count: 13
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 = '8990' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
133181.833333417740519100000201TB2011
210101503023400101000TB2013
3157881.784090971373301687000000000TB2014
4173662.621212883227026690000001418Tex2015
5123492.510204691821015520000031009Tex2016
6255843.035714413539461348500000214117Tex2017
71033.333333362101400000015118Hou2018
83011082.7870371145634724410400000315118Tex2018
93291102.990909163585715011100000022117Hou2019
1019101.912510111000000301NYN2020
1116141.14285726230513000001301Tex2020
1275421.78571434014120927020001514ChN2021
13107641.67187555221011965000000904Bal2022
Mr. Sports

Robinson Chirinos

Catcher
Free Agent
Birthday: June 05, 1984   Age: 39
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
2011 TB 33 18 1.83 2 0 1 17 7 4 0 5 19 1 0 0 0 0 0
2013 TB 10 10 1.00 0 0 0 5 0 3 0 2 3 4 0 0 1 0 1
2014 TB 157 88 1.78 0 0 0 71 37 33 0 16 87 0 0 0 0 0 0
2015 Tex 173 66 2.62 14 1 8 88 32 27 0 26 69 0 0 0 0 0 0
2016 Tex 123 49 2.51 10 0 9 69 18 21 0 15 52 0 0 0 0 0 3
2017 Tex 255 84 3.04 14 1 17 135 39 46 1 34 85 0 0 0 0 0 2
2018 Tex 10 3 3.33 15 1 18 6 2 1 0 1 4 0 0 0 0 0 0
Hou 301 108 2.79 15 1 18 145 63 47 2 44 104 0 0 0 0 0 3
2019 Hou 329 110 2.99 22 1 17 163 58 57 1 50 111 0 0 0 0 0 0
2020 Tex 19 10 1.90 3 0 1 12 5 1 0 1 11 0 0 0 0 0 0
NYN 16 14 1.14 3 0 1 6 2 3 0 5 13 0 0 0 0 0 1
2021 ChN 75 42 1.79 5 1 4 40 14 12 0 9 27 0 2 0 0 0 1
2022 Bal 107 64 1.67 9 0 4 55 22 10 1 19 65 0 0 0 0 0 0