Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 15.5 ms
Record Count: 20
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))),
wR=SUM(feeds.wins),
sR=SUM(feeds.saves),
cgR=SUM(feeds.complete_game),
wsbR=SUM(feeds.ws_points),
nwsR=SUM(feeds.nws_points),
nohR=SUM(feeds.no_hitter),
pfgR=SUM(feeds.perfect_game),startR=sum(feeds.starts),
reliefR=sum(feeds.relief),proteam,year=substring(period,1,4)
from feeds
WHERE player = '8287'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
195253.8400104500025NYA2008
2105452.333333321007500045NYA2009
3163642.546875410810500064NYA2010
4196702.8410813800070NYA2011
5162642.531252208114001945NYA2012
6217673.23880652012135003037NYA2013
7523608.7166663380743900357NYA2014
8473568.4464286310623900448ChA2015
9530628.5483885370743600557ChA2016
10226317.2903234130322400031ChA2017
11158315.096774610226600031NYA2017
12267664.04545458402411100064NYA2018
13331000030003Phi2018
141271.71428570000120007Phi2019
1524112.181818200002400210TB2021
16243366.753140343900036ChN2022
17113215.3809524160162700021Phi2022
1896224.3636365240122400121Mia2023
19245386.44736863140304500038NYN2023
2074174.35294121083600017Tex2024
Mr. Sports

David Robertson

Relief Pitcher
Texas Rangers
Birthday: April 09, 1985   Age: 39
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2008 NYA 95 25 3.80 4 0 0 10 45 0 0
2009 NYA 105 45 2.33 2 1 0 0 75 0 0
2010 NYA 163 64 2.55 4 1 0 8 105 0 0
2011 NYA 196 70 2.80 4 1 0 8 138 0 0
2012 NYA 162 64 2.53 2 2 0 8 114 0 0
2013 NYA 217 67 3.24 5 2 0 12 135 0 0
2014 NYA 523 60 8.72 3 38 0 74 39 0 0
2015 ChA 473 56 8.45 6 31 0 62 39 0 0
2016 ChA 530 62 8.55 5 37 0 74 36 0 0
2017 ChA-NYA 226 31 7.29 4 13 0 32 24 0 0
2017 ChA-NYA 158 31 5.10 6 1 0 22 66 0 0
2018 NYA-Phi 267 66 4.05 8 4 0 24 111 0 0
2018 NYA-Phi 3 3 1.00 0 0 0 0 3 0 0
2019 Phi 12 7 1.71 0 0 0 0 12 0 0
2021 TB 24 11 2.18 0 0 0 0 24 0 0
2022 ChN-Phi 243 36 6.75 3 14 0 34 39 0 0
2022 ChN-Phi 113 21 5.38 1 6 0 16 27 0 0
2023 NYN-Mia 96 22 4.36 2 4 0 12 24 0 0
2023 NYN-Mia 245 38 6.45 3 14 0 30 45 0 0
2024 Tex 74 17 4.35 2 1 0 8 36 0 0