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

The Diamondbacks are 47-36 ON since Sep 12, 2016 as a home dog.
SU: 47-36 (0.47, 56.6%)   avg line: 131.1 / -142.8   on / against: +$2,449 / -$2,973   ROI: +29.4% / -25.1%
RL: 58-25 (1.97, 69.9%)   avg line: -134.0 / 116.2   on / against: +$2,550 / -$3,086   ROI: +22.6% / -35.4%
OU: 40-35-8 (1.05, 53.3%)   avg total: 9.0   over / under: +$212 / -$844   ROI: +2.3% / -9.2%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 5.24 3.18 9.23 8.64 2.28 1.34 2.63 1.27 3.59 13.27 None 0.66 3.01 4.73
Opp 4.77 3.76 8.72 8.69 2.30 1.31 2.73 1.16 3.83 14.64 None 0.72 3.18 4.70
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Sep 12, 2016 box Mon home Diamondbacks Shelby Miller - R Rockies Tyler Anderson - L 12-9 3 W 11.5 O 16-15 0-1 5-3 125 9.5 9
Sep 15, 2016 box Thu home Diamondbacks Archie Bradley - R Dodgers Rich Hill - L 7-3 4 W 0.5 O 6-9 0-0 6-0 185 9.5 9
Sep 16, 2016 box Fri home Diamondbacks Zack Greinke - R Dodgers Kenta Maeda - R 2-3 -1 L -4.0 U 6-5 1-0 0-2 130 9.0 9
Sep 17, 2016 box Sat home Diamondbacks Shelby Miller - R Dodgers Brock Stewart - R 2-6 -4 L -2.5 U 6-11 1-1 0-4 145 10.5 9
Sep 18, 2016 box Sun home Diamondbacks Robbie Ray - L Dodgers Jose De Leon - R 10-9 1 W 9.5 O 16-10 0-1 6-2 118 9.5 10+
Apr 02, 2017 box Sun home Diamondbacks Zack Greinke - R Giants Madison Bumgarner - L 6-5 1 W 2.5 O 13-11 0-0 1-3 125 8.5 9
Apr 04, 2017 box Tue home Diamondbacks Patrick Corbin - L Giants Johnny Cueto - R 4-8 -4 L 3.0 O 7-15 2-0 0-6 135 9.0 9
Apr 05, 2017 box Wed home Diamondbacks Taijuan Walker - R Giants Matt Moore - L 8-6 2 W 4.5 O 12-10 0-1 4-3 -101 9.5 9
Apr 07, 2017 box Fri home Diamondbacks Shelby Miller - R Indians Josh Tomlin - R 7-3 4 W 0.0 P 11-6 1-0 4-3 122 10.0 9
Apr 08, 2017 box Sat home Diamondbacks Zack Greinke - R Indians Trevor Bauer - R 11-2 9 W 3.5 O 15-7 0-0 10-1 -101 9.5 9
Apr 09, 2017 box Sun home Diamondbacks Patrick Corbin - L Indians Corey Kluber - R 3-2 1 W -4.5 U 8-7 3-1 3-0 165 9.5 9
Apr 21, 2017 box Fri home Diamondbacks Taijuan Walker - R Dodgers Alex Wood - L 13-5 8 W 8.5 O 14-9 1-2 8-2 125 9.5 9
Apr 22, 2017 box Sat home Diamondbacks Robbie Ray - L Dodgers Kenta Maeda - R 11-5 6 W 7.0 O 14-11 0-1 6-1 105 9.0 9
Apr 23, 2017 box Sun home Diamondbacks Shelby Miller - R Dodgers Brandon McCarthy - R 2-6 -4 L -1.0 U 7-9 1-0 2-4 130 9.0 9
Jun 27, 2017 box Tue home Diamondbacks Taijuan Walker - R Cardinals Carlos Martinez - R 6-5 1 W 2.5 O 10-6 3-0 1-3 110 8.5 10+
Jul 21, 2017 box Fri home Diamondbacks Zack Godley - R Nationals Max Scherzer - R 6-5 1 W 2.0 O 12-8 0-0 5-0 137 9.0 9
Jul 22, 2017 box Sat home Diamondbacks Anthony Banda - L Nationals Tanner Roark - R 3-4 -1 L -3.0 U 4-12 0-1 0-3 107 10.0 9
Jul 23, 2017 box Sun home Diamondbacks Robbie Ray - L Nationals Stephen Strasburg - R 2-6 -4 L -0.5 U 6-9 1-0 0-5 105 8.5 9
Aug 08, 2017 box Tue home Diamondbacks Zack Godley - R Dodgers Kenta Maeda - R 6-3 3 W -0.5 U 8-9 0-1 3-2 110 9.5 9
Aug 09, 2017 box Wed home Diamondbacks Zack Greinke - R Dodgers Alex Wood - L 2-3 -1 L -3.5 U 7-5 0-0 1-1 102 8.5 9
Aug 10, 2017 box Thu home Diamondbacks Anthony Banda - L Dodgers Yu Darvish - R 6-8 -2 L 4.5 O 10-9 2-0 0-6 160 9.5 9
Aug 15, 2017 box Tue home Diamondbacks Anthony Banda - L Astros Brad Peacock - R 4-9 -5 L 3.5 O 8-13 0-1 0-8 110 9.5 9
Aug 29, 2017 box Tue home Diamondbacks Zack Godley - R Dodgers Rich Hill - L 7-6 1 W 4.0 O 10-10 0-0 5-0 110 9.0 9
Aug 30, 2017 box Wed home Diamondbacks Robbie Ray - L Dodgers Hyun Jin Ryu - L 6-4 2 W 0.5 O 11-6 0-1 6-0 102 9.5 9
Aug 31, 2017 box Thu home Diamondbacks Zack Greinke - R Dodgers Kenta Maeda - R 8-1 7 W 0.0 P 10-5 0-0 7-0 -104 9.0 9
Oct 09, 2017 box Mon home Diamondbacks Zack Greinke - R Dodgers Yu Darvish - R 1-3 -2 L -5.0 U 3-7 0-0 0-2 102 9.0 9
Apr 02, 2018 box Mon home Diamondbacks Taijuan Walker - R Dodgers Hyun Jin Ryu - L 8-7 1 W 6.0 O 14-19 0-0 1-3 100 9.0 10+
Apr 03, 2018 box Tue home Diamondbacks Zack Godley - R Dodgers Clayton Kershaw - L 6-1 5 W -0.5 U 8-4 0-1 5-0 150 7.5 9
Apr 04, 2018 box Wed home Diamondbacks Patrick Corbin - L Dodgers Alex Wood - L 3-0 3 W -5.0 U 7-1 0-0 3-0 115 8.0 9
May 01, 2018 box Tue home Diamondbacks Matt Koch - R Dodgers Clayton Kershaw - L 4-3 1 W -0.5 U 10-4 1-1 1-2 167 7.5 9
May 04, 2018 box Fri home Diamondbacks Kris Medlen - R Astros Gerrit Cole - R 0-8 -8 L -0.5 U 1-14 0-0 0-8 180 8.5 9
May 05, 2018 box Sat home Diamondbacks Zack Greinke - R Astros Charlie Morton - R 4-3 1 W -0.5 U 6-7 0-0 2-0 112 7.5 9
May 06, 2018 box Sun home Diamondbacks Matt Koch - R Astros Justin Verlander - R 3-1 2 W -3.5 U 5-7 1-1 2-1 185 7.5 9
May 11, 2018 box Fri home Diamondbacks Matt Koch - R Nationals Max Scherzer - R 1-3 -2 L -3.5 U 5-7 0-1 0-2 180 7.5 9
May 12, 2018 box Sat home Diamondbacks Troy Scribner - R Nationals Stephen Strasburg - R 1-2 -1 L -5.0 U 5-7 0-1 0-1 170 8.0 9
May 16, 2018 box Wed home Diamondbacks Matt Koch - R Brewers Brandon Woodruff - R 2-8 -6 L 1.0 O 4-10 0-0 0-6 105 9.0 9
Sep 18, 2018 box Tue home Diamondbacks Matt Andriese - R Cubs Mike Montgomery - L 1-9 -8 L 1.5 O 4-12 3-2 0-8 -104 8.5 9
Sep 19, 2018 box Wed home Diamondbacks Robbie Ray - L Cubs Cole Hamels - L 9-0 9 W 1.0 O 12-1 1-1 9-0 130 8.0 9
Sep 24, 2018 box Mon home Diamondbacks Robbie Ray - L Dodgers Clayton Kershaw - L 4-7 -3 L 3.5 O 7-9 0-0 1-4 150 7.5 9
Sep 25, 2018 box Tue home Diamondbacks Matt Koch - R Dodgers Walker Buehler - R 4-3 1 W -1.0 U 8-10 2-1 1-1 180 8.0 9
Sep 26, 2018 box Wed home Diamondbacks Zack Greinke - R Dodgers Ross Stripling - R 7-2 5 W 1.0 O 10-9 0-1 5-2 105 8.0 9
Apr 05, 2019 box Fri home Diamondbacks Zack Godley - R Red Sox Rick Porcello - R 15-8 7 W 14.0 O 18-12 0-1 13-1 105 9.0 9
Apr 06, 2019 box Sat home Diamondbacks Luke Weaver - R Red Sox David Price - L 5-4 1 W 0.0 P 11-6 0-0 1-3 120 9.0 9
Apr 07, 2019 box Sun home Diamondbacks Merrill Kelly - R Red Sox Hector Velazquez - R 0-1 -1 L -8.5 U 3-5 0-0 0-1 -102 9.5 9
Apr 12, 2019 box Fri home Diamondbacks Luke Weaver - R Padres Chris Paddack - R 1-2 -1 L -5.5 U 3-5 0-0 0-1 115 8.5 9
Apr 27, 2019 box Sat home Diamondbacks Zack Godley - R Cubs Yu Darvish - R 1-9 -8 L 0.0 P 2-12 0-1 0-8 -104 10.0 9
Apr 28, 2019 box Sun home Diamondbacks Luke Weaver - R Cubs Jose Quintana - L 5-6 -1 L 2.5 O 12-13 2-0 0-3 105 8.5 10+
May 01, 2019 box Wed home Diamondbacks Merrill Kelly - R Yankees Masahiro Tanaka - R 3-2 1 W -2.5 U 5-7 1-0 3-0 105 7.5 9
May 11, 2019 box Sat home Diamondbacks Merrill Kelly - R Braves Kevin Gausman - R 4-6 -2 L 0.5 O 8-13 0-1 0-3 110 9.5 9
May 12, 2019 box Sun home Diamondbacks Zack Godley - R Braves Max Fried - L 3-5 -2 L -1.5 U 14-12 0-1 0-4 115 9.5 9
May 18, 2019 box Sat home Diamondbacks Zack Godley - R Giants Madison Bumgarner - L 5-8 -3 L 4.5 O 6-11 0-2 0-4 105 8.5 9
May 31, 2019 box Fri home Diamondbacks Jon Duplantier - R Mets Zack Wheeler - R 4-5 -1 L 0.0 P 8-13 0-0 1-3 108 9.0 9
Jun 03, 2019 box Mon home Diamondbacks Robbie Ray - L Dodgers Walker Buehler - R 1-3 -2 L -4.5 U 3-7 0-0 0-3 135 8.5 9
Jun 04, 2019 box Tue home Diamondbacks Taylor Clarke - R Dodgers Hyun Jin Ryu - L 0-9 -9 L -0.5 U 3-12 2-3 0-9 200 9.5 9
Jun 05, 2019 box Wed home Diamondbacks Jon Duplantier - R Dodgers Kenta Maeda - R 3-2 1 W -4.5 U 5-7 0-0 1-2 150 9.5 10+
Jun 24, 2019 box Mon home Diamondbacks Zack Greinke - R Dodgers Clayton Kershaw - L 8-5 3 W 4.5 O 11-10 1-0 4-3 118 8.5 9
Jun 26, 2019 box Wed home Diamondbacks Taylor Clarke - R Dodgers Tony Gonsolin - R 8-2 6 W 0.0 P 9-5 1-3 6-0 132 10.0 9
Jul 07, 2019 box Sun home Diamondbacks Alex Young - L Rockies German Marquez - R 5-3 2 W -0.5 U 8-4 0-0 5-0 118 8.5 9
Jul 19, 2019 box Fri home Diamondbacks Taylor Clarke - R Brewers Jhoulys Chacin - R 10-7 3 W 7.0 O 10-12 1-1 6-2 110 10.0 9
Jul 21, 2019 box Sun home Diamondbacks Alex Young - L Brewers Brandon Woodruff - R 4-7 -3 L 2.0 O 9-8 0-0 4-3 135 9.0 9
Aug 03, 2019 box Sat home Diamondbacks Robbie Ray - L Nationals Stephen Strasburg - R 18-7 11 W 16.5 O 15-11 0-0 14-2 120 8.5 9
Aug 04, 2019 box Sun home Diamondbacks Taylor Clarke - R Nationals Patrick Corbin - L 7-5 2 W 2.5 O 9-9 1-0 2-2 135 9.5 9
Aug 29, 2019 box Thu home Diamondbacks Merrill Kelly - R Dodgers Hyun Jin Ryu - L 11-5 6 W 6.5 O 16-7 0-1 7-3 180 9.5 9
Aug 30, 2019 box Fri home Diamondbacks Zac Gallen - R Dodgers Tony Gonsolin - R 5-4 1 W 0.0 P 8-10 0-0 1-3 110 9.0 9
Aug 31, 2019 box Sat home Diamondbacks Robbie Ray - L Dodgers Clayton Kershaw - L 6-5 1 W 3.0 O 6-10 0-1 2-3 133 8.0 9
Sep 01, 2019 box Sun home Diamondbacks Alex Young - L Dodgers Ross Stripling - R 3-4 -1 L -2.5 U 8-9 0-0 1-2 150 9.5 10+
Sep 13, 2019 box Fri home Diamondbacks Mike Leake - R Reds Luis Castillo - R 3-4 -1 L -1.5 U 7-5 1-0 0-3 108 8.5 9
Sep 23, 2019 box Mon home Diamondbacks Alex Young - L Cardinals Adam Wainwright - R 7-9 -2 L 7.0 O 11-9 1-1 0-4 130 9.0 9
Sep 24, 2019 box Tue home Diamondbacks Mike Leake - R Cardinals Jack Flaherty - R 3-2 1 W -3.5 U 13-13 2-0 1-1 180 8.5 10+
Jul 30, 2020 box Thu home Diamondbacks Robbie Ray - L Dodgers Ross Stripling - R 3-6 -3 L -0.5 U 5-7 0-0 0-5 140 9.5 9
Jul 31, 2020 box Fri home Diamondbacks Zac Gallen - R Dodgers Tony Gonsolin - R 5-3 2 W -1.5 U 8-9 0-1 2-2 120 9.5 9
Aug 01, 2020 box Sat home Diamondbacks Luke Weaver - R Dodgers Julio Urias - L 2-11 -9 L 3.5 O 5-11 1-0 1-9 135 9.5 9
Aug 02, 2020 box Sun home Diamondbacks Merrill Kelly - R Dodgers Clayton Kershaw - L 0-3 -3 L -6.0 U 4-9 0-0 0-3 170 9.0 9
Aug 04, 2020 box Tue home Diamondbacks Madison Bumgarner - L Astros Cristian Javier - R 2-8 -6 L 0.5 O 7-10 1-0 0-7 120 9.5 9
Aug 05, 2020 box Wed home Diamondbacks Robbie Ray - L Astros Lance Mccullers Jr - R 14-7 7 W 11.5 O 16-8 0-0 7-4 135 9.5 9
Aug 14, 2020 box Fri home Diamondbacks Merrill Kelly - R Padres Dinelson Lamet - R 5-1 4 W -3.0 U 8-6 2-0 5-0 140 9.0 9
Aug 15, 2020 box Sat home Diamondbacks Alex Young - L Padres Cal Quantrill - R 7-6 1 W 2.5 O 14-10 0-1 6-1 110 10.5 9
Aug 16, 2020 box Sun home Diamondbacks Robbie Ray - L Padres Garrett Richards - R 5-4 1 W 0.0 P 8-4 1-0 2-2 110 9.0 9
Aug 18, 2020 box Tue home Diamondbacks Luke Weaver - R Athletics Frankie Montas - R 10-1 9 W 2.0 O 11-4 0-0 9-0 140 9.0 9
Sep 08, 2020 box Tue home Diamondbacks Luke Weaver - R Dodgers Walker Buehler - R 9-10 -1 L 10.0 O 10-10 2-2 4-1 210 9.0 9
Sep 09, 2020 box Wed home Diamondbacks Taylor Clarke - R Dodgers Clayton Kershaw - L 4-6 -2 L 1.0 O 6-9 1-3 1-2 240 9.0 9
Sep 10, 2020 box Thu home Diamondbacks Madison Bumgarner - L Dodgers Dustin May - R 5-2 3 W -2.5 U 11-9 1-2 3-2 200 9.5 9
Sep 11, 2020 box Fri home Diamondbacks Caleb Smith - L Mariners Yusei Kikuchi - L 4-3 1 W -2.0 U 7-3 1-0 3-0 105 9.0 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).