WordPress database error: [Got error -1 from storage engine]select
a.PLAYERID as PLAYER_ID,
a.FULLNAME as NAME,
a.LASTNAME,
a.FIRSTNAME,
a.FIRST_YEAR_MLB,
a.LAST_YEAR_MLB,
a.FIRST_YEAR_MILB,
a.LAST_YEAR_MILB,
c.team_abbrev as team_abbrev,
c.team_full as TEAMS,
c.position_txt as POS,
c.position_txt as playerPos,
d.G,
d.IP,
round(d.DRA_PWARP,1) as DRA_PWARP,
round(d.DRA,3) as DRA,
round(100*d.SO/d.PA,1) as SO_pct,
round(100*d.BB/d.PA,1) as BB_pct,
round(100*d.GB_PERCENT,1) as GB_pct,
e.PA as batPA,
round(e.AVG,3) as AVG,
round(e.OBP,3) as OBP,
round(e.SLG,3) as SLG,
e.HR,
round(e.EQA,3) as TAv,
round(e.WARP,1) as batWARP
from
gfunk.mlbam_players c
left join
gfunk.MasterPlayer_dd a on c.player_id = a.MLBCODE
left join
gfunk.hp_most_searched b on a.PLAYERID = b.PLAYERID
left join
gfunk.dyna_pitcher_season d on (a.PLAYERID = d.pitcher and d.year=2019)
left join
gfunk.dyna_batter_season e on (e.year=2019 and a.PLAYERID = e.batter)
where c.team_abbrev = 'SEA'
group by c.player_id
order by b.searchCount desc
limit 3
The Mariners add free-agent import Dae-Ho Lee to their 40-man roster, and let Jesus Montero get away.
On the decisions that lead to Logan Morrison being the fastest man on a bench.
A novel, in one accurate throw from Jered Weaver to Kyle Seager.
On the absence of what often makes baseball so fun.
Ken Griffey Jr. will get inducted. Edgar Martinez will not.
Is diversity in baseball a threat to the new membership club?
Why 2016 looks to be such a momentous one for Joshua and two of his clients.
The Mariners’ new reliever was historically resistant to ball four.
Hisashi Iwakuma takes a strange road back to Seattle.
The Rockies try to find two relievers who can survive Coors Field, while in Seattle Dipoto adds to his bullpen, too.
Sometimes, bad news means a good opportunity.
Jerry Dipoto’s catcher follows him north, while the Angels replace Iannetta with Soto.
Assessing the first draft of baseball history.
The new regime in Seattle makes its first big move, cutting ties with three key parts of the 2015 roster.