SELECT * FROM Pitches WHERE inning=8 and gameid='MIN201206270' and batter='piera001' and pitcher='robet001' ORDER BY pitchNumber
A.J. Pierzynski (L) vs Tyler Robertson (L)
B Ball
C Called Strike
S Swinging Strike
F Foul Ball
X in Play
Teams: CHA vs MIN
Game: 2012-06-27
Boxscore
Inning: 8
Result: Sac Fly