SELECT * FROM Pitches WHERE inning=8 and gameid='CHA201004080' and batter='piera001' and pitcher='perer002' ORDER BY pitchNumber
A.J. Pierzynski (L) vs Rafael Perez (L)
B Ball
C Called Strike
S Swinging Strike
F Foul Ball
X in Play
Teams: CLE vs CHA
Game: 2010-04-08
Boxscore
Inning: 8
Result: Groundout