Note: This site will be discontinued as of September 1, 2021.
SDQL3 access will continue with user input data at http://s3.sportsdatabase.com.

Winning picks from SDQL masters.
S p o r t s D a t a b a s e . c o m
tools for the objective handicapper


name
password


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

H and p:AL and tS(W) < oS(W) and -135 < line < 105 and op:HW and o:WP > 50 and month = 4
SU: 14-7 (0.14, 66.7%)   avg line: -114.7 / 104.7   on / against: +$585 / -$682   ROI: +24.3% / -31.8%
RL: 11-7 (-0.61, 61.1%)   avg line: 162.6 / -183.4   on / against: +$1,124 / -$1,331   ROI: +58.1% / -39.1%
OU: 17-4-0 (2.33, 81.0%)   avg total: 8.5   over / under: +$1,270 / -$1,470   ROI: +55.2% / -63.4%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 5.48 3.90 7.33 9.19 2.00 1.05 2.71 1.62 5.29 14.95 None 0.76 3.00 4.05
Opp 5.33 3.57 6.86 9.71 2.86 0.95 2.52 1.14 2.48 15.81 None 0.86 3.52 4.00
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Apr 16, 2004 box Fri home Rays Paul Abbott - R White Sox Dan Wright - R 3-0 3 W -7.5 U 6-4 0-1 3-0 100 10.5 9
Apr 23, 2004 box Fri home Royals Kevin Appier - R Twins Kyle Lohse - R 5-7 -2 L 1.0 O 12-10 0-0 4-2 -105 11.0 9
Apr 20, 2005 box Wed home Tigers Wilfredo Ledezma - L White Sox Jon Garland - R 1-9 -8 L 0.5 O 5-12 1-1 0-8 -120 9.5 9
Apr 20, 2007 box Fri home Rangers Brandon McCarthy - R Athletics Joe Blanton - R 4-16 -12 L 10.0 O 10-13 0-0 0-13 -115 10.0 9
Apr 07, 2008 box Mon home Astros Wandy Rodriguez - L Cardinals Todd Wellemeyer - R 5-3 2 W -1.0 U 9-6 0-0 3-0 -120 9.0 9
Apr 11, 2008 box Fri home Mariners Felix Hernandez - R Angels Jered Weaver - R 8-5 3 W 5.0 O 9-11 2-0 3-1 -120 8.0 9
Apr 21, 2008 box Mon home Pirates Matt Morris - R Marlins Mark Hendrickson - L 4-10 -6 L 4.0 O 8-16 0-1 0-8 -110 10.0 9
Apr 23, 2008 box Wed home Dodgers Derek Lowe - R Diamondbacks Dan Haren - R 8-3 5 W 3.0 O 13-10 0-2 5-0 -110 8.0 9
Apr 24, 2009 box Fri home White Sox Gavin Floyd - R Blue Jays Brian Tallet - L 0-14 -14 L 4.5 O 6-21 2-0 0-14 -130 9.5 9
Apr 08, 2011 box Fri home Braves Tim Hudson - R Phillies Cliff Lee - L 6-3 3 W 2.0 O 12-8 2-0 3-3 100 7.0 9
Apr 08, 2011 box Fri home Mariners Jason Vargas - L Indians Carlos Carrasco - R 3-12 -9 L 7.5 O 6-17 1-1 0-12 -130 7.5 9
Apr 08, 2011 box Fri home Red Sox John Lackey - R Yankees Phil Hughes - R 9-6 3 W 5.0 O 12-8 0-2 3-2 -130 10.0 9
Apr 19, 2011 box Tue home Blue Jays Kyle Drabek - R Yankees AJ Burnett - R 6-5 1 W 2.5 O 12-8 0-1 1-2 -105 8.5 10+
Apr 17, 2012 box Tue home Brewers Yovani Gallardo - R Dodgers Chad Billingsley - R 5-4 1 W 2.0 O 9-9 1-0 2-1 -125 7.0 9
Apr 19, 2013 box Fri home Rays Alex Cobb - R Athletics Brett Anderson - L 8-3 5 W 3.5 O 10-11 0-1 6-2 -116 7.5 9
Apr 17, 2014 box Thu home Pirates Edinson Volquez - R Brewers Yovani Gallardo - R 11-2 9 W 6.0 O 12-8 0-1 9-1 -108 7.0 9
Apr 29, 2014 box Tue home Marlins Jose Fernandez - R Braves Alex Wood - L 9-0 9 W 3.0 O 13-3 0-1 9-0 -130 6.0 9
Apr 07, 2017 box Fri home Tigers Michael Fulmer - R Red Sox Steven Wright - R 6-5 1 W 2.5 O 8-10 1-0 4-1 -120 8.5 9
Apr 21, 2017 box Fri home Pirates Tyler Glasnow - R Yankees CC Sabathia - L 6-3 3 W 1.0 O 8-10 3-1 4-0 -105 8.0 9
Apr 13, 2018 box Fri home Rays Jake Faria - R Phillies Vince Velasquez - R 1-2 -1 L -5.0 U 4-7 0-2 1-1 -105 8.0 9
Apr 19, 2018 box Thu home Phillies Jake Arrieta - R Pirates Jameson Taillon - R 7-0 7 W -0.5 U 9-2 0-0 7-0 -105 7.5 9

Game Parameters: at bats, attendance, biggest lead, d2020, 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, 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).