Winning picks from SDQL masters.
S p o r t s D a t a b a s e . c o m
agile access to sports data


name
password


MLB Sport Data Query Language Access. SDB Home     MLB Trends     MLB Query
Numerical options: SU | OU | RL | Invested

umpires [0] = Chris Guccione and H and league = 'AL' and total <= 8 and season >= 2006
RL: 27-29 (-0.48, 48.2%)   avg line: 103.1 / -117.0   on / against: -$197 / -$134   ROI: -2.9% / -1.8%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.11 2.84 7.44 8.35 1.60 1.11 2.30 1.14 3.81 13.28 6.40 0.82 2.86 4.09
Opp 4.42 2.93 7.84 8.81 1.63 1.12 2.65 1.14 3.74 14.42 6.96 0.86 3.09 3.60
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jun 28, 2006 box Wed home Twins Johan Santana - L Dodgers Odalis Perez - L 6-3 3 W 1.0 O 13-5 0-1 6-0 -260 8.0 9
Jun 19, 2007 box Tue home Blue Jays Dustin McGowan - R Dodgers Brad Penny - R 1-10 -9 L 3.0 O 6-14 0-0 0-9 115 8.0 9
Aug 24, 2007 box Fri home Orioles Jeremy Guthrie - R Twins Johan Santana - L 4-7 -3 L 3.5 O 8-14 0-0 4-3 165 7.5 9
Sep 24, 2009 box Thu home Blue Jays Ricky Romero - L Mariners Felix Hernandez - R 4-5 -1 L 1.5 O 7-13 0-1 0-3 140 7.5 9
Jun 22, 2010 box Tue home Athletics Dallas Braden - L Reds Bronson Arroyo - R 2-4 -2 L -1.5 U 7-13 1-1 0-3 -125 7.5 9
Jul 23, 2010 box Fri home Mariners Jason Vargas - L Red Sox Josh Beckett - R 1-2 -1 L -4.5 U 6-10 1-0 1-1 110 7.5 9
Aug 26, 2010 box Thu home Blue Jays Ricky Romero - L Tigers Max Scherzer - R 1-7 -6 L 0.0 P 7-9 1-0 0-7 -135 8.0 9
Sep 06, 2010 box Mon home Athletics Brett Anderson - L Mariners Jason Vargas - L 6-2 4 W 1.0 O 9-5 1-1 5-0 -180 7.0 9
Jun 08, 2011 box Wed home Orioles Zachary Britton - L Athletics Josh Outman - L 3-2 1 W -3.0 U 6-5 1-0 3-0 -140 8.0 9
Jun 12, 2011 box Sun home Tigers Rick Porcello - R Mariners Felix Hernandez - R 3-7 -4 L 3.0 O 9-9 0-2 2-4 -105 7.0 9
Sep 16, 2011 box Fri home Twins Kevin Slowey - R Indians Ubaldo Jimenez - R 6-7 -1 L 5.0 O 9-10 0-2 0-5 125 8.0 9
May 04, 2012 box Fri home Tigers Drew Smyly - L White Sox Jake Peavy - R 5-4 1 W 1.5 O 9-10 0-0 1-2 -110 7.5 9
Jun 03, 2012 box Sun home Rays Matt Moore - L Orioles Jake Arrieta - R 8-4 4 W 4.0 O 6-12 1-3 6-1 -155 8.0 9
Aug 16, 2012 box Thu home Angels Dan Haren - R Rays David Price - L 0-7 -7 L -0.5 U 5-8 0-0 0-7 105 7.5 9
Sep 17, 2012 box Mon home Mariners Hector Noesi - R Orioles Chris Tillman - R 4-10 -6 L 6.5 O 9-15 1-0 0-9 110 7.5 9
Apr 23, 2013 box Tue home Astros Bud Norris - R Mariners Hisashi Iwakuma - R 3-2 1 W -2.5 U 9-9 0-1 2-0 113 7.5 9
Apr 27, 2013 box Sat home White Sox Gavin Floyd - R Rays Matt Moore - L 4-10 -6 L 6.5 O 9-19 1-1 0-7 112 7.5 9
Jun 11, 2013 box Tue home Rays Roberto Hernandez - R Red Sox Jon Lester - L 8-3 5 W 3.0 O 10-8 1-1 5-1 110 8.0 9
Jun 28, 2013 box Fri home Twins PJ Walters - R Royals James Shields - R 3-9 -6 L 4.0 O 10-11 0-0 0-6 124 8.0 9
Jul 21, 2013 box Sun home Angels Jerome Williams - R Athletics Bartolo Colon - R 0-6 -6 L -2.0 U 4-9 3-0 0-6 109 8.0 9
Aug 23, 2013 box Fri home Mariners Felix Hernandez - R Angels Garrett Richards - R 0-2 -2 L -5.5 U 5-4 0-0 0-2 -175 7.5 9
Sep 03, 2013 box Tue home Athletics Bartolo Colon - R Rangers Martin Perez - L 1-5 -4 L -1.5 U 11-13 1-0 1-4 -125 7.5 9
Sep 25, 2013 box Wed home Orioles Bud Norris - R Blue Jays Esmil Rogers - R 9-5 4 W 6.0 O 13-15 2-0 5-3 -150 8.0 9
Oct 04, 2013 box Fri home Red Sox Jon Lester - L Rays Matt Moore - L 12-2 10 W 6.5 O 14-4 0-0 10-2 -145 7.5 9
Apr 06, 2014 box Sun home Astros Scott Feldman - R Angels Jered Weaver - R 7-4 3 W 3.0 O 7-8 0-1 6-0 145 8.0 9
Apr 11, 2014 box Fri home Mariners Felix Hernandez - R Athletics Tom Milone - L 6-4 2 W 3.5 O 12-6 1-2 6-0 -150 6.5 9
Apr 17, 2014 box Thu home Twins Kyle Gibson - R Blue Jays RA Dickey - R 7-0 7 W -0.5 U 10-4 2-2 7-0 110 7.5 9
May 15, 2014 box Thu home Twins Phil Hughes - R Red Sox Clay Buchholz - R 4-3 1 W -0.5 U 12-9 0-0 3-0 120 7.5 10+
Jun 03, 2014 box Tue home Yankees Hiroki Kuroda - R Athletics Scott Kazmir - L 2-5 -3 L -1.0 U 7-7 1-0 1-3 116 8.0 10+
Jun 19, 2014 box Thu home Tigers Anibal Sanchez - R Royals Danny Duffy - L 2-1 1 W -5.0 U 4-6 0-1 1-1 -155 8.0 9
Jul 05, 2014 box Sat home Indians TJ House - L Royals Jeremy Guthrie - R 7-3 4 W 2.0 O 14-12 0-0 5-1 -118 8.0 9
Aug 11, 2014 box Mon home Royals Yordano Ventura - R Athletics Sonny Gray - R 3-2 1 W -2.0 U 6-3 0-1 2-0 100 7.0 9
Sep 23, 2014 box Tue home Athletics Sonny Gray - R Angels Wade LeBlanc - L 0-2 -2 L -5.5 U 7-3 1-0 0-2 -185 7.5 9
Oct 03, 2014 box Fri home Angels Matt Shoemaker - R Royals Yordano Ventura - R 1-4 -3 L -2.5 U 6-8 2-1 0-3 -153 7.5 10+
Apr 13, 2015 box Mon home Blue Jays RA Dickey - R Rays Jake Odorizzi - R 1-2 -1 L -5.0 U 2-3 0-0 0-2 -132 8.0 9
Apr 21, 2015 box Tue home Royals Jason Vargas - L Twins Tommy Milone - L 6-5 1 W 3.0 O 10-10 0-0 2-2 -145 8.0 9
May 17, 2015 box Sun home Royals Edinson Volquez - R Yankees Chris Capuano - L 6-0 6 W -2.0 U 7-6 0-2 6-0 -130 8.0 9
Jul 26, 2015 box Sun home Royals Yordano Ventura - R Astros Dallas Keuchel - L 5-1 4 W -1.0 U 11-6 0-0 4-0 102 7.0 9
Aug 06, 2015 box Thu home Athletics Aaron Brooks - R Astros Scott Feldman - R 4-5 -1 L 1.5 O 7-9 2-1 1-2 108 7.5 10+
Aug 10, 2015 box Mon home Mariners Vidal Nuno - L Orioles Wei Yin Chen - L 2-3 -1 L -2.5 U 5-7 0-1 0-2 108 7.5 9
Aug 23, 2015 box Sun home Angels Garrett Richards - R Blue Jays RA Dickey - R 5-12 -7 L 9.0 O 12-17 2-0 4-7 -105 8.0 9
Sep 17, 2015 box Thu home Indians Corey Kluber - R Royals Yordano Ventura - R 4-8 -4 L 5.0 O 11-13 1-4 0-5 -130 7.0 9
Apr 19, 2016 box Tue home Royals Yordano Ventura - R Tigers Shane Greene - R 8-6 2 W 6.0 O 9-10 1-0 6-0 -150 8.0 9
Apr 23, 2016 box Sat home White Sox Carlos Rodon - L Rangers Colby Lewis - R 4-3 1 W -1.0 U 11-7 1-0 1-1 -143 8.0 10+
Jun 11, 2016 box Sat home White Sox Jose Quintana - L Royals Danny Duffy - L 1-4 -3 L -3.0 U 5-9 0-0 0-4 -135 8.0 9
Jun 24, 2016 box Fri home Yankees Masahiro Tanaka - R Twins Tommy Milone - L 5-3 2 W 0.0 P 8-7 0-3 2-2 -210 8.0 9
Aug 13, 2016 box Sat home Athletics Kendall Graveman - R Mariners Hisashi Iwakuma - R 3-4 -1 L -0.5 U 11-9 0-0 1-3 123 7.5 9
Sep 16, 2016 box Fri home Mariners Felix Hernandez - R Astros Collin McHugh - R 0-6 -6 L -2.0 U 3-9 3-0 0-6 -125 8.0 9
Oct 26, 2016 box Wed home Indians Trevor Bauer - R Cubs Jake Arrieta - R 1-5 -4 L -1.5 U 4-9 2-0 0-5 143 7.5 9
Apr 15, 2017 box Sat home Indians Corey Kluber - R Tigers Justin Verlander - R 13-6 7 W 11.0 O 19-11 0-0 7-0 -160 8.0 9
May 02, 2017 box Tue home Tigers Justin Verlander - R Indians Corey Kluber - R 5-2 3 W -0.5 U 7-6 0-0 4-1 113 7.5 9
Apr 17, 2018 box Tue home Tigers Francisco Liriano - L Orioles Andrew Cashner - R 4-2 2 W -2.0 U 9-6 0-1 2-0 -105 8.0 9
Jun 02, 2018 box Sat home Astros Justin Verlander - R Red Sox David Price - L 4-5 -1 L 1.5 O 6-5 0-0 2-2 -185 7.5 9
Jun 10, 2018 box Sun home Rays Nathan Eovaldi - R Mariners James Paxton - L 4-5 -1 L 2.0 O 9-6 0-0 2-2 145 7.0 9
Sep 19, 2018 box Wed home Yankees Luis Severino - R Red Sox David Price - L 10-1 9 W 3.0 O 11-9 0-1 9-0 -160 8.0 9
Oct 18, 2018 box Thu home Astros Justin Verlander - R Red Sox David Price - L 1-4 -3 L -3.0 U 5-8 1-0 0-4 -185 8.0 9
Apr 09, 2019 box Tue home Red Sox Chris Sale - L Blue Jays Matt Shoemaker - R 5-7 -2 L 4.0 O 8-10 0-2 2-3 -230 8.0 9

Game Parameters: at bats, attendance, biggest lead, date, day, division, double header, double plays, earned runs, errors, game number, hit batters, hit by pitchers, hits, inning runs, innings led, innings tied, league, left on base, line, location, losses, margin, matchup losses, matchup wins, month, opponents, ou margin, ou streak, over, pitchers used, playoffs, profit, rest, run line, run line runs, run line streak, runs, scored first, season, series game, series games, site, site streak, start time, starter, starter losses, starter matchup losses, starter matchup wins, starter rest, starter throws, starter wins, streak, strike outs, team, team left on base, temperature, times tied, total, umpires, under, walks, wins

Pitcher Parameters: batters faced, earned runs, era, fly balls, ground balls, hit batters, hits allowed, home runs allowed, innings pitched, name, order, pitches, result, runs allowed, strike outs thrown, strikes, walks allowed

Batter Parameters: at bats, average, batting order, doubles, hit by pitchers, hits, home runs, left on base, name, position, rbi, runs, sacrifice flies, strike outs, triples, walks


How to Query:

The syntax for access to the MLB team database is: game reference:parameter. To see the date, team, and opponent where the team scored 12 runs after scoring 11 runs in the previous game use the SDQL: date,team,o:team@runs=12 and p:runs=11

The syntax for access to the MLB batters and pitchers databases is: team:player name:game reference:parameter. To see the date, team, opponent and number of hits by Arron Hill in the game after Arron Hill got 4 hits use the SDQL: date,team,o:team,Blue Jays:Aaron Hill:hits@Blue Jays:Aaron Hill:p:hits=4

The SDQL strives to be flexible in isolating batters and pitchers and all these formats for setting Arron Hill's previous hits to 4 are acceptable: Aaron Hill:p:hits=4, AaHi:p:hits=4, and AHill:p:hits=4
e-mail links:   Content@SportsDataBase.com    Support@SportsDataBase.com   
Content for this site is generated using the Sports Data Query Language (SDQL).