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

tA(hits/at bats) <= .26 and -150 > line >= -300 and o:STDSERA <= 4.5 and 10 > month > 6 and p:runs > 0 and op:runs < 7
SU: 989-447 (1.53, 68.9%)   avg line: -183.1 / 167.6   on / against: +$17,837 / -$24,579   ROI: +6.8% / -17.1%
RL: 655-675 (0.05, 49.2%)   avg line: 115.3 / -127.8   on / against: +$7,442 / -$15,375   ROI: +5.4% / -9.0%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 5.01 3.55 7.03 9.04 2.03 1.16 2.67 1.26 4.74 14.47 7.13 0.85 2.35 3.96
Opp 3.47 2.61 8.76 7.93 1.64 0.86 2.04 0.86 2.38 13.52 6.51 0.85 3.24 4.11
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Aug 20, 2018 box Mon home Dodgers Alex Wood - L Cardinals Austin Gomber - L 3-5 -2 L -0.5 U 7-10 1-0 0-3 -175 8.5 9
Aug 21, 2018 box Tue home Diamondbacks Patrick Corbin - L Angels Felix Pena - R 5-4 1 W 0.5 O 8-10 0-1 2-0 -230 8.5 9
Aug 21, 2018 box Tue home Dodgers Hyun Jin Ryu - L Cardinals Daniel Poncedeleon - ? 2-5 -3 L -1.5 U 9-7 1-1 1-4 -180 8.5 9
Aug 21, 2018 box Tue home Rays Blake Snell - L Royals Glenn Sparkman - R 4-1 3 W -2.0 U 14-8 0-0 3-0 -275 7.0 9
Aug 21, 2018 box Tue away Cubs Kyle Hendricks - R Tigers Jordan Zimmermann - R 1-2 -1 L -6.0 U 8-11 0-1 0-2 -190 9.0 9
Aug 22, 2018 box Wed home Dodgers Walker Buehler - R Cardinals Jack Flaherty - R 1-3 -2 L -3.5 U 2-7 0-1 1-2 -160 7.5 9
Aug 22, 2018 box Wed away Astros Charlie Morton - R Mariners Marco Gonzales - L 10-7 3 W 8.5 O 17-9 1-0 8-0 -160 8.5 9
Aug 22, 2018 box Wed away Yankees Lance Lynn - R Marlins Trevor Richards - R 3-9 -6 L 4.0 O 7-14 3-0 2-6 -180 8.0 9
Aug 22, 2018 box Wed home Mets Noah Syndergaard - R Giants Casey Kelly - R 5-3 2 W 0.5 O 9-6 0-2 3-0 -160 7.5 9
Aug 22, 2018 box Wed home Nationals Stephen Strasburg - R Phillies Zach Eflin - R 8-7 1 W 6.5 O 14-11 1-2 1-3 -175 8.5 9
Aug 23, 2018 box Thu home Cubs Cole Hamels - L Reds Anthony DeSclafani - R 7-1 6 W -1.0 U 12-8 0-1 6-1 -220 9.0 9
Aug 23, 2018 box Thu home Rays Tyler Glasnow - R Royals Brad Keller - L 4-3 1 W 0.0 P 11-7 0-2 1-1 -185 7.0 9
Aug 23, 2018 box Thu home Rockies Kyle Freeland - L Padres Joey Lucchesi - L 4-3 1 W -3.0 U 7-9 1-0 1-1 -190 10.0 9
Aug 24, 2018 box Fri away Astros Dallas Keuchel - L Angels Andrew Heaney - L 9-3 6 W 4.0 O 12-7 1-0 6-0 -152 8.0 9
Aug 25, 2018 box Sat away Astros Justin Verlander - R Angels Jaime Barria - R 8-3 5 W 3.0 O 12-6 0-2 5-0 -190 8.0 9
Aug 25, 2018 box Sat home Diamondbacks Robbie Ray - L Mariners Wade LeBlanc - L 3-4 -1 L -1.5 U 10-12 0-0 2-1 -158 8.5 10+
Aug 26, 2018 box Sun home Diamondbacks Zack Greinke - R Mariners Mike Leake - R 5-2 3 W -1.0 U 8-7 2-0 4-1 -180 8.0 9
Aug 26, 2018 box Sun away Braves Kevin Gausman - R Marlins Pablo Lopez - R 4-0 4 W -3.5 U 9-2 0-1 4-0 -185 7.5 9
Aug 27, 2018 box Mon home Astros Gerrit Cole - R Athletics Brett Anderson - L 11-4 7 W 7.0 O 16-6 0-1 7-4 -200 8.0 9
Aug 28, 2018 box Tue home Astros Charlie Morton - R Athletics Edwin Jackson - R 3-4 -1 L -1.5 U 6-5 0-0 1-2 -215 8.5 9
Aug 28, 2018 box Tue home Cardinals Jack Flaherty - R Pirates Ivan Nova - R 5-2 3 W -1.0 U 10-6 0-0 4-0 -165 8.0 9
Aug 28, 2018 box Tue home Indians Carlos Carrasco - R Twins Kyle Gibson - R 8-1 7 W 0.5 O 14-7 0-2 8-0 -230 8.5 9
Aug 29, 2018 box Wed home Astros Dallas Keuchel - L Athletics Trevor Cahill - R 5-4 1 W 0.5 O 8-9 0-1 2-1 -160 8.5 9
Aug 29, 2018 box Wed home Cardinals Miles Mikolas - R Pirates Trevor Williams - R 0-2 -2 L -5.5 U 5-10 2-1 0-2 -155 7.5 9
Aug 29, 2018 box Wed away Dodgers Alex Wood - L Rangers Mike Minor - L 3-1 2 W -5.5 U 4-5 1-0 3-0 -160 9.5 9
Aug 30, 2018 box Thu home Astros Justin Verlander - R Angels Andrew Heaney - L 2-5 -3 L -0.5 U 7-10 0-0 0-5 -250 7.5 9
Aug 30, 2018 box Thu home Indians Mike Clevinger - R Twins Jake Odorizzi - R 5-3 2 W -0.5 U 6-5 1-0 3-1 -210 8.5 9
Aug 31, 2018 box Fri home Astros Framber Valdez - L Angels Jaime Barria - R 0-3 -3 L -6.0 U 6-6 1-1 0-3 -190 9.0 9
Sep 01, 2018 box Sat home Dodgers Clayton Kershaw - L Diamondbacks Patrick Corbin - L 3-2 1 W -2.0 U 6-5 2-1 1-2 -167 7.0 9
Sep 02, 2018 box Sun home Astros Gerrit Cole - R Angels Shohei Ohtani - R 4-2 2 W -2.0 U 7-7 0-0 2-0 -185 8.0 9
Sep 02, 2018 box Sun home Dodgers Walker Buehler - R Diamondbacks Clay Buchholz - R 3-2 1 W -2.5 U 5-5 0-1 1-1 -180 7.5 9
Sep 02, 2018 box Sun home Yankees Lance Lynn - R Tigers Matthew Boyd - L 7-11 -4 L 9.0 O 9-17 0-0 1-6 -260 9.0 9
Sep 03, 2018 box Mon home Astros Dallas Keuchel - L Twins Kyle Gibson - R 4-1 3 W -2.5 U 4-8 1-2 4-0 -240 7.5 9
Sep 03, 2018 box Mon home Nationals Max Scherzer - R Cardinals Jack Flaherty - R 4-3 1 W -0.5 U 8-5 0-0 1-2 -185 7.5 10+
Sep 04, 2018 box Tue home Diamondbacks Robbie Ray - L Padres Joey Lucchesi - L 6-0 6 W -2.0 U 9-3 0-2 6-0 -175 8.0 9
Sep 05, 2018 box Wed home Astros Framber Valdez - L Twins Jake Odorizzi - R 9-1 8 W 1.5 O 9-6 0-0 8-0 -240 8.5 9
Sep 05, 2018 box Wed home Dodgers Hyun Jin Ryu - L Mets Zack Wheeler - R 3-7 -4 L 3.0 O 3-14 1-0 0-5 -175 7.0 9
Sep 05, 2018 box Wed away Phillies Nick Pivetta - R Marlins Sandy Alcantara - R 1-2 -1 L -5.0 U 6-4 0-0 0-2 -165 8.0 9
Sep 05, 2018 box Wed home Rockies Antonio Senzatela - R Giants Andrew Suarez - L 5-3 2 W -2.5 U 7-9 0-0 2-1 -152 10.5 9
Sep 07, 2018 box Fri home Brewers Chase Anderson - R Giants Derek Holland - L 4-2 2 W -2.5 U 3-5 1-1 2-0 -175 8.5 9
Sep 07, 2018 box Fri home Pirates Chris Archer - R Marlins Dan Straily - R 5-3 2 W 0.0 P 9-7 0-0 2-1 -210 8.0 9
Sep 07, 2018 box Fri home Twins Stephen Gonsalves - L Royals Heath Fillmyer - R 10-6 4 W 6.5 O 12-10 0-1 4-4 -165 9.5 9
Sep 08, 2018 box Sat away Cardinals Jack Flaherty - R Tigers Matthew Boyd - L 3-4 -1 L -1.0 U 4-6 2-0 0-3 -165 8.0 9
Sep 09, 2018 box Sun home Athletics Trevor Cahill - R Rangers Jeffrey Springs - L 7-3 4 W 1.0 O 9-4 0-2 4-3 -220 9.0 9
Sep 09, 2018 box Sun home Rays Ryne Stanek - R Orioles Josh Rogers - ? 8-3 5 W 3.0 O 13-9 0-1 7-0 -250 8.0 9
Sep 10, 2018 box Mon away Yankees JA Happ - L Twins Kyle Gibson - R 7-2 5 W 0.5 O 11-10 0-1 7-0 -155 8.5 9
Sep 11, 2018 box Tue home Mets Jason Vargas - R Marlins Jose Urena - R 3-5 -2 L 0.5 O 5-7 0-0 0-4 -260 7.5 9
Sep 11, 2018 box Tue away Astros Framber Valdez - L Tigers Jordan Zimmermann - R 5-4 1 W 0.0 P 7-7 0-2 5-0 -200 9.0 9
Sep 12, 2018 box Wed home Cubs Jose Quintana - R Brewers Chase Anderson - R 1-5 -4 L -2.5 U 6-11 2-1 0-4 -155 8.5 9
Sep 12, 2018 box Wed away Dodgers Ross Stripling - R Reds Anthony DeSclafani - R 8-1 7 W 0.0 P 11-5 0-1 7-1 -200 9.0 9
Sep 13, 2018 box Thu away Dodgers Clayton Kershaw - L Cardinals Austin Gomber - L 9-7 2 W 8.5 O 16-12 2-0 7-0 -190 7.5 9
Sep 13, 2018 box Thu home Mets Steven Matz - L Marlins Sandy Alcantara - R 4-3 1 W -0.5 U 4-5 0-0 1-2 -175 7.5 9
Sep 14, 2018 box Fri home Astros Dallas Keuchel - L Diamondbacks Robbie Ray - L 2-4 -2 L -2.0 U 5-10 0-0 0-2 -175 8.0 9
Sep 14, 2018 box Fri home Indians Josh Tomlin - R Tigers Matthew Boyd - L 4-5 -1 L 0.0 P 6-11 0-1 0-3 -180 9.0 9
Sep 15, 2018 box Sat home Astros Charlie Morton - R Diamondbacks Zack Godley - R 10-4 6 W 6.0 O 12-6 1-2 8-0 -180 8.0 9
Sep 15, 2018 box Sat home Brewers Zach Davies - R Pirates Ivan Nova - R 1-3 -2 L -4.5 U 7-5 1-0 1-2 -160 8.5 9
Sep 15, 2018 box Sat home Phillies Vince Velasquez - R Marlins Jarlin Garcia - L 5-4 1 W 0.5 O 4-6 2-1 1-4 -215 8.5 9
Sep 16, 2018 box Sun home Astros Justin Verlander - R Diamondbacks Zack Greinke - R 5-4 1 W 1.5 O 12-5 0-1 4-0 -195 7.5 9
Sep 16, 2018 box Sun home Brewers Jhoulys Chacin - R Pirates Trevor Williams - R 2-3 -1 L -3.5 U 5-5 0-0 0-3 -165 8.5 9
Sep 16, 2018 box Sun home Phillies Nick Pivetta - R Marlins Jose Urena - R 4-6 -2 L 1.5 O 7-9 1-2 1-5 -190 8.5 9
Sep 17, 2018 box Mon home Astros Framber Valdez - L Mariners Wade LeBlanc - L 1-4 -3 L -3.5 U 3-9 0-0 1-3 -155 8.5 9
Sep 17, 2018 box Mon home Pirates Joe Musgrove - R Royals Brad Keller - R 7-6 1 W 5.0 O 16-10 1-1 2-2 -170 8.0 9
Sep 18, 2018 box Tue home Astros Josh James - R Mariners Mike Leake - R 7-0 7 W -1.5 U 7-6 0-1 7-0 -170 8.5 9
Sep 18, 2018 box Tue home Dodgers Clayton Kershaw - L Rockies Kyle Freeland - L 3-2 1 W -2.0 U 6-4 2-2 1-1 -220 7.0 10+
Sep 18, 2018 box Tue home Indians Corey Kluber - R White Sox Carlos Rodon - L 5-3 2 W 0.0 P 7-9 0-2 5-0 -280 8.0 9
Sep 18, 2018 box Tue home Yankees JA Happ - L Red Sox Nathan Eovaldi - R 3-2 1 W -4.0 U 3-5 2-0 2-1 -165 9.0 9
Sep 19, 2018 box Wed home Brewers Gio Gonzalez - L Reds Matt Harvey - R 7-0 7 W -1.5 U 7-2 0-0 7-0 -175 8.5 9
Sep 19, 2018 box Wed home Padres Robbie Erlin - L Giants Chris Stratton - R 8-4 4 W 4.5 O 10-8 1-0 4-3 -155 7.5 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
Sep 20, 2018 box Thu home Yankees Masahiro Tanaka - R Red Sox Eduardo Rodriguez - L 6-11 -5 L 8.5 O 7-13 2-0 2-5 -155 8.5 9
Sep 21, 2018 box Fri home Cardinals John Gant - R Giants Madison Bumgarner - L 5-3 2 W 0.5 O 11-8 0-0 2-0 -170 7.5 9
Sep 21, 2018 box Fri away Mets Jacob deGrom - R Nationals Joe Ross - R 4-2 2 W -2.0 U 8-6 0-1 3-0 -160 8.0 9
Sep 22, 2018 box Sat home Astros Justin Verlander - R Angels Jaime Barria - R 10-5 5 W 7.5 O 12-7 2-1 5-4 -280 7.5 9
Sep 22, 2018 box Sat home Athletics Mike Fiers - R Twins Chase De Jong - R 3-2 1 W -3.5 U 8-7 0-1 1-1 -250 8.5 9
Sep 22, 2018 box Sat home Braves Mike Foltynewicz - R Phillies Jake Arrieta - R 5-3 2 W -0.5 U 6-4 0-2 4-0 -165 8.5 9
Sep 22, 2018 box Sat home Cardinals Adam Wainwright - R Giants Dereck Rodriguez - R 5-4 1 W 1.0 O 8-11 4-0 1-2 -174 8.0 10+
Sep 23, 2018 box Sun home Astros Charlie Morton - R Angels Tyler Skaggs - L 6-2 4 W 0.0 P 12-4 0-1 4-1 -210 8.0 9
Sep 23, 2018 box Sun home Athletics Trevor Cahill - R Twins Kyle Gibson - R 1-5 -4 L -2.5 U 8-9 2-0 0-4 -185 8.5 9
Sep 23, 2018 box Sun away Rays Blake Snell - L Blue Jays Ryan Borucki - L 5-2 3 W -1.0 U 5-8 1-1 5-0 -175 8.0 9
Sep 23, 2018 box Sun away Phillies Aaron Nola - R Braves Anibal Sanchez - R 1-2 -1 L -4.5 U 6-4 1-0 0-1 -160 7.5 9
Sep 23, 2018 box Sun home Cardinals Miles Mikolas - R Giants Andrew Suarez - L 9-2 7 W 3.5 O 12-5 2-0 7-0 -200 7.5 9
Sep 23, 2018 box Sun home Dodgers Hyun Jin Ryu - L Padres Joey Lucchesi - L 14-0 14 W 6.5 O 16-5 0-0 14-0 -240 7.5 9
Sep 23, 2018 box Sun away Cubs Kyle Hendricks - R White Sox Carlos Rodon - L 6-1 5 W -1.5 U 15-4 0-0 6-0 -190 8.5 9
Sep 24, 2018 box Mon home Angels Felix Pena - R Rangers Adrian Sampson - R 5-4 1 W 0.5 O 7-7 0-1 2-0 -165 8.5 10+
Sep 24, 2018 box Mon away Dodgers Clayton Kershaw - L Diamondbacks Robbie Ray - L 7-4 3 W 3.5 O 9-7 0-0 4-1 -160 7.5 9
Sep 24, 2018 box Mon home Nationals Stephen Strasburg - R Marlins Sandy Alcantara - R 7-3 4 W 2.0 O 9-6 2-0 5-1 -265 8.0 9
Sep 24, 2018 box Mon home Rockies Jon Gray - R Phillies Zach Eflin - R 10-1 9 W 0.5 O 13-5 0-1 9-0 -185 10.5 9
Sep 26, 2018 box Wed away Yankees Masahiro Tanaka - R Rays Ryne Stanek - R 7-8 -1 L 7.5 O 10-10 2-0 3-5 -175 7.5 9
Sep 27, 2018 box Thu home Cubs Jon Lester - L Pirates Trevor Williams - R 3-0 3 W -6.0 U 10-4 1-0 3-0 -160 9.0 9
Sep 27, 2018 box Thu home Rockies Antonio Senzatela - R Phillies Jake Arrieta - R 5-3 2 W -3.0 U 9-8 0-1 4-0 -175 11.0 9
Sep 28, 2018 box Fri home Brewers Zach Davies - R Tigers Jordan Zimmermann - R 6-5 1 W 2.5 O 11-7 0-0 2-3 -250 8.5 9
Sep 28, 2018 box Fri home Cubs Kyle Hendricks - R Cardinals Adam Wainwright - R 8-4 4 W 4.0 O 8-9 3-3 6-0 -160 8.0 9
Sep 28, 2018 box Fri away Dodgers Hyun Jin Ryu - L Giants Madison Bumgarner - L 3-1 2 W -3.0 U 9-6 1-1 2-1 -180 7.0 9
Sep 28, 2018 box Fri home Rays Tyler Glasnow - R Blue Jays Thomas Pannone - L 6-7 -1 L 5.5 O 12-12 1-1 3-2 -160 7.5 9
Sep 28, 2018 box Fri home Twins Jose Berrios - R White Sox Reynaldo Lopez - R 2-1 1 W -5.0 U 5-4 0-0 1-0 -155 8.0 9
Sep 29, 2018 box Sat away Dodgers Clayton Kershaw - L Giants Dereck Rodriguez - R 10-6 4 W 9.0 O 18-9 0-1 5-1 -280 7.0 9
Sep 29, 2018 box Sat home Mariners James Paxton - L Rangers Adrian Sampson - R 4-1 3 W -3.0 U 9-10 2-2 3-1 -230 8.0 9
Sep 29, 2018 box Sat away Indians Corey Kluber - R Royals Jakob Junis - R 4-9 -5 L 5.0 O 10-16 0-1 2-6 -230 8.0 9
Sep 30, 2018 box Sun away Dodgers Rich Hill - L Giants Andrew Suarez - L 15-0 15 W 7.5 O 16-2 0-0 15-0 -240 7.5 9
Sep 30, 2018 box Sun home Mets Noah Syndergaard - R Marlins Sandy Alcantara - R 1-0 1 W -6.0 U 4-5 0-0 1-0 -240 7.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).