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

p:hits >= 12 and p:W and AF and SG > 1 and total <= 8.5 and date >= 20110715 and -140 <= line <= -125 and month in [7 , 8 , 9]
RL: 47-35 (0.02, 57.3%)   avg line: 127.5 / -140.0   on / against: +$2,527 / -$3,123   ROI: +30.8% / -27.2%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.89 3.43 7.96 8.98 1.70 1.07 2.57 1.29 4.63 15.12 None 0.80 2.37 3.73
Opp 3.37 2.46 8.28 7.76 1.50 0.79 2.01 0.84 2.61 13.66 None 0.76 3.20 4.20
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jul 15, 2011 box Fri away Rangers Colby Lewis - R Mariners Doug Fister - R 4-0 4 W -3.0 U 6-4 0-1 4-0 -125 7.0 9
Jul 17, 2011 box Sun away Rangers Matt Harrison - L Mariners Blake Beavan - R 3-1 2 W -3.0 U 7-5 0-1 3-0 -135 7.0 9
Jul 23, 2011 box Sat away Cardinals Jaime Garcia - L Pirates Kevin Correia - R 9-1 8 W 2.5 O 12-8 0-0 8-0 -135 7.5 9
Aug 06, 2011 box Sat away Phillies Cole Hamels - L Giants Matt Cain - R 2-1 1 W -3.5 U 5-7 0-1 2-0 -125 6.5 9
Aug 07, 2011 box Sun away Cardinals Jaime Garcia - L Marlins Javier Vazquez - R 8-4 4 W 3.5 O 9-9 0-2 4-1 -131 8.5 9
Aug 09, 2011 box Tue away Red Sox Erik Bedard - L Twins Francisco Liriano - L 4-3 1 W -1.5 U 6-6 0-0 1-2 -130 8.5 9
Aug 16, 2011 box Tue away Rangers Derek Holland - L Angels Tyler Chatwood - R 7-3 4 W 1.5 O 17-9 0-0 6-0 -130 8.5 9
Aug 17, 2011 box Wed away Blue Jays Brandon Morrow - R Mariners Blake Beavan - R 5-1 4 W -1.5 U 6-3 2-1 5-0 -135 7.5 9
Aug 18, 2011 box Thu away Indians Justin Masterson - R White Sox Philip Humber - R 4-2 2 W -2.0 U 9-9 0-0 2-1 -125 8.0 9
Sep 06, 2011 box Tue away White Sox Jake Peavy - R Twins Liam Hendriks - R 3-0 3 W -5.5 U 4-6 0-0 3-0 -135 8.5 9
Sep 09, 2011 box Fri away Phillies Roy Halladay - R Brewers Shaun Marcum - R 5-3 2 W 1.5 O 11-6 0-0 5-0 -140 6.5 9
Sep 10, 2011 box Sat away Marlins Anibal Sanchez - R Pirates Jeff Locke - L 3-0 3 W -5.0 U 7-1 1-0 3-0 -125 8.0 9
Sep 18, 2011 box Sun away Indians Justin Masterson - R Twins Carl Pavano - R 6-5 1 W 2.5 O 8-10 4-2 3-3 -140 8.5 9
Sep 21, 2011 box Wed away Mariners Michael Pineda - R Twins Kevin Slowey - R 5-4 1 W 1.5 O 8-14 0-1 3-2 -135 7.5 9
Sep 28, 2011 box Wed away Rangers Matt Harrison - L Angels Garrett Richards - R 3-1 2 W -4.5 U 6-8 0-0 2-0 -135 8.5 9
Jul 24, 2012 box Tue away Reds Mike Leake - R Astros Lucas Harrell - R 4-2 2 W -1.5 U 11-8 1-1 2-2 -135 7.5 9
Aug 08, 2012 box Wed away Diamondbacks Ian Kennedy - R Pirates Kevin Correia - R 6-7 -1 L 5.0 O 8-9 1-4 2-3 -130 8.0 9
Aug 11, 2012 box Sat away Reds Bronson Arroyo - R Cubs Travis Wood - L 4-2 2 W -1.5 U 12-5 0-0 2-2 -138 7.5 9
Aug 15, 2012 box Wed away Dodgers Clayton Kershaw - L Pirates Wandy Rodriguez - L 9-3 6 W 5.0 O 15-6 0-1 7-0 -138 7.0 9
Aug 19, 2012 box Sun away Giants Ryan Vogelsong - R Padres Clayton Richard - L 1-7 -6 L 1.0 O 7-16 0-1 0-6 -126 7.0 9
Sep 08, 2012 box Sat away Athletics Brett Anderson - L Mariners Hisashi Iwakuma - R 6-1 5 W 0.5 O 10-7 1-1 5-0 -130 6.5 9
Sep 09, 2012 box Sun away Braves Tommy Hanson - R Mets Chris Young - R 3-2 1 W -3.0 U 6-8 1-0 1-1 -125 8.0 10+
Sep 18, 2012 box Tue away Orioles Wei Yin Chen - L Mariners Erasmo Ramirez - R 4-2 2 W -1.0 U 10-12 0-0 2-2 -135 7.0 10+
Sep 19, 2012 box Wed away Brewers Marco Estrada - R Pirates Kyle McPherson - R 3-1 2 W -4.0 U 11-6 1-2 3-0 -125 8.0 9
Jul 03, 2013 box Wed away Tigers Max Scherzer - R Blue Jays Josh Johnson - R 6-2 4 W -0.5 U 8-9 0-3 6-0 -128 8.5 9
Jul 04, 2013 box Thu away Cardinals Adam Wainwright - R Angels Joe Blanton - R 5-6 -1 L 3.0 O 10-11 0-1 2-2 -130 8.0 9
Jul 07, 2013 box Sun away Tigers Doug Fister - R Indians Corey Kluber - R 6-9 -3 L 6.5 O 13-8 0-0 1-5 -134 8.5 9
Jul 07, 2013 box Sun away Braves Kris Medlen - R Phillies Jonathan Pettibone - R 3-7 -4 L 1.5 O 10-10 1-0 0-6 -140 8.5 9
Jul 10, 2013 box Wed away Red Sox Felix Doubront - L Mariners Aaron Harang - R 11-4 7 W 7.0 O 12-9 0-1 9-0 -135 8.0 9
Jul 11, 2013 box Thu away Red Sox Ryan Dempster - R Mariners Erasmo Ramirez - R 8-7 1 W 7.0 O 10-12 2-0 1-4 -135 8.0 10+
Jul 20, 2013 box Sat away Phillies Cole Hamels - L Mets Zack Wheeler - R 4-5 -1 L 1.0 O 10-9 0-1 1-3 -130 8.0 9
Jul 23, 2013 box Tue away Reds Tony Cingrani - L Giants Eric Surkamp - L 9-3 6 W 4.5 O 15-8 0-0 7-1 -130 7.5 9
Jul 26, 2013 box Fri away Mets Matt Harvey - R Nationals Ross Ohlendorf - R 1-2 -1 L -4.0 U 8-6 1-1 1-1 -130 7.0 9
Aug 17, 2013 box Sat away Giants Matt Cain - R Marlins Henderson Alvarez - R 6-4 2 W 3.0 O 5-5 1-0 4-0 -135 7.0 9
Aug 20, 2013 box Tue away Cardinals Lance Lynn - R Brewers Kyle Lohse - R 3-6 -3 L 1.0 O 8-10 1-0 3-3 -133 8.0 9
Aug 25, 2013 box Sun away Diamondbacks Patrick Corbin - L Phillies Roy Halladay - R 5-9 -4 L 6.5 O 8-8 2-0 1-7 -140 7.5 9
Aug 28, 2013 box Wed away Yankees Hiroki Kuroda - R Blue Jays Todd Redmond - R 2-7 -5 L 0.5 O 5-10 1-0 0-7 -137 8.5 9
Aug 29, 2013 box Thu away Royals Bruce Chen - L Twins Samuel Deduno - R 3-1 2 W -4.0 U 6-5 0-0 3-0 -130 8.0 9
Sep 13, 2013 box Fri away Indians Danny Salazar - R White Sox Hector Santiago - L 3-1 2 W -4.0 U 7-9 1-0 3-0 -140 8.0 9
Sep 21, 2013 box Sat away Cardinals Lance Lynn - R Brewers Yovani Gallardo - R 7-2 5 W 1.0 O 9-7 0-1 6-0 -140 8.0 9
Sep 26, 2013 box Thu away Rays Alex Cobb - R Yankees Ivan Nova - R 4-0 4 W -3.5 U 11-3 0-0 4-0 -125 7.5 9
Sep 28, 2013 box Sat away Red Sox Jon Lester - L Orioles Wei Yin Chen - L 5-6 -1 L 3.0 O 14-12 0-1 1-2 -135 8.0 9
Sep 28, 2013 box Sat away Royals Yordano Ventura - R White Sox Erik Johnson - R 5-6 -1 L 3.5 O 7-9 2-0 0-4 -127 7.5 9
Jul 19, 2014 box Sat away Indians Corey Kluber - R Tigers Drew Verhagen - R 6-2 4 W -0.5 U 12-7 0-1 5-0 -135 8.5 9
Jul 20, 2014 box Sun away Rays Chris Archer - R Twins Kevin Correia - R 5-3 2 W -0.5 U 11-6 2-1 4-0 -135 8.5 9
Aug 02, 2014 box Sat away Pirates Vance Worley - R Diamondbacks Chase Anderson - R 8-3 5 W 2.5 O 11-9 2-2 7-0 -130 8.5 9
Aug 06, 2014 box Wed away Royals Yordano Ventura - R Diamondbacks Josh Collmenter - R 4-3 1 W -0.5 U 5-12 0-0 2-0 -140 7.5 9
Sep 09, 2014 box Tue away Pirates Edinson Volquez - R Phillies David Buchanan - R 3-4 -1 L -1.0 U 7-8 0-1 1-1 -137 8.0 9
Sep 11, 2014 box Thu away Pirates Francisco Liriano - L Phillies AJ Burnett - R 4-1 3 W -2.5 U 8-6 0-0 4-0 -140 7.5 9
Sep 16, 2014 box Tue away Tigers Rick Porcello - R Twins Ricky Nolasco - R 3-4 -1 L -1.5 U 8-9 0-0 1-2 -130 8.5 9
Jul 02, 2015 box Thu away Brewers Matt Garza - R Phillies Chad Billingsley - R 8-7 1 W 6.5 O 16-16 0-1 4-0 -135 8.5 10+
Jul 04, 2015 box Sat away Mariners Felix Hernandez - R Athletics Kendall Graveman - R 0-2 -2 L -4.5 U 6-10 0-0 0-2 -128 6.5 9
Aug 21, 2015 box Fri away Diamondbacks Rubby De La Rosa - R Reds David Holmberg - L 6-3 3 W 0.5 O 13-9 0-0 5-0 -138 8.5 9
Sep 02, 2015 box Wed away Rangers Cole Hamels - L Padres Ian Kennedy - R 4-3 1 W 0.5 O 9-8 0-2 1-1 -135 6.5 10+
Sep 05, 2015 box Sat away Mariners Felix Hernandez - R Athletics Jesse Chavez - R 8-3 5 W 3.5 O 14-7 0-0 6-0 -130 7.5 9
Sep 06, 2015 box Sun away Mariners Hisashi Iwakuma - R Athletics Sean Nolin - L 3-2 1 W -3.0 U 7-9 0-0 3-0 -130 8.0 9
Sep 13, 2015 box Sun away Royals Johnny Cueto - R Orioles Wei Yin Chen - L 2-8 -6 L 2.0 O 7-12 1-0 0-6 -130 8.0 9
Sep 23, 2015 box Wed away Rangers Colby Lewis - R Athletics Felix Doubront - L 10-3 7 W 5.0 O 11-6 0-2 7-1 -125 8.0 9
Sep 25, 2015 box Fri away Mets Noah Syndergaard - R Reds Anthony DeSclafani - R 12-5 7 W 9.0 O 14-11 0-1 12-0 -135 8.0 9
Jul 20, 2016 box Wed away Indians Carlos Carrasco - R Royals Ian Kennedy - R 11-4 7 W 6.5 O 10-7 0-0 11-0 -135 8.5 9
Aug 07, 2016 box Sun away Giants Madison Bumgarner - L Nationals Tanner Roark - R 0-1 -1 L -6.5 U 5-2 0-1 0-1 -125 7.5 9
Aug 21, 2016 box Sun away Mets Noah Syndergaard - R Giants Jeff Samardzija - R 2-0 2 W -5.5 U 4-3 0-0 2-0 -125 7.5 9
Sep 04, 2016 box Sun away Red Sox Eduardo Rodriguez - L Athletics Kendall Graveman - R 0-1 -1 L -7.5 U 6-2 2-1 0-1 -125 8.5 9
Jul 15, 2017 box Sat away Giants Madison Bumgarner - L Padres Jhoulys Chacin - R 3-5 -2 L 0.0 P 6-7 0-0 2-2 -135 8.0 9
Aug 18, 2017 box Fri away Cardinals Carlos Martinez - R Pirates Trevor Williams - R 11-10 1 W 12.5 O 13-10 1-0 8-0 -130 8.5 9
Sep 21, 2017 box Thu away Indians Danny Salazar - R Angels Parker Bridwell - R 4-1 3 W -3.5 U 6-5 0-1 3-1 -125 8.5 9
Aug 01, 2018 box Wed away Astros Dallas Keuchel - L Mariners Wade LeBlanc - ? 8-3 5 W 3.0 O 15-9 0-0 6-0 -135 8.0 9
Aug 12, 2018 box Sun away Nationals Max Scherzer - R Cubs Cole Hamels - L 3-4 -1 L -0.5 U 3-6 0-0 3-1 -137 7.5 9
Sep 14, 2018 box Fri away Dodgers Walker Buehler - R Cardinals Jack Flaherty - R 3-0 3 W -4.5 U 7-2 0-0 3-0 -125 7.5 9
Sep 19, 2018 box Wed away Cubs Cole Hamels - L Diamondbacks Robbie Ray - L 0-9 -9 L 1.0 O 1-12 1-1 0-9 -140 8.0 9
Sep 29, 2018 box Sat away Pirates Jameson Taillon - R Reds Michael Lorenzen - R 0-3 -3 L -5.5 U 6-7 0-0 0-3 -135 8.5 9
Aug 04, 2019 box Sun away Mets Noah Syndergaard - R Pirates Joe Musgrove - R 13-2 11 W 6.5 O 16-4 0-1 13-0 -135 8.5 9
Sep 29, 2019 box Sun away Reds Tyler Mahle - R Pirates Trevor Williams - R 3-1 2 W -4.5 U 8-7 0-1 2-0 -138 8.5 9
Sep 17, 2020 box Thu away Giants Tyler Anderson - L Mariners Nick Margevicius - L 6-4 2 W 1.5 O 9-7 1-0 2-3 -140 8.5 9
Jul 07, 2021 box Wed away Phillies Zack Wheeler - R Cubs Alec Mills - R 3-8 -5 L 3.5 O 6-10 1-1 0-5 -130 7.5 9
Jul 17, 2021 box Sat away Brewers Brandon Woodruff - R Reds Luis Castillo - R 7-4 3 W 3.0 O 15-5 2-1 4-2 -130 8.0 10+
Jul 18, 2021 box Sun away Brewers Corbin Burnes - R Reds Sonny Gray - R 8-0 8 W 0.0 P 11-5 1-1 8-0 -137 8.0 9
Jul 28, 2021 box Wed away Astros Jake Odorizzi - R Mariners Yusei Kikuchi - L 11-4 7 W 6.5 O 15-8 0-1 8-0 -125 8.5 9
Jul 31, 2021 box Sat away Brewers Brandon Woodruff - R Braves Kyle Muller - L 1-8 -7 L 0.5 O 7-13 1-2 1-7 -140 8.5 9
Aug 17, 2021 box Tue away Braves Huascar Ynoa - R Marlins Sandy Alcantara - R 2-0 2 W -5.5 U 6-4 0-0 2-0 -135 7.5 9
Aug 18, 2021 box Wed away Brewers Freddy Peralta - R Cardinals Jack Flaherty - R 6-4 2 W 3.0 O 8-8 0-3 3-3 -125 7.0 10+
Aug 18, 2021 box Wed away Angels Shohei Ohtani - R Tigers Tarik Skubal - L 3-1 2 W -4.0 U 7-6 0-0 2-0 -140 8.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).