Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 7.74 ms
Record Count: 16
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 = '7599'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
11401410501404500113Fla2005
2481241008300057Fla2006
3623000060020NYN2007
441410.251004270022NYN2009
5103195.4210525200206300127Sea2009
63773112.161299009818900310Sea2010
74133212.90625100312417400320Sea2011
84413213.78125140013616500320Sea2012
92562211.636364801967500220LAA2013
103872913.344828110113413800281KC2014
11101911.2222225004290081KC2015
1227390000270030KC2016
134213213.1562518011825400320KC2017
14198219.428572804764200210NYN2018
152101911.052631603529300181NYN2019
1672116.545454510085400110Phi2019
Mr. Sports

Jason Vargas

Starting Pitcher

Birthday: February 02, 1983   Age: 41
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2005 Fla 140 14 10.00 5 0 1 40 45 0 0
2006 Fla 48 12 4.00 1 0 0 8 30 0 0
2007 NYN 6 2 3.00 0 0 0 0 6 0 0
2009 NYN-Sea 41 4 10.25 1 0 0 4 27 0 0
2009 NYN-Sea 103 19 5.42 2 0 0 20 63 0 0
2010 Sea 377 31 12.16 9 0 0 98 189 0 0
2011 Sea 413 32 12.91 10 0 3 124 174 0 0
2012 Sea 441 32 13.78 14 0 0 136 165 0 0
2013 LAA 256 22 11.64 8 0 1 96 75 0 0
2014 KC 387 29 13.34 11 0 1 134 138 0 0
2015 KC 101 9 11.22 5 0 0 42 9 0 0
2016 KC 27 3 9.00 0 0 0 0 27 0 0
2017 KC 421 32 13.16 18 0 1 182 54 0 0
2018 NYN 198 21 9.43 8 0 4 76 42 0 0
2019 NYN-Phi 210 19 11.05 6 0 3 52 93 0 0
2019 NYN-Phi 72 11 6.55 1 0 0 8 54 0 0