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

4.0 < tA(runs @ site) < 4.8 and 44 < tS(runs, N=10) < 52 and A and season > 2008 and total > 9 and p:HL
SU: 11-20 (-1.65, 35.5%)   avg line: 125.6 / -138.3   on / against: -$709 / +$535   ROI: -21.6% / +12.1%
RL: 13-18 (-0.73, 41.9%)   avg line: -139.2 / 121.4   on / against: -$1,235 / +$961   ROI: -27.5% / +28.2%
OU: 8-21-2 (-0.79, 27.6%)   avg total: 10.0   over / under: -$1,445 / +$1,210   ROI: -43.3% / +34.7%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 3.77 3.61 7.81 8.39 2.23 1.23 2.06 0.94 2.19 15.00 7.52 0.87 3.84 3.71
Opp 5.42 2.97 7.65 9.55 2.03 1.58 3.00 1.48 5.23 13.77 6.32 1.13 2.45 4.32
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
May 06, 2009 box Wed away Mariners Carlos Silva - R Royals Sidney Ponson - R 1-9 -8 L 0.0 P 9-17 1-1 0-8 120 10.0 9
May 29, 2009 box Fri away Athletics Josh Outman - L Rangers Tommy Hunter - R 3-6 -3 L -2.0 U 9-6 0-0 1-3 100 11.0 9
Aug 18, 2009 box Tue away Orioles Jason Berken - R Rays David Price - L 4-5 -1 L -0.5 U 12-12 0-0 1-3 210 9.5 9
Aug 25, 2009 box Tue away Nationals Garrett Mock - R Cubs Carlos Zambrano - R 15-6 9 W 11.5 O 14-12 2-2 10-0 190 9.5 9
Jul 23, 2010 box Fri away Cardinals Jeff Suppan - R Cubs Randy Wells - R 0-5 -5 L -6.0 U 5-10 0-1 0-5 145 11.0 9
Aug 02, 2010 box Mon away Nationals Livan Hernandez - R Diamondbacks Rodrigo Lopez - R 3-1 2 W -5.5 U 8-5 0-0 2-0 110 9.5 9
Aug 02, 2010 box Mon away Blue Jays Brandon Morrow - R Yankees AJ Burnett - R 8-6 2 W 4.5 O 10-10 0-0 6-2 170 9.5 9
Aug 20, 2010 box Fri away Braves Jair Jurrjens - R Cubs Ryan Dempster - R 5-3 2 W -2.5 U 5-10 0-0 2-1 -135 10.5 9
Aug 30, 2010 box Mon away Padres Wade LeBlanc - L Diamondbacks Joe Saunders - L 2-7 -5 L -0.5 U 10-11 0-1 2-5 -130 9.5 9
Jul 23, 2012 box Mon away Red Sox Felix Doubront - L Rangers Scott Feldman - R 1-9 -8 L -0.5 U 10-11 2-0 1-8 115 10.5 9
Aug 27, 2012 box Mon away Dodgers Josh Beckett - R Rockies Jeff Francis - L 0-10 -10 L -0.5 U 4-13 0-1 0-10 -154 10.5 9
Jun 18, 2013 box Tue away Rays Christopher Archer - R Red Sox Alfredo Aceves - R 1-5 -4 L -4.0 U 6-8 1-0 0-4 110 10.0 9
Sep 20, 2013 box Fri away Diamondbacks Randall Delgado - R Rockies Jhoulys Chacin - R 4-9 -5 L 3.5 O 9-13 0-0 2-6 125 9.5 9
Jun 09, 2014 box Mon away Twins Ricky Nolasco - R Blue Jays RA Dickey - R 4-5 -1 L -0.5 U 9-10 0-0 2-2 170 9.5 9
Aug 28, 2015 box Fri away Tigers Matt Boyd - L Blue Jays RA Dickey - R 3-5 -2 L -1.5 U 6-9 0-0 1-4 195 9.5 9
Jul 04, 2016 box Mon away Padres Luis Perdomo - R Diamondbacks Archie Bradley - R 8-4 4 W 2.5 O 9-11 1-0 5-2 137 9.5 9
Aug 23, 2016 box Tue away Phillies Jake Thompson - R White Sox Carlos Rodon - L 1-9 -8 L 0.5 O 5-11 0-0 0-9 165 9.5 9
Sep 30, 2016 box Fri away Padres Edwin Jackson - R Diamondbacks Braden Shipley - R 3-5 -2 L -2.5 U 9-6 0-3 0-3 125 10.5 9
Jun 19, 2017 box Mon away Tigers Anibal Sanchez - R Mariners Sam Gaviglio - R 2-6 -4 L -1.5 U 5-10 0-1 2-4 130 9.5 9
Jun 23, 2017 box Fri away Twins Adalberto Mejia - L Indians Trevor Bauer - R 5-0 5 W -5.0 U 9-4 2-1 5-0 160 10.0 9
Jul 24, 2017 box Mon away Twins Bartolo Colon - R Dodgers Hyun Jin Ryu - L 4-6 -2 L 0.5 O 9-11 0-0 2-2 210 9.5 9
Aug 14, 2017 box Mon away Tigers Michael Fulmer - R Rangers Martin Perez - L 2-6 -4 L -3.0 U 9-11 2-0 2-4 103 11.0 9
Aug 25, 2017 box Fri away Pirates Ivan Nova - R Reds Robert Stephenson - R 5-9 -4 L 4.5 O 11-9 1-0 0-5 -112 9.5 9
Sep 11, 2017 box Mon away Mariners Ariel Miranda - L Rangers Cole Hamels - L 3-5 -2 L -2.0 U 6-7 0-1 0-3 125 10.0 9
May 22, 2018 box Tue away Pirates Jameson Taillon - R Reds Matt Harvey - R 2-7 -5 L -0.5 U 6-9 0-0 0-5 -115 9.5 9
Jul 10, 2018 box Tue away Diamondbacks Patrick Corbin - L Rockies Tyler Anderson - L 5-3 2 W -3.0 U 8-9 1-0 3-1 -105 11.0 9
Aug 27, 2018 box Mon away Blue Jays Sam Gaviglio - R Orioles David Hess - R 0-7 -7 L -2.5 U 7-11 0-0 0-7 -130 9.5 9
Jul 29, 2019 box Mon away Blue Jays Thomas Pannone - L Royals Brad Keller - R 7-3 4 W 0.0 P 11-6 0-0 4-1 110 10.0 9
Aug 05, 2019 box Mon away Phillies Vince Velasquez - R Diamondbacks Merrill Kelly - R 7-3 4 W 0.5 O 13-9 1-3 4-1 -103 9.5 9
Aug 20, 2019 box Tue away Phillies Aaron Nola - R Red Sox Brian Johnson - L 3-2 1 W -6.0 U 7-6 0-0 3-0 -103 11.0 9
Sep 06, 2019 box Fri away Indians Adam Plutko - R Twins Michael Pineda - R 6-2 4 W -2.5 U 10-9 1-0 4-1 155 10.5 10+

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).