Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 7.77 ms
Record Count: 17
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 = '8458'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
127132.076923100002700013NYA2009
249222.227272720022700022NYA2010
3362556.5818186200485400055Hou2011
449163.062520022700016NYA2011
587392.230769201027500435Bos2012
6335694.855072521503013500861Pit2013
7475696.8840583310607500366Pit2014
8682759.0933333510885400768Pit2015
9383448.7045451300462700440Pit2016
10220278.1481491150262400221Was2016
11180325.6251110184200230SF2017
12117412.853658413086900041SF2018
131612371110202100023Atl2019
14142423.380952441088400042SF2019
15172237.4782612110241800023Atl2020
16539638.5555554380803900063Ari2021
17314625.0645163180386600062Ari2022
Mr. Sports

Mark Melancon

Relief Pitcher
Free Agent
Birthday: March 28, 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
2009 NYA 27 13 2.08 0 0 0 0 27 0 0
2010 NYA 49 22 2.23 2 0 0 2 27 0 0
2011 NYA-Hou 362 55 6.58 6 20 0 48 54 0 0
2011 NYA-Hou 49 16 3.06 2 0 0 2 27 0 0
2012 Bos 87 39 2.23 0 1 0 2 75 0 0
2013 Pit 335 69 4.86 2 15 0 30 135 0 0
2014 Pit 475 69 6.88 3 31 0 60 75 0 0
2015 Pit 682 75 9.09 3 51 0 88 54 0 0
2016 Pit-Was 383 44 8.70 1 30 0 46 27 0 0
2016 Pit-Was 220 27 8.15 1 15 0 26 24 0 0
2017 SF 180 32 5.63 1 11 0 18 42 0 0
2018 SF 117 41 2.85 1 3 0 8 69 0 0
2019 SF-Atl 161 23 7.00 1 11 0 20 21 0 0
2019 SF-Atl 142 42 3.38 4 1 0 8 84 0 0
2020 Atl 172 23 7.48 2 11 0 24 18 0 0
2021 Ari 539 63 8.56 4 38 0 80 39 0 0
2022 Ari 314 62 5.06 3 18 0 38 66 0 0