public static function player($playerID)
{
$pitchers = Pitching::leftJoin('master', 'pitching.playerID', '=', 'master.playerID')->leftJoin('teams', function ($join) {
$join->on('pitching.teamID', '=', 'teams.teamID');
$join->on('pitching.yearID', '=', 'teams.yearID');
})->select('master.nameLast', 'master.nameFirst', 'teams.name', 'teams.yearID', 'teams.teamID', 'pitching.ERA', 'pitching.G', 'pitching.W', 'pitching.L', 'pitching.SV', 'pitching.SO', 'pitching.BB')->where('pitching.playerID', '=', $playerID);
$grids = PitchingController::grids($pitchers, 'player');
$count = $pitchers->count();
$grids['count'] = $count;
return $grids;
}
