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 = 'ATL'
group by c.player_id
order by b.searchCount desc
limit 3
It’s taken the right adjustments and perhaps some veteran influence to make it happen.