Query generated using the B-R Play Index : /pi/pgl_finder.cgi. Try the Play Index for free and make your own queries.
User's Notes:
After reading the MySQL performance blog, I realized I was making things a bit too hard when people asked for the total number of matching outputs. At the bottom of the output you now get the total number of games that matched your criteria.
Cnt Player Date Tm Opp GmReslt App,Dec IP H R ER BB SO HR Pit Str GmSc IR IS BF AB 2B 3B IBB HBP SH SF GDP SB CS Pk BK WP ERA ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ 1 Justin Verlander 2007-09-01 DET @OAK W 6-1 GS-7 ,W 6.2 6 1 1 3 10 1 129 85 65 29 26 1 0 0 0 0 0 0 0 0 0 0 0 1.35 2 Oliver Perez 2007-08-29 NYM @PHI L 2-3 GS-6 ,L 6 5 3 3 5 10 2 110 65 55 27 20 0 0 0 0 1 1 0 0 1 1 0 0 4.50 3 Jake Peavy 2007-08-27 SDP ARI W 3-1 GS-7 ,W 7 3 1 1 3 11 1 114 74 75 26 23 1 0 0 0 0 0 1 0 0 0 0 0 1.29 4 Danny Haren 2007-08-26 OAK @TBD L 4-7 GS-6 ,L 6 4 5 3 0 10 2 104 67 58 23 23 0 1 0 0 0 0 0 0 0 0 0 0 4.50 5 Javier Vazquez 2007-08-26 CHW BOS L 1-11 GS-6 ,L 6 6 7 7 3 10 3 109 70 39 27 24 0 0 0 0 0 0 0 1 0 0 0 0 10.50 6 Scott Kazmir 2007-08-25 TBD OAK W 14-3 GS-8 ,W 8 5 3 3 0 13 1 105 75 73 30 28 3 0 0 1 0 1 0 0 0 0 0 0 3.38 7 Chad Gaudin 2007-08-23 OAK @TBD W 12-2 GS-7 ,W 7 5 1 1 2 10 0 93 64 71 26 24 1 0 0 0 0 0 2 0 0 0 0 0 1.29 8 Rich Hill 2007-08-22 CHC @SFG W 4-2 GS-7 7 6 2 2 1 10 0 117 84 66 28 27 2 0 1 0 0 0 0 0 0 0 0 0 2.57 9 Jake Peavy 2007-08-22 SDP @NYM W 7-5 GS-6 ,W 6 2 2 2 5 11 0 101 68 66 26 21 1 0 0 0 0 0 0 5 0 0 0 1 3.00 10 Erik Bedard 2007-08-21 BAL TEX W 6-2 GS-7 ,W 7 5 2 2 0 11 0 104 74 70 26 26 2 0 0 0 0 0 0 0 0 0 0 0 2.57 11 Ian Snell 2007-08-19 PIT PHI W 8-4 GS-7 ,W 7 8 4 4 3 10 2 120 73 52 33 29 2 0 2 1 0 0 0 2 0 0 0 0 5.14 12 Johan Santana 2007-08-19 MIN TEX W 1-0 GS-8 ,W 8 2 0 0 0 17 0 112 83 95 26 26 1 0 0 0 0 0 0 0 0 0 0 0 0.00 13 John Smoltz 2007-08-19 ATL ARI W 6-2 GS-8 ,W 8 5 2 2 3 12 0 118 80 73 33 27 3 0 0 2 1 0 1 2 0 0 0 0 2.25 14 Jake Peavy 2007-08-17 SDP HOU L 1-3 GS-7 7 4 1 1 2 11 1 113 81 74 27 25 0 0 0 0 0 0 0 0 0 0 0 0 1.29 15 Fausto Carmona 2007-08-15 CLE DET W 5-2 GS-8 ,W 8 4 2 1 2 10 0 104 69 76 31 29 0 1 0 0 0 0 0 0 0 0 0 0 1.12 16 Dontrelle Willis 2007-08-14 FLA ARI W 14-5 GS-7 ,W 7 10 3 3 0 11 2 121 81 56 32 32 1 0 0 0 0 0 0 0 0 0 0 0 3.86 17 Brandon Webb 2007-08-11 ARI WSN W 1-0 SHO9 ,W 9 5 0 0 1 10 0 119 83 86 33 31 1 0 0 0 1 0 1 1 0 0 0 0 0.00 18 Erik Bedard 2007-08-05 BAL @TBD W 11-3 GS-7 ,W 6.2 9 3 3 0 11 2 115 75 55 29 29 0 0 0 0 0 0 0 0 0 0 0 1 4.05 19 Daisuke Matsuzaka 2007-08-04 BOS @SEA W 4-3 GS-7 ,W 7 6 2 2 2 10 2 113 76 65 30 26 1 0 0 2 0 0 1 0 0 0 0 0 2.57 20 Matt Cain 2007-08-03 SFG @SDP L 3-4 GS-8 7.1 5 2 2 1 11 0 112 80 70 28 26 1 0 0 0 1 0 0 1 0 0 0 0 2.45 21 Jake Peavy 2007-08-02 SDP ARI W 11-0 GS-7 ,W 7 3 0 0 1 10 0 103 72 80 26 24 2 0 0 1 0 0 0 0 0 0 0 0 0.00 22 Oliver Perez 2007-08-01 NYM @MIL W 8-5 GS-6 ,W 6 5 5 4 3 11 1 115 74 52 27 23 1 0 0 0 1 0 0 0 0 0 0 0 6.00 23 Byung-Hyun Kim 2007-08-01 FLA COL W 4-3 GS-6 ,W 5.1 5 2 2 6 10 0 126 74 54 28 21 2 0 0 1 0 0 0 4 0 0 0 1 3.38 24 Matt Garza 2007-07-29 MIN @CLE W 4-1 GS-6 6 5 1 1 3 11 0 109 68 66 26 22 2 0 0 1 0 0 1 0 0 0 0 1 1.50 25 C.C. Sabathia 2007-07-29 CLE MIN L 1-4 GS-8 ,L 7.2 6 3 1 0 11 0 119 82 70 31 30 4 0 0 1 0 0 0 1 0 0 0 0 1.17 ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ Cnt Player Date Tm Opp GmReslt App,Dec IP H R ER BB SO HR Pit Str GmSc IR IS BF AB 2B 3B IBB HBP SH SF GDP SB CS Pk BK WP ERA ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ 26 Johan Santana 2007-07-28 MIN @CLE W 3-2 GS-7 7 4 2 2 1 12 1 114 77 72 26 25 1 0 0 0 0 0 1 0 0 0 0 0 2.57 27 Roy Oswalt 2007-07-28 HOU SDP W 3-1 GS-7 ,W 7 3 1 0 1 10 0 106 67 78 27 25 0 0 0 1 0 0 0 0 0 0 0 0 0.00 28 Aaron Harang 2007-07-23 CIN MIL W 2-1 GS-10 10 7 1 1 0 10 1 121 88 84 37 37 1 0 0 0 0 0 0 0 0 0 0 0 0.90 29 Erik Bedard 2007-07-20 BAL @OAK W 6-1 GS-7 ,W 7 1 1 1 3 11 1 105 67 79 25 22 0 0 0 0 0 0 0 0 0 0 0 0 1.29 30 Josh Beckett 2007-07-20 BOS CHW W 10-3 GS-6 ,W 6 4 3 3 2 10 1 114 74 60 23 21 0 0 0 0 0 0 0 1 0 0 0 0 4.50 31 John Smoltz 2007-07-18 ATL CIN L 4-5 GS-7 7 5 0 0 2 11 0 93 65 76 27 25 2 0 0 0 0 0 0 0 0 0 0 0 0.00 32 Brandon Webb 2007-07-15 ARI SDP L 0-4 GS-6 ,L 5.2 11 4 3 2 10 0 116 71 41 29 27 1 1 1 0 0 0 0 3 0 0 0 0 4.76 33 John Lackey 2007-07-07 LAA @NYY W 2-1 GS-8 8 5 1 1 0 11 0 107 77 79 29 28 3 0 0 1 0 0 0 1 0 1 0 0 1.12 34 Erik Bedard 2007-07-07 BAL @TEX W 3-0 SHO9 ,W 9 2 0 0 0 15 0 109 79 98 27 27 0 0 0 0 0 0 2 0 0 0 0 0 0.00 35 Ervin Santana 2007-07-03 LAA @TEX L 3-8 GS-6 ,L 5.1 7 5 4 2 11 2 111 71 45 27 23 1 0 0 0 2 0 0 0 0 0 0 1 6.75 36 James Shields 2007-07-01 TBD @CLE L 2-3 GS-7 ,L 6.1 6 3 2 0 10 1 114 77 61 26 25 1 0 0 1 0 0 0 0 1 0 0 0 2.84 37 Tim Lincecum 2007-07-01 SFG ARI W 13-0 GS-7 ,W 7 3 0 0 0 12 0 97 66 83 24 24 1 0 0 0 0 0 0 0 0 0 0 0 0.00 38 Ben Sheets 2007-06-30 MIL @CHC W 13-4 GS-8 ,W 8 6 4 4 1 11 0 124 89 64 31 29 1 2 0 0 0 1 0 0 0 0 0 0 4.50 39 Javier Vazquez 2007-06-28 CHW @TBD W 5-1 GS-7 ,W 7 7 1 1 3 10 0 107 71 66 30 27 1 0 0 0 0 0 1 0 0 0 0 0 1.29 40 Scott Olsen 2007-06-28 FLA PIT W 9-7 GS-6 ,W 6 7 5 5 2 10 1 108 71 46 27 25 2 0 0 0 0 0 0 0 0 0 0 0 7.50 41 James Shields 2007-06-26 TBD CHW L 1-6 GS-7 ,L 7 9 5 5 0 11 2 110 75 50 30 30 0 1 0 0 0 0 0 0 0 0 0 0 6.43 42 Chris Young 2007-06-23 SDP BOS W 6-1 GS-7 ,W 7 1 0 0 2 11 0 110 74 84 25 23 0 0 0 0 0 0 0 1 0 0 0 0 0.00 43 Justin Verlander 2007-06-23 DET @ATL W 2-1 GS-7 ,W 7 4 1 1 2 11 1 110 71 74 27 25 0 0 0 0 0 0 0 1 0 0 1 0 1.29 44 Carlos Zambrano 2007-06-22 CHC @CHW W 5-1 GS-8 ,W 8 3 1 1 1 12 1 113 74 83 27 26 0 0 0 0 0 0 1 0 0 0 0 0 1.12 45 Ted Lilly 2007-06-21 CHC @TEX L 5-6 GS-7 7 6 5 5 1 10 2 104 75 54 27 26 1 0 0 0 0 0 1 0 0 0 0 0 6.43 46 Chien-Ming Wang 2007-06-17 NYY NYM W 8-2 GS-9 ,W 8.2 6 2 2 1 10 0 113 72 73 31 29 3 0 0 1 0 0 3 0 1 0 0 1 2.08 47 Kevin Millwood 2007-06-17 TEX @CIN W 11-4 GS-6 ,W 6 6 4 4 2 10 2 99 59 52 27 24 0 0 0 1 0 0 0 1 0 0 0 1 6.00 48 Shaun Marcum 2007-06-16 TOR WSN W 7-3 GS-7 ,W 7 3 2 2 3 11 2 101 69 71 26 23 1 0 0 0 0 0 1 0 0 0 0 0 2.57 49 Derek Lowe 2007-06-15 LAD LAA W 2-1 GS-7 ,W 7 4 1 1 1 11 0 96 65 75 25 24 1 0 0 0 0 0 0 1 1 0 0 0 1.29 50 Kelvim Escobar 2007-06-12 LAA @CIN L 3-5 GS-6 6 5 3 3 1 14 0 116 78 63 26 24 2 0 0 0 1 0 0 1 0 0 0 0 4.50 ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ Cnt Player Date Tm Opp GmReslt App,Dec IP H R ER BB SO HR Pit Str GmSc IR IS BF AB 2B 3B IBB HBP SH SF GDP SB CS Pk BK WP ERA ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ 51 Roy Oswalt 2007-06-12 HOU OAK W 5-4 GS-6 6 6 3 3 3 10 0 111 68 55 27 24 2 0 0 0 0 0 0 0 0 0 0 0 4.50 52 Scott Kazmir 2007-06-12 TBD SDP W 11-4 GS-6 6 9 4 4 2 11 0 117 80 47 27 25 2 0 0 0 0 0 1 0 1 1 0 1 6.00 53 Justin Verlander 2007-06-12 DET MIL W 4-0 SHO9 ,W 9 0 0 0 4 12 0 112 73 95 30 26 0 0 0 0 0 0 1 0 0 0 0 0 0.00 54 Aaron Harang 2007-06-10 CIN CLE W 1-0 GS-7 7 3 0 0 2 10 0 116 74 79 25 23 1 0 0 0 0 0 1 0 0 0 0 1 0.00 55 Andy Sonnanstine 2007-06-10 TBD @FLA W 9-4 GS-7 ,W 7 7 2 2 0 10 2 99 71 65 27 27 1 0 0 0 0 0 0 0 1 0 0 0 2.57 56 Jon Lieber 2007-06-09 PHI @KCR W 4-0 SHO9 ,W 9 3 0 0 0 11 0 106 78 92 30 30 1 0 0 0 0 0 0 1 0 0 0 0 0.00 57 Rich Hill 2007-06-07 CHC @ATL W 2-1 GS-8 ,W 8 3 1 1 1 11 1 108 75 82 28 27 0 0 0 0 0 0 0 1 0 0 0 0 1.12 58 A.J. Burnett 2007-06-07 TOR TBD L 3-5 GS-7 7 7 3 3 3 13 1 130 84 61 32 29 2 0 0 0 0 0 0 3 0 0 0 1 3.86 59 Chris Capuano 2007-06-02 MIL FLA L 2-5 GS-7 7 3 2 2 3 10 1 119 71 70 27 24 1 0 0 0 0 0 0 0 0 0 0 0 2.57 60 A.J. Burnett 2007-06-01 TOR CHW L 0-3 GS-8 ,L 7.1 6 3 3 1 12 0 117 80 65 29 28 2 0 0 0 0 0 0 2 0 0 0 0 3.68 61 Shawn Chacon 2007-05-31 PIT SDP L 2-4 GS-7 7 3 0 0 1 10 0 102 67 80 24 23 1 0 0 0 0 0 1 0 0 0 0 0 0.00 62 Curt Schilling 2007-05-28 BOS CLE W 5-3 GS-7 ,W 7 6 1 1 0 10 0 114 77 71 27 26 1 0 0 1 0 0 1 1 0 0 0 0 1.29 63 Chris Young 2007-05-24 SDP CHC L 1-3 GS-7 7 3 1 1 2 10 0 93 62 75 25 23 2 1 0 0 0 0 1 0 0 0 0 1 1.29 64 Johan Santana 2007-05-22 MIN @TEX W 7-1 GS-7 ,W 7 4 1 1 2 13 1 103 67 76 26 24 1 1 0 0 0 0 1 0 0 0 0 0 1.29 65 Erik Bedard 2007-05-20 BAL @WSN L 3-4 GS-7 7 3 1 1 3 12 0 98 66 76 28 24 1 0 0 1 0 0 0 2 0 0 0 0 1.29 66 Randy Johnson 2007-05-20 ARI @PIT W 5-2 GS-6 ,W 5.2 7 2 2 0 10 0 100 74 57 24 24 2 0 0 0 0 0 0 1 0 0 0 0 3.18 67 Jeremy Guthrie 2007-05-19 BAL @WSN W 3-2 GS-7 7 4 1 1 0 10 0 112 74 75 25 25 1 0 0 0 0 0 0 0 0 0 0 0 1.29 68 Boof Bonser 2007-05-18 MIN @MIL W 8-1 GS-7 ,W 7 3 1 1 1 11 0 92 62 77 24 23 0 0 0 0 0 0 1 0 0 0 0 0 1.29 69 Tim Lincecum 2007-05-17 SFG @HOU W 2-1 GS-7 7 2 1 0 1 10 0 95 60 80 24 22 0 0 0 0 0 1 0 1 0 0 0 0 0.00 70 Johan Santana 2007-05-17 MIN @CLE L 0-2 GS-7 ,L 7 4 2 2 1 11 2 103 67 71 26 25 0 0 0 0 0 0 0 0 0 0 1 1 2.57 71 A.J. Burnett 2007-05-16 TOR BAL W 2-1 CG 9 ,W 9 3 1 1 2 10 1 103 66 85 31 29 0 0 0 0 0 0 1 0 0 0 0 0 1.00 72 Cole Hamels 2007-05-16 PHI MIL W 6-2 GS-8 ,W 8 2 2 2 1 11 1 114 79 80 27 26 1 0 0 0 0 0 0 0 0 0 0 0 2.25 73 Jay Bergmann 2007-05-14 WSN ATL W 2-1 GS-8 ,W 8 2 1 1 1 10 1 110 81 83 27 26 0 0 0 0 0 0 0 1 0 0 0 0 1.12 74 A.J. Burnett 2007-05-11 TOR TBD W 5-1 GS-7 ,W 6.2 5 1 1 5 10 1 118 63 65 30 24 0 0 0 1 0 0 1 4 0 0 0 0 1.35 75 Brandon Webb 2007-05-11 ARI @HOU W 3-1 CG 9 ,W 9 6 1 1 1 10 0 118 83 80 34 32 3 0 0 1 0 0 1 1 0 0 0 0 1.00 ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ Cnt Player Date Tm Opp GmReslt App,Dec IP H R ER BB SO HR Pit Str GmSc IR IS BF AB 2B 3B IBB HBP SH SF GDP SB CS Pk BK WP ERA ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ 76 Jake Peavy 2007-05-11 SDP STL W 7-0 GS-7 ,W 7 3 0 0 2 10 0 106 68 79 27 25 1 0 0 0 0 0 0 2 0 0 0 0 0.00 77 Randy Wolf 2007-05-11 LAD CIN W 2-0 GS-7 ,W 7 4 0 0 0 11 0 115 74 80 25 25 1 0 0 0 0 0 0 0 0 0 0 0 0.00 78 Erik Bedard 2007-05-09 BAL TBD W 1-0 GS-7 7 3 0 0 3 10 0 97 62 78 27 24 1 0 0 0 0 0 0 0 0 0 0 0 0.00 79 Brad Penny 2007-05-07 LAD @FLA W 6-1 GS-7 ,W 7 5 0 0 0 14 0 110 76 81 26 26 1 0 0 0 0 0 0 0 0 0 0 0 0.00 80 Jake Peavy 2007-05-06 SDP @FLA W 3-1 GS-7 ,W 7 1 1 0 2 10 0 106 66 81 26 23 0 1 0 1 0 0 0 0 0 0 0 0 0.00 81 Oliver Perez 2007-05-02 NYM FLA W 6-3 GS-6 ,W 5.2 3 3 1 3 10 0 98 58 62 25 22 1 0 0 0 0 0 0 0 0 0 0 0 1.59 82 Jake Peavy 2007-04-30 SDP WSN L 2-3 GS-7 ,L 7 6 3 3 2 10 0 116 74 61 29 26 2 0 0 1 0 0 1 1 0 0 0 1 3.86 83 Erik Bedard 2007-04-28 BAL @CLE W 7-4 GS-6 6 5 4 4 2 11 1 108 67 55 26 23 2 0 0 1 0 0 0 0 0 0 0 0 6.00 84 Bartolo Colon 2007-04-26 LAA TBD W 11-3 GS-7 ,W 7 4 2 2 1 11 1 102 68 71 26 25 2 0 0 0 0 0 0 0 0 0 0 0 2.57 85 Tim Hudson 2007-04-25 ATL @FLA L 3-4 GS-9 8 9 3 3 0 12 0 112 81 64 33 33 2 0 0 0 0 0 0 0 0 0 0 0 3.38 86 Jake Peavy 2007-04-25 SDP @ARI L 2-3 GS-7 7 2 0 0 3 16 0 116 74 86 25 22 0 0 0 0 0 0 0 0 0 0 0 0 0.00 87 Scott Olsen 2007-04-25 FLA ATL W 4-3 GS-8 8 8 3 3 1 10 3 117 74 63 33 32 1 0 0 0 0 0 0 0 0 0 0 1 3.38 88 Roy Halladay 2007-04-24 TOR @BOS W 10-3 GS-8 ,W 8 5 3 3 0 10 1 113 78 70 29 29 0 0 0 0 0 0 0 2 0 0 0 0 3.38 89 James Shields 2007-04-22 TBD CLE L 4-6 GS-8 8 2 2 2 1 12 1 102 65 81 27 26 1 0 0 0 0 0 0 0 0 0 0 0 2.25 90 Cole Hamels 2007-04-21 PHI @CIN W 4-1 CG 9 ,W 9 5 1 1 2 15 1 115 82 86 32 29 1 0 0 0 1 0 1 0 0 0 0 0 1.00 91 Randy Wolf 2007-04-20 LAD PIT W 10-2 GS-6 ,W 6 6 1 1 1 10 0 103 65 65 25 24 0 0 0 0 0 0 0 0 0 0 0 1 1.50 92 Orlando Hernandez 2007-04-19 NYM @FLA W 11-3 GS-7 ,W 7 3 2 1 2 10 0 103 63 73 26 23 1 0 0 0 1 0 0 2 0 0 0 0 1.29 93 Brandon Webb 2007-04-18 ARI @SDP W 5-2 GS-8 8 7 2 1 2 13 0 107 75 73 34 31 0 0 0 0 1 0 0 1 0 0 0 0 1.12 94 Claudio Vargas 2007-04-18 MIL PIT W 7-3 GS-6 ,W 6 5 2 1 2 11 1 106 65 65 25 23 2 0 0 0 0 0 0 0 0 0 0 0 1.50 95 Daisuke Matsuzaka 2007-04-17 BOS @TOR L 1-2 GS-6 ,L 6 3 2 2 3 10 0 105 68 65 24 21 0 0 0 0 0 0 0 0 0 0 0 0 3.00 96 Kyle Lohse 2007-04-15 CIN @CHC W 1-0 GS-8 ,W 8 4 0 0 1 12 0 114 79 85 29 28 1 0 0 0 0 0 0 0 0 0 0 0 0.00 97 C.C. Sabathia 2007-04-15 CLE CHW W 2-1 GS-8 ,W 8 5 1 1 3 10 0 113 73 75 32 28 0 0 0 0 1 0 0 0 0 0 0 0 1.12 98 Ted Lilly 2007-04-15 CHC CIN L 0-1 GS-6 ,L 6 2 1 1 1 10 0 101 63 73 21 20 0 0 0 0 0 0 0 2 0 0 0 0 1.50 99 Johan Santana 2007-04-13 MIN TBD L 2-4 GS-7 ,L 7 6 4 4 1 10 1 98 70 58 27 26 1 0 0 0 0 0 0 0 1 1 0 1 5.14 100 Scott Kazmir 2007-04-08 TBD TOR L 3-6 GS-7 ,L 7 6 4 4 2 10 2 111 80 57 29 27 2 0 0 0 0 0 0 0 0 0 0 1 5.14 ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ Cnt Player Date Tm Opp GmReslt App,Dec IP H R ER BB SO HR Pit Str GmSc IR IS BF AB 2B 3B IBB HBP SH SF GDP SB CS Pk BK WP ERA ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ 101 Daisuke Matsuzaka 2007-04-05 BOS @KCR W 4-1 GS-7 ,W 7 6 1 1 1 10 1 108 74 70 26 25 1 0 0 0 0 0 1 0 1 0 0 0 1.29 102 Ian Snell 2007-04-03 PIT @HOU W 3-2 GS-6 6 4 2 2 1 11 1 86 59 66 23 22 1 0 1 0 0 0 0 0 0 0 0 0 3.00 103 Felix Hernandez 2007-04-02 SEA OAK W 4-0 GS-8 ,W 8 3 0 0 2 12 0 110 76 86 29 26 1 0 0 0 1 0 1 0 0 0 0 0 0.00 104 John Lackey 2006-09-28 LAA OAK W 2-0 GS-8 ,W 8 4 0 0 0 11 0 108 71 85 28 28 0 0 0 0 0 0 0 1 0 0 0 1 0.00 105 C.C. Sabathia 2006-09-26 CLE CHW W 6-0 GS-8 ,W 8 4 0 0 0 11 0 121 91 85 28 28 1 0 0 0 0 0 0 0 0 0 0 0 0.00 106 Javier Vazquez 2006-09-26 CHW @CLE L 0-6 GS-7 ,L 7 6 6 6 2 12 1 111 72 51 29 26 2 0 0 0 0 1 0 0 0 0 0 1 7.71 107 Shaun Marcum 2006-09-25 TOR BOS W 5-0 GS-8 ,W 8 2 0 0 1 10 0 113 74 87 27 26 0 0 0 0 0 0 0 0 0 0 0 0 0.00 108 Jake Peavy 2006-09-23 SDP PIT W 2-1 GS-8 ,W 8 6 1 1 1 11 0 112 84 76 30 29 0 0 0 0 0 0 1 1 0 0 0 0 1.12 109 Rich Hill 2006-09-22 CHC @CIN L 2-4 CG 5 ,L 5 4 4 4 2 10 3 99 64 51 21 19 0 0 0 0 0 0 0 0 0 0 0 0 7.20 110 Cole Hamels 2006-09-22 PHI FLA W 5-2 GS-7 ,W 6.2 6 1 1 3 10 0 115 76 65 29 26 4 0 1 0 0 0 0 1 0 0 0 0 1.35 111 Javier Vazquez 2006-09-21 CHW SEA L 0-9 GS-8 ,L 7.1 7 5 3 1 12 1 125 82 59 30 29 0 0 0 0 0 0 1 0 0 0 0 0 3.68 112 Brett Myers 2006-09-20 PHI CHC W 6-2 CG 9 ,W 9 6 2 2 3 12 0 119 80 76 35 32 1 1 0 0 0 0 1 0 0 0 0 1 2.00 113 Kirk Saarloos 2006-09-19 OAK CLE W 7-3 GS-5 5 8 2 2 4 11 0 113 69 50 27 23 1 0 1 0 0 0 0 0 0 0 0 0 3.60 114 Erik Bedard 2006-09-18 BAL @TBD W 4-1 GS-7 ,W 7 4 1 0 1 10 0 105 75 76 27 26 0 1 0 0 0 0 0 1 0 0 0 0 0.00 115 Rich Hill 2006-09-16 CHC CIN W 4-0 SHO9 ,W 9 2 0 0 1 10 0 118 85 92 31 29 1 0 0 1 0 0 0 2 0 0 0 0 0.00 116 Cole Hamels 2006-09-16 PHI @HOU W 7-2 GS-8 ,W 7.2 3 2 2 4 11 0 116 71 72 30 25 1 0 0 1 0 0 1 1 0 0 0 0 2.35 117 Brandon Webb 2006-09-15 ARI COL W 5-1 CG 9 ,W 9 6 1 1 0 10 0 104 79 81 33 33 1 0 0 0 0 0 0 0 0 0 0 0 1.00 118 A.J. Burnett 2006-09-13 TOR @SEA W 10-0 GS-8 ,W 8 6 0 0 2 11 0 103 68 79 32 29 2 0 0 1 0 0 0 1 0 1 0 0 0.00 119 Ian Snell 2006-09-13(1) PIT MIL W 6-3 GS-7 ,W 7 6 2 2 1 10 0 109 69 66 27 26 2 0 0 0 0 0 0 0 0 0 0 0 2.57 120 Ben Sheets 2006-09-13(2) MIL @PIT W 2-1 GS-8 ,W 8 2 1 1 0 10 1 100 73 84 25 25 0 0 0 0 0 0 0 0 0 1 0 0 1.12 121 Oliver Perez 2006-09-12 NYM @FLA W 6-4 GS-5 5 5 4 4 2 11 1 101 66 50 22 20 1 0 0 0 0 0 0 0 0 0 0 0 7.20 122 Lance Cormier 2006-09-10 ATL CHC W 2-1 GS-7 ,W 7 8 1 1 0 10 1 98 69 67 28 28 2 1 0 0 0 0 0 0 0 0 0 0 1.29 123 Johan Santana 2006-09-10 MIN DET W 12-1 GS-7 ,W 6.1 2 0 0 2 11 0 109 69 78 23 21 1 0 0 0 0 0 0 0 0 0 0 1 0.00 124 Dontrelle Willis 2006-09-10 FLA PHI W 3-0 SHO9 ,W 9 3 0 0 1 12 0 122 80 92 30 28 0 0 0 1 0 0 2 0 0 0 0 0 0.00 125 David Bush 2006-09-10 MIL HOU W 4-0 SHO9 ,W 9 5 0 0 0 10 0 116 85 87 31 30 3 0 0 0 1 0 1 0 0 0 0 0 0.00 ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ Cnt Player Date Tm Opp GmReslt App,Dec IP H R ER BB SO HR Pit Str GmSc IR IS BF AB 2B 3B IBB HBP SH SF GDP SB CS Pk BK WP ERA ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ 126 Javier Vazquez 2006-09-10 CHW CLE L 2-5 GS-7 7 4 2 2 2 10 0 127 81 69 26 24 0 1 0 0 0 0 1 0 0 0 0 0 2.57 127 Jason Schmidt 2006-09-09 SFG SDP W 5-4 GS-7 7 8 4 4 1 10 2 98 66 54 30 28 0 0 0 0 1 0 0 0 0 0 0 0 5.14 128 Odalis Perez 2006-09-08 KCR @BOS W 10-9 GS-6 6 5 3 2 2 10 0 107 71 60 27 25 2 1 0 0 0 0 0 0 0 0 0 1 3.00 129 Rich Hill 2006-09-06 CHC PIT W 7-2 GS-8 7.1 4 2 1 2 11 0 111 72 73 28 25 1 0 0 0 1 0 1 3 0 0 0 1 1.23 130 Johan Santana 2006-09-05 MIN @TBD W 8-0 GS-8 ,W 8 2 0 0 1 12 0 95 70 89 27 26 1 0 0 0 0 0 0 0 0 0 0 1 0.00 131 Javier Vazquez 2006-09-05 CHW @BOS L 0-1 CG 8 ,L 8 3 1 1 3 11 0 112 74 80 30 27 2 0 0 0 0 0 0 0 0 0 0 0 1.12 132 Luke Hudson 2006-09-04 KCR NYY L 5-12 GS-7 7 9 1 1 1 10 0 113 73 64 31 29 2 0 0 1 0 0 0 0 0 0 0 0 1.29 133 Kevin Millwood 2006-09-03 TEX CLE W 5-2 GS-8 ,W 8 2 1 1 1 10 1 115 73 83 27 26 1 0 0 0 0 0 0 0 0 0 0 0 1.12 134 Brett Myers 2006-09-03(2) PHI ATL L 1-3 GS-8 8 3 1 1 2 10 0 108 68 80 29 25 0 0 0 1 1 0 0 0 1 0 0 0 1.12 135 Jake Peavy 2006-09-02 SDP CIN W 7-1 CG 9 ,W 9 2 1 1 2 14 1 114 77 91 29 27 0 0 0 0 0 0 2 1 0 0 0 0 1.00 136 Johan Santana 2006-08-31 MIN KCR W 3-1 GS-7 ,W 7 5 1 1 1 11 1 109 80 73 27 26 2 1 0 0 0 0 0 0 0 0 0 0 1.29 137 Chris Young 2006-08-29 SDP @ARI W 8-3 GS-7 ,W 7 3 2 1 0 11 1 110 75 76 25 24 0 0 0 1 0 0 0 0 0 0 0 0 1.29 138 Danny Haren 2006-08-27 OAK @TEX L 0-3 GS-7 ,L 7 7 3 3 2 12 1 102 69 61 29 27 1 0 0 0 0 0 1 0 0 0 0 0 3.86 139 Andy Pettitte 2006-08-21 HOU @CIN L 3-4 GS-6 5.1 6 0 0 4 10 0 118 71 62 25 21 1 0 0 0 0 0 1 0 0 0 0 0 0.00 140 John Smoltz 2006-08-21 ATL PIT W 3-0 GS-8 ,W 8 3 0 0 1 10 0 109 75 85 29 28 0 0 0 0 0 0 0 0 0 0 0 0 0.00 141 Daniel Cabrera 2006-08-19 BAL TOR W 15-0 SHO9 ,W 9 5 0 0 2 10 0 121 78 85 33 31 0 0 0 0 0 0 1 0 0 0 0 0 0.00 142 Casey Fossum 2006-08-18 TBD CLE W 6-5 GS-7 6.1 6 5 5 3 10 2 108 61 48 28 25 3 0 1 0 0 0 0 0 0 0 0 0 7.11 143 Scott Kazmir 2006-08-17 TBD TOR L 2-6 GS-5 5 2 0 0 3 10 0 89 56 70 20 17 0 1 0 0 0 0 0 0 0 0 0 0 0.00 144 C.C. Sabathia 2006-08-12(1) CLE KCR W 5-4 GS-8 8 5 1 1 1 10 0 111 80 77 30 29 1 1 0 0 0 0 0 1 0 0 0 0 1.12 145 Andy Pettitte 2006-08-11 HOU SDP W 4-2 GS-7 ,W 7 3 2 2 1 10 0 111 69 72 25 22 0 0 0 0 1 1 0 0 0 0 0 0 2.57 146 A.J. Burnett 2006-08-11 TOR @MIN W 7-1 GS-7 ,W 7 6 1 1 2 10 0 111 80 69 28 26 4 0 0 0 0 0 1 0 0 0 0 0 1.29 147 Johan Santana 2006-08-09 MIN @DET W 4-3 GS-7 ,W 7 4 3 3 2 10 1 109 69 65 27 25 0 1 0 0 0 0 0 0 0 0 0 1 3.86 148 Matt Cain 2006-08-06 SFG COL W 6-2 GS-7 ,W 7 6 2 2 1 12 1 110 76 68 27 25 1 1 0 0 1 0 0 1 1 0 0 0 2.57 149 Javier Vazquez 2006-08-05 CHW @TOR W 7-1 GS-8 ,W 8 2 1 1 2 13 1 109 76 85 27 25 0 0 0 0 0 0 1 0 0 0 0 0 1.12 150 Cole Hamels 2006-08-03 PHI @STL W 8-1 GS-7 ,W 7 2 1 1 2 12 0 109 66 79 24 21 0 0 0 0 0 1 0 0 1 0 0 0 1.29 ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ Cnt Player Date Tm Opp GmReslt App,Dec IP H R ER BB SO HR Pit Str GmSc IR IS BF AB 2B 3B IBB HBP SH SF GDP SB CS Pk BK WP ERA ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ 151 Jason Schmidt 2006-08-02 SFG WSN W 8-6 GS-6 ,W 6 4 1 1 3 10 1 116 74 67 24 21 0 0 0 0 0 0 0 1 1 0 0 1 1.50 152 Scott Olsen 2006-08-01 FLA NYM W 6-5 GS-6 6 6 4 4 4 10 1 112 65 50 27 23 2 1 0 0 0 0 0 0 0 0 0 0 6.00 153 Ian Snell 2006-08-01 PIT ATL L 2-4 GS-7 ,L 7 9 4 4 1 10 2 94 63 52 30 28 4 0 0 0 1 0 0 0 0 0 0 0 5.14 154 Casey Fossum 2006-07-31 TBD DET W 7-3 GS-7 ,W 7 6 1 0 0 10 0 103 65 73 29 27 0 0 0 2 0 0 0 1 0 0 0 0 0.00 155 Ben Sheets 2006-07-30 MIL CIN W 4-3 GS-8 ,W 8 7 2 2 1 10 1 101 68 69 30 29 2 0 1 0 0 0 2 0 0 0 0 0 2.25 156 Francisco Liriano 2006-07-28 MIN DET L 2-3 GS-8 8 3 2 2 3 12 0 104 72 77 29 26 1 0 0 0 0 0 1 0 0 0 0 1 2.25 157 Cole Hamels 2006-07-24 PHI ATL L 8-10 GS-6 ,L 5.1 6 7 7 2 12 3 106 69 38 24 22 1 0 0 0 0 0 0 0 0 0 0 0 11.81 158 Francisco Liriano 2006-07-23 MIN @CLE W 3-1 GS-5 ,W 5 4 1 1 3 10 0 95 58 62 22 19 1 0 0 0 0 0 0 1 0 0 0 0 1.80 159 Scott Kazmir 2006-07-23 TBD BAL L 2-4 GS-7 7 7 2 2 1 10 1 104 71 64 26 25 3 0 0 0 0 0 0 0 1 1 0 0 2.57 160 Scott Olsen 2006-07-21 FLA PIT W 4-1 GS-7 ,W 6.2 6 1 0 2 11 0 114 75 69 28 26 0 0 0 0 0 0 0 0 0 0 0 1 0.00 161 Carlos Zambrano 2006-07-20 CHC HOU W 4-1 GS-8 ,W 8 2 1 1 4 10 0 123 72 80 30 25 0 0 0 0 0 1 0 0 0 0 0 2 1.12 162 Randy Johnson 2006-07-19 NYY SEA L 2-3 GS-8 ,L 8 7 3 2 1 11 1 129 90 68 32 29 1 0 0 1 0 1 0 2 2 0 0 0 2.25 163 Brandon Webb 2006-07-15 ARI MIL W 8-1 GS-7 ,W 7 6 0 0 2 10 0 110 74 73 28 26 0 0 0 0 0 0 1 0 0 0 0 0 0.00 164 Andy Pettitte 2006-07-15 HOU @FLA W 12-0 GS-7 ,W 7 5 0 0 2 10 0 100 66 75 27 25 1 0 0 0 0 0 1 0 0 0 0 0 0.00 165 John Lackey 2006-07-14 LAA TBD W 4-0 SHO9 ,W 9 5 0 0 2 10 0 107 74 85 31 28 0 0 0 0 1 0 4 2 0 0 0 0 0.00 166 John Smoltz 2006-07-08 ATL CIN W 4-1 GS-8 ,W 8 6 1 1 1 10 0 120 85 75 30 28 2 0 0 0 0 1 1 0 0 0 0 0 1.12 167 Jaret Wright 2006-07-07 NYY @TBD W 1-0 GS-6 ,W 6 4 0 0 0 10 0 91 56 74 22 22 2 0 0 0 0 0 0 1 0 0 0 0 0.00 168 John Lackey 2006-07-07 LAA @OAK W 3-0 SHO9 ,W 9 1 0 0 0 10 0 109 77 95 28 28 1 0 0 0 0 0 0 0 0 0 0 0 0.00 169 Vicente Padilla 2006-07-05 TEX TOR W 9-3 GS-7 ,W 6.2 6 3 3 1 10 1 105 69 59 27 26 0 0 0 0 0 0 0 0 0 0 0 0 4.05 170 Scott Kazmir 2006-07-03 TBD BOS W 3-0 SHO9 ,W 9 2 0 0 2 10 0 120 84 91 34 31 1 0 0 1 0 0 0 0 0 0 0 0 0.00 171 Francisco Liriano 2006-07-02 MIN MIL W 8-0 GS-8 ,W 8 3 0 0 1 12 0 103 71 87 29 27 0 0 0 1 0 0 1 0 0 0 1 1 0.00 172 John Lackey 2006-07-02 LAA LAD W 4-0 GS-7 ,W 6.2 4 0 0 1 10 0 108 70 75 25 24 1 0 0 0 0 0 0 1 0 0 0 0 0.00 173 Matt Cain 2006-07-01(1) SFG @SDP L 4-7 GS-6 6 3 2 2 4 11 0 115 70 65 26 21 1 0 1 0 1 0 0 0 0 0 0 1 3.00 174 Curt Schilling 2006-06-24 BOS PHI W 5-3 GS-6 6 8 3 3 1 10 0 116 76 53 26 25 2 0 0 0 0 0 0 0 1 0 0 0 4.50 175 Erik Bedard 2006-06-21 BAL FLA W 4-0 GS-8 ,W 8 2 0 0 0 12 0 105 75 90 27 26 0 0 0 1 0 0 0 0 0 0 0 0 0.00 ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ Cnt Player Date Tm Opp GmReslt App,Dec IP H R ER BB SO HR Pit Str GmSc IR IS BF AB 2B 3B IBB HBP SH SF GDP SB CS Pk BK WP ERA ----+-----------------+-------------+---+----+-------+---------+----+--+--+--+--+--+--+---+---+----+--+--+--+--+--+--+---+---+--+--+---+--+--+--+--+--+------ 176 Jon Lester 2006-06-21 BOS WSN W 9-3 GS-6 ,W 6 3 1 1 2 10 0 107 69 70 23 21 1 0 0 0 0 0 0 1 0 0 0 0 1.50 177 Brett Myers 2006-06-19 PHI NYY W 4-2 GS-7 ,W 6.2 6 2 2 6 11 1 124 75 59 32 26 1 0 0 0 0 0 0 1 0 0 0 0 2.70 178 Matt Cain 2006-06-19 SFG LAA W 2-1 GS-8 ,W 8 1 1 0 4 10 0 131 83 84 29 25 0 0 0 0 0 0 0 3 0 0 0 1 0.00 179 Jeremy Bonderman 2006-06-19 DET @MIL W 3-1 GS-7 ,W 7 4 1 1 3 12 1 100 69 74 28 25 1 0 1 0 0 0 0 0 0 0 0 0 1.29 180 Jose Contreras 2006-06-17 CHW @CIN W 8-6 GS-6 6 7 5 5 2 13 1 113 70 49 27 25 1 0 1 0 0 0 0 2 0 0 0 2 7.50 181 Chris Capuano 2006-06-16 MIL CLE W 6-4 GS-7 ,W 7 6 2 2 0 12 0 109 74 69 27 27 2 0 0 0 0 0 0 0 0 0 0 0 2.57 182 Francisco Liriano 2006-06-16 MIN @PIT W 4-2 GS-7 ,W 7 5 2 2 1 11 1 101 71 69 27 26 1 0 0 0 0 0 0 0 0 0 0 0 2.57 183 Barry Zito 2006-06-16 OAK LAD W 7-3 GS-8 ,W 8 8 3 3 0 11 0 110 72 65 31 31 3 0 0 0 0 0 1 0 0 0 0 0 3.38 184 Elizardo Ramirez 2006-06-14 CIN MIL W 3-0 GS-8 8 5 0 0 1 10 0 113 77 81 29 27 1 0 0 1 0 0 1 0 1 0 0 0 0.00 185 Jeremy Bonderman 2006-06-14 DET TBD L 1-5 GS-8 8 6 1 1 1 12 0 113 72 77 31 30 1 0 0 0 0 0 0 0 0 0 0 0 1.12 186 Chris Carpenter 2006-06-13 STL @PIT W 2-1 GS-7 ,W 7 3 0 0 3 13 0 111 71 81 27 24 1 0 0 0 0 0 0 0 0 0 0 0 0.00 187 Johan Santana 2006-06-13 MIN BOS W 5-2 GS-8 8 5 1 1 0 13 1 102 75 81 28 28 1 0 0 0 0 0 1 0 0 0 0 0 1.12 188 Jose Contreras 2006-06-12 CHW @TEX W 8-3 GS-8 ,W 8 6 3 3 0 11 1 108 75 69 30 29 1 0 0 0 0 1 0 0 0 0 0 0 3.38 189 Jake Peavy 2006-06-11 SDP FLA L 3-7 GS-5 ,L 5 8 6 6 3 10 1 105 68 34 24 21 2 0 1 0 0 0 0 0 2 0 0 0 10.80 190 Ted Lilly 2006-06-10 TOR DET L 3-5 GS-9 ,L 8.2 3 5 4 2 12 2 116 78 70 32 30 1 0 0 0 0 0 0 0 0 0 0 0 4.15 191 Chris Young 2006-06-09 SDP FLA W 3-2 GS-6 ,W 6 5 1 1 3 12 1 106 69 67 25 22 1 1 0 0 0 0 0 2 0 0 0 0 1.50 192 Jason Schmidt 2006-06-06 SFG FLA W 2-1 CG 9 ,W 9 7 1 1 1 16 1 124 81 84 33 32 0 0 0 0 0 0 1 0 1 0 0 1 1.00 193 Ian Snell 2006-06-05 PIT @COL W 5-2 GS-7 ,W 6.1 6 2 2 1 10 0 94 66 62 26 23 1 1 0 0 1 1 0 0 0 0 0 0 2.84 194 Doug Davis 2006-06-03 MIL WSN L 3-4 GS-8 8 6 2 2 2 11 0 106 69 71 31 27 1 0 0 0 2 0 1 0 1 1 0 0 2.25 195 John Smoltz 2006-06-03(1) ATL ARI L 2-4 GS-7 ,L 7 8 4 4 0 10 2 110 78 55 29 29 4 0 0 0 0 0 0 0 0 0 0 0 5.14 196 Jason Schmidt 2006-05-31 SFG @FLA W 6-1 GS-6 ,W 5.2 5 1 1 0 10 0 105 69 65 22 21 0 1 0 0 0 1 0 0 0 0 0 0 1.59 197 Pedro Martinez 2006-05-26 NYM @FLA L 1-5 GS-7 ,L 7 5 2 2 0 10 1 91 65 69 26 26 0 0 0 0 0 0 0 0 0 0 0 0 2.57 198 Gil Meche 2006-05-25 SEA BAL L 0-2 GS-7 ,L 7 4 2 2 2 10 0 115 70 69 26 24 3 0 0 0 0 0 1 0 0 0 0 0 2.57 199 Jake Peavy 2006-05-22 SDP ATL L 1-3 GS-7 ,L 7 3 2 2 1 16 1 114 74 78 25 24 0 0 0 0 0 0 0 1 0 0 0 0 2.57 200 Scott Kazmir 2006-05-21 TBD FLA W 3-0 GS-8 ,W 8 4 0 0 1 11 0 119 76 84 29 27 1 0 0 1 0 0 0 1 0 1 0 0 0.00 Games found: 5,459.
This column contains the innings for the appearance and any decision ('W'in, 'L'oss, or 'S'ave) the player earned. Lower cases 's' and 'f' indicate they started or finished the game. A 'CG' indicates a complete game with the number giving the number of innings. 'SHO' is a shutout with the number of innings. For example, 's1-6 ,W' indicates the pitcher started the game and left during or after the sixth inning and earned the win.
Photos from the George Grantham Bain Collection at the Library of Congress.
Please report any abuse.