SELECT * FROM Pitches WHERE inning=8 and gameid='CHA201205230' and batter='piera001' and pitcher='lirif001' ORDER BY pitchNumber
A.J. Pierzynski (L) vs Francisco Liriano (L)
B Ball
C Called Strike
S Swinging Strike
F Foul Ball
X in Play
Teams: MIN vs CHA
Game: 2012-05-23
Boxscore
Inning: 8
Result: Walk
Pitch #1
94
2-Seam Fastball
Pitch #3
95
2-Seam Fastball