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 = 'CHC'
group by c.player_id
order by b.searchCount desc
limit 3
The Cubs are kicking tires, but might not have room for the last marquee free agent; meanwhile, Matt Albers is chasing a record again.
A fanfest puts Joe Maddon to his first big test: Fans.
Dexter Fowler gives Chicago OBP at the top of the lineup and gives Maddon the flexibility to mix and match in myriad ways.
Why David Ross and, more interestingly, why not Welington Castillo?
It can be difficult for two teams to balance the value of a pitcher with his impending free agency.
The Royals add another aging bat, the Marlins hope a move to first keeps Morse healthy, the Rockies add bench depth, the Yankees keep some rotation depth, the Cubs and Orioles build pen depth, and a low-risk, but possibly not-so-high-reward arm, lands in San Diego.
The league might be catching up to the inefficiency in non-player compensation.
After finishing second in a number of high-end free agent pursuits, the front office lands Jon Lester. That should help them snap another string of disappointing finishes.
A couple of the mid-afternoon moves from Tuesday’s winter meetings.
While the world watches Lester, the Cubs fill in the middle of their rotation.
Two years after an anomalous bottoming out came the anomalous career year for baseball’s next $100 million free agent.
The Blue Jays, not the Cubs, sign Russell Martin; The Cubs, not the Braves, now employ Tommy La Stella.
The return of the offseason Rumor Roundup: News on Russell Martin, Torri Hunter, and Hisashi Iwakuma.
Arguably the best system in all of baseball, with multiple elite talents heading the list and plenty of high-ceiling depth scattered throughout.
The Cubs have work to do, to be sure, but Joe Maddon’s arrival is the clearest sign yet that the next era is here.