Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 55.4 ms
Record Count: 15
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 = '9054' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
1150.2100000022001000ChA2011
272431.674418633917211001392412410ChA2012
374511.450980434821011007321711000ChA2013
42121211.75206611122947024008962131000ChA2014
53081142.7017543177574822400965535830412Min2015
62091012.069306911837321210067023221426Min2016
73781292.930232520572635331010168022015521Min2017
8152522.92307698521281170000530047323Ari2018
9337983.4387755191634713500121780047323Min2018
105901563.7820513323118945500032014201291035Ari2019
11126542.333333368202211500304704734Ari2020
124721463.23287682569077148018421990026527NYN2021
133751322.840909212695703700201280625420NYN2022
1496591.6271186541517010051103602656LAA2023
1584362.33333334415152800912804656NYN2023
Mr. Sports

Eduardo Escobar

3rd Baseman
Free Agent
Birthday: January 05, 1989   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
2011 ChA 1 5 0.20 0 0 0 1 0 0 0 0 0 0 2 2 0 0 1
2012 ChA 72 43 1.67 4 1 0 33 9 17 2 11 0 0 13 9 24 1 2
2013 ChA 74 51 1.45 0 0 0 34 8 21 0 11 0 0 7 32 17 1 1
2014 ChA 212 121 1.75 0 0 0 112 29 47 0 24 0 0 8 96 21 3 1
2015 Min 308 114 2.70 30 4 12 177 57 48 2 24 0 0 9 65 5 35 8
2016 Min 209 101 2.07 14 2 6 118 37 32 1 21 0 0 6 70 23 2 2
2017 Min 378 129 2.93 15 5 21 205 72 63 5 33 1 0 10 16 80 2 20
2018 Min 152 52 2.92 47 3 23 85 21 28 1 17 0 0 0 0 53 0 0
Ari 337 98 3.44 47 3 23 191 63 47 1 35 0 0 1 21 78 0 0
2019 Ari 590 156 3.78 29 10 35 323 118 94 5 50 0 0 32 0 142 0 1
2020 Ari 126 54 2.33 7 3 4 68 20 22 1 15 0 0 3 0 47 0 4
2021 NYN 472 146 3.23 26 5 27 256 90 77 1 48 0 18 42 1 99 0 0
2022 NYN 375 132 2.84 25 4 20 212 69 57 0 37 0 0 2 0 128 0 6
2023 NYN 96 59 1.63 6 5 6 54 15 17 0 10 0 5 11 0 36 0 2
LAA 84 36 2.33 6 5 6 44 15 15 2 8 0 0 9 1 28 0 4