select b.*, p.playerid, p.cname, s.*, t.*
from mlb_pitchingbox as b, mlb_players as p, mlb_schedule as s, mlb_twplayers as t
where p.playerid = b.playerid
and t.player_id = p.playerid
and s.gameday = b.gameid
and (t.team_id = s.home_team_id or t.team_id = s.away_team_id)
and substring(b.gameid,1,4) = '2009'
and t.year = 2009
and
order by s.gamedate