SELECT * FROM pitches LEFT JOIN (atbats LEFT JOIN players ON atbats.pitcher = players.eliasid) 
ON pitches.ab_id = atbats.ab_id WHERE players.last = 'Guthrie' AND players.first = 'Jeremy