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

Starter:strike outs thrown = 7 and season = 2017
SU: 243-202 (0.55, 54.6%)   avg line: -115.8 / 103.5   on / against: +$1,332 / -$3,573   ROI: +2.3% / -6.7%
RL: 234-211 (0.32, 52.6%)   avg line: -105.4 / -114.3   on / against: +$2,350 / -$5,750   ROI: +4.2% / -9.8%
OU: 165-260-20 (-0.46, 38.8%)   avg total: 8.7   over / under: -$11,479 / +$8,145   ROI: -23.6% / +16.5%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.42 3.26 8.12 8.40 1.87 1.23 2.49 1.08 3.98 14.02 None 0.94 2.49 4.03
Opp 3.87 3.01 9.94 7.79 1.70 1.07 2.31 0.92 3.14 13.53 None 0.80 2.79 4.20
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Aug 29, 2017 box Tue home Twins Ervin Santana - R White Sox James Shields - R 6-4 2 W 0.5 O 8-10 0-0 4-0 -230 9.5 9
Aug 30, 2017 box Wed home Astros Dallas Keuchel - L Rangers Andrew Cashner - R 1-8 -7 L 0.5 O 4-11 0-2 1-7 -190 8.5 9
Aug 30, 2017 box Wed away Red Sox Rick Porcello - R Blue Jays JA Happ - L 7-1 6 W -1.0 U 10-6 0-0 6-1 -120 9.0 9
Aug 30, 2017 box Wed away Cardinals Carlos Martinez - R Brewers Chase Anderson - R 5-6 -1 L 2.0 O 5-10 3-0 2-3 -115 9.0 9
Aug 31, 2017 box Thu away Nationals Gio Gonzalez - L Brewers Zach Davies - R 3-6 -3 L 0.0 P 7-13 0-0 1-3 125 9.0 9
Aug 31, 2017 box Thu away Braves Sean Newcomb - L Cubs Kyle Hendricks - R 2-6 -4 L 0.5 O 6-11 1-1 0-4 200 7.5 9
Aug 31, 2017 box Thu home Reds Robert Stephenson - R Mets Jacob deGrom - R 7-2 5 W 0.0 P 9-7 0-1 5-1 125 9.0 9
Sep 01, 2017 box Fri home Mariners Mike Leake - R Athletics Sean Manaea - L 3-2 1 W -4.5 U 8-8 0-0 1-2 -135 9.5 9
Sep 01, 2017 box Fri away Dodgers Clayton Kershaw - L Padres Dinelson Lamet - R 1-0 1 W -6.0 U 9-2 0-0 1-0 -300 7.0 9
Sep 01, 2017 box Fri home White Sox Reynaldo Lopez - R Rays Blake Snell - L 1-3 -2 L -5.0 U 7-6 2-2 0-2 178 9.0 9
Sep 02, 2017 box Sat away Phillies Aaron Nola - R Marlins Dan Straily - R 9-10 -1 L 11.0 O 14-17 3-0 0-6 140 8.0 9
Sep 02, 2017 box Sat away Indians Corey Kluber - R Tigers Jordan Zimmermann - R 5-2 3 W -1.0 U 14-11 0-0 5-0 -330 8.0 9
Sep 03, 2017 box Sun away Phillies Jake Thompson - R Marlins Jose Urena - R 3-1 2 W -5.5 U 11-4 0-0 2-0 180 9.5 10+
Sep 03, 2017 box Sun away Dodgers Alex Wood - L Padres Jhoulys Chacin - R 4-6 -2 L 2.0 O 7-10 0-1 1-3 -200 8.0 9
Sep 03, 2017 box Sun away Diamondbacks Zack Godley - R Rockies German Marquez - R 5-1 4 W -5.5 U 9-5 0-1 4-0 100 11.5 9
Sep 04, 2017 box Mon home Rays Alex Cobb - R Twins Jose Berrios - R 11-4 7 W 6.5 O 13-5 1-0 8-1 -125 8.5 9
Sep 04, 2017 box Mon away Twins Jose Berrios - R Rays Alex Cobb - R 4-11 -7 L 6.5 O 5-13 0-1 1-8 115 8.5 9
Sep 05, 2017 box Tue home Dodgers Hyun Jin Ryu - L Diamondbacks Zack Greinke - R 1-3 -2 L -3.5 U 6-4 1-0 0-2 -130 7.5 10+
Sep 05, 2017 box Tue away Astros Justin Verlander - R Mariners Ariel Miranda - L 3-1 2 W -5.5 U 2-7 0-0 2-0 -160 9.5 9
Sep 05, 2017 box Tue home Reds Robert Stephenson - R Brewers Zach Davies - R 9-3 6 W 2.5 O 11-5 0-1 6-0 120 9.5 9
Sep 06, 2017 box Wed home Rays Blake Snell - L Twins Aaron Slegers - R 6-9 -3 L 6.0 O 7-11 2-0 0-3 -170 9.0 9
Sep 06, 2017 box Wed away Giants Johnny Cueto - R Rockies Kyle Freeland - L 11-3 8 W 2.0 O 17-8 1-1 8-0 170 12.0 9
Sep 07, 2017 box Thu home Dodgers Clayton Kershaw - L Rockies Jon Gray - R 1-9 -8 L 3.5 O 6-16 1-0 0-8 -310 6.5 9
Sep 08, 2017 box Fri home Cardinals Luke Weaver - R Pirates Trevor Williams - R 4-1 3 W -3.0 U 5-9 0-0 4-0 -190 8.0 9
Sep 08, 2017 box Fri away Brewers Jimmy Nelson - R Cubs John Lackey - R 2-0 2 W -5.5 U 4-5 0-0 2-0 111 7.5 9
Sep 08, 2017 box Fri home Indians Mike Clevinger - R Orioles Wade Miley - L 5-0 5 W -4.0 U 7-4 0-0 5-0 -160 9.0 9
Sep 08, 2017 box Fri home Nationals Max Scherzer - R Phillies Jake Thompson - R 11-10 1 W 13.0 O 16-14 0-2 6-3 -370 8.0 9
Sep 08, 2017 box Fri away Yankees Masahiro Tanaka - R Rangers Martin Perez - L 5-11 -6 L 6.0 O 8-15 0-2 4-6 -150 10.0 9
Sep 08, 2017 box Fri home Red Sox Drew Pomeranz - L Rays Chris Archer - R 9-3 6 W 3.5 O 12-5 0-1 8-0 -125 8.5 9
Sep 09, 2017 box Sat home Athletics Daniel Gossett - R Astros Charlie Morton - R 11-1 10 W 2.5 O 11-5 0-2 10-0 150 9.5 9
Sep 09, 2017 box Sat home Royals Jake Junis - R Twins Jose Berrios - R 5-2 3 W -2.0 U 11-9 0-0 3-1 -105 9.0 9
Sep 10, 2017 box Sun home Cardinals Michael Wacha - R Pirates Ivan Nova - R 7-0 7 W -1.5 U 8-6 0-1 7-0 -167 8.5 9
Sep 10, 2017 box Sun away Pirates Ivan Nova - R Cardinals Michael Wacha - R 0-7 -7 L -1.5 U 6-8 1-0 0-7 157 8.5 9
Sep 10, 2017 box Sun home Cubs Kyle Hendricks - R Brewers Zach Davies - R 1-3 -2 L -4.0 U 8-7 2-0 1-2 -150 8.0 9
Sep 10, 2017 box Sun home Indians Trevor Bauer - R Orioles Jeremy Hellickson - R 3-2 1 W -4.5 U 5-7 0-1 2-0 -190 9.5 9
Sep 10, 2017 box Sun home Mariners Erasmo Ramirez - R Angels Parker Bridwell - R 3-5 -2 L -1.5 U 8-8 0-0 1-3 -117 9.5 9
Sep 10, 2017 box Sun away Phillies Ben Lively - R Nationals Stephen Strasburg - R 2-3 -1 L -3.0 U 5-6 0-0 0-3 230 8.0 9
Sep 11, 2017 box Mon home Blue Jays Marco Estrada - R Orioles Ubaldo Jimenez - R 4-3 1 W -3.0 U 8-6 0-2 2-0 -105 10.0 9
Sep 11, 2017 box Mon home Rangers Cole Hamels - L Mariners Ariel Miranda - L 5-3 2 W -2.0 U 7-6 1-0 3-0 -135 10.0 9
Sep 11, 2017 box Mon home Royals Jason Hammel - R White Sox Reynaldo Lopez - R 3-11 -8 L 5.0 O 9-17 1-0 0-8 -175 9.0 9
Sep 12, 2017 box Tue home Cubs Jose Quintana - L Mets Robert Gsellman - R 8-3 5 W 2.5 O 11-7 0-0 6-1 -320 8.5 9
Sep 13, 2017 box Wed home Blue Jays Marcus Stroman - R Orioles Kevin Gausman - R 1-2 -1 L -5.5 U 7-7 1-1 0-2 -120 8.5 9
Sep 13, 2017 box Wed home Diamondbacks Patrick Corbin - L Rockies German Marquez - R 8-2 6 W 1.0 O 16-6 1-1 7-0 -146 9.0 9
Sep 13, 2017 box Wed away Tigers Buck Farmer - R Indians Mike Clevinger - R 3-5 -2 L -1.5 U 7-7 0-2 1-3 270 9.5 9
Sep 13, 2017 box Wed home Nationals Max Scherzer - R Braves Luiz Gohara - R 2-8 -6 L 1.5 O 7-10 0-1 1-6 -320 8.5 9
Sep 13, 2017 box Wed home Twins Ervin Santana - R Padres Dinelson Lamet - R 3-1 2 W -5.0 U 10-7 0-1 2-0 -148 9.0 10+
Sep 14, 2017 box Thu away Reds Amir Garrett - L Cardinals Luke Weaver - R 2-5 -3 L -2.0 U 6-6 1-1 1-4 200 9.0 9
Sep 14, 2017 box Thu home Diamondbacks Zack Godley - R Rockies Chad Bettis - R 7-0 7 W -2.5 U 9-5 0-0 7-0 -175 9.5 9
Sep 14, 2017 box Thu home Nationals Tanner Roark - R Braves Mike Foltynewicz - R 5-2 3 W -1.5 U 8-6 0-1 3-0 -180 8.5 9
Sep 14, 2017 box Thu away White Sox James Shields - R Tigers Chad Bell - L 17-7 10 W 14.0 O 25-12 1-0 12-0 110 10.0 9
Sep 15, 2017 box Fri home Astros Charlie Morton - R Mariners James Paxton - L 5-2 3 W -2.0 U 9-9 1-0 4-0 -125 9.0 9
Sep 15, 2017 box Fri home Giants Jeff Samardzija - R Diamondbacks Robbie Ray - L 2-3 -1 L -2.5 U 6-6 0-1 1-1 145 7.5 9
Sep 15, 2017 box Fri away Athletics Daniel Mengden - R Phillies Mark Leiter - R 4-0 4 W -5.5 U 8-2 0-0 4-0 110 9.5 9
Sep 15, 2017 box Fri home Reds Homer Bailey - R Pirates Chad Kuhl - R 4-2 2 W -3.5 U 9-7 0-0 3-0 -125 9.5 9
Sep 15, 2017 box Fri home Yankees Luis Severino - R Orioles Gabriel Ynoa - R 8-2 6 W 1.0 O 10-3 1-2 6-1 -340 9.0 9
Sep 16, 2017 box Sat home Angels Parker Bridwell - R Rangers Cole Hamels - L 2-0 2 W -7.0 U 4-3 0-0 2-0 -140 9.0 9
Sep 16, 2017 box Sat away Mets Jacob deGrom - R Braves RA Dickey - R 7-3 4 W 1.5 O 11-8 0-0 6-0 -117 8.5 9
Sep 16, 2017 box Sat away Cardinals Michael Wacha - R Cubs Kyle Hendricks - R 1-4 -3 L -4.5 U 6-10 0-0 0-3 140 9.5 9
Sep 16, 2017 box Sat away Dodgers Rich Hill - L Nationals AJ Cole - R 3-2 1 W -4.0 U 7-5 0-0 2-0 -152 9.0 9
Sep 17, 2017 box Sun home Angels Garrett Richards - R Rangers Miguel Gonzalez - R 2-4 -2 L -3.0 U 4-5 1-1 0-3 -190 9.0 9
Sep 17, 2017 box Sun home Braves Julio Teheran - R Mets Robert Gsellman - R 1-5 -4 L -3.0 U 4-7 1-2 0-4 -165 9.0 9
Sep 17, 2017 box Sun away Red Sox Eduardo Rodriguez - L Rays Jake Odorizzi - R 2-3 -1 L -3.5 U 3-8 2-0 0-2 -125 8.5 9
Sep 17, 2017 box Sun home Rockies Jon Gray - R Padres Jhoulys Chacin - R 3-4 -1 L -4.5 U 9-8 1-1 3-1 -205 11.5 9
Sep 19, 2017 box Tue away Nationals Max Scherzer - R Braves Luiz Gohara - R 4-2 2 W -2.0 U 11-5 0-0 2-0 -210 8.0 9
Sep 19, 2017 box Tue home Orioles Kevin Gausman - R Red Sox Drew Pomeranz - L 0-1 -1 L -7.5 U 5-6 0-1 0-1 -105 8.5 10+
Sep 19, 2017 box Tue away Dodgers Yu Darvish - R Phillies Aaron Nola - R 2-6 -4 L 0.0 P 9-8 1-0 2-4 -160 8.0 9
Sep 20, 2017 box Wed away Cardinals Luke Weaver - R Reds Rookie Davis - R 9-2 7 W 1.5 O 11-6 0-0 7-0 -180 9.5 9
Sep 21, 2017 box Thu home Astros Dallas Keuchel - L White Sox Carson Fulmer - R 1-3 -2 L -4.5 U 3-6 0-0 0-2 -310 8.5 9
Sep 21, 2017 box Thu away Royals Jason Vargas - L Blue Jays JA Happ - L 1-0 1 W -8.0 U 8-2 0-1 1-0 140 9.0 9
Sep 21, 2017 box Thu away Nationals Tanner Roark - R Braves RA Dickey - R 2-3 -1 L -4.0 U 4-7 2-0 0-2 -140 9.0 9
Sep 22, 2017 box Fri home Padres Jordan Lyles - R Rockies Jon Gray - R 1-4 -3 L -3.0 U 7-7 1-0 0-3 155 8.0 9
Sep 24, 2017 box Sun away Royals Ian Kennedy - R White Sox Lucas Giolito - R 1-8 -7 L -0.5 U 5-10 3-1 0-7 -110 9.5 9
Sep 25, 2017 box Mon home Mets Seth Lugo - R Braves Max Fried - L 3-2 1 W -4.0 U 9-7 1-2 3-0 -130 9.0 9
Sep 26, 2017 box Tue away Padres Dinelson Lamet - R Dodgers Alex Wood - L 2-9 -7 L 3.0 O 9-11 0-2 1-7 200 8.0 9
Sep 26, 2017 box Tue away Nationals Gio Gonzalez - L Phillies Jake Thompson - R 1-4 -3 L -4.0 U 4-6 1-0 1-3 -165 9.0 9
Sep 27, 2017 box Wed away Padres Clayton Richard - L Dodgers Rich Hill - L 0-10 -10 L 2.5 O 3-12 2-1 0-10 210 7.5 9
Sep 27, 2017 box Wed away Braves Sean Newcomb - L Mets Robert Gsellman - R 1-7 -6 L -0.5 U 8-7 2-0 1-6 -110 8.5 9
Sep 27, 2017 box Wed home White Sox Reynaldo Lopez - R Angels Garrett Richards - R 6-4 2 W 0.5 O 9-6 0-1 3-1 180 9.5 10+
Sep 28, 2017 box Thu away Reds Sal Romano - R Brewers Brent Suter - L 3-4 -1 L -2.0 U 8-7 1-1 1-2 145 9.0 9
Sep 28, 2017 box Thu home Nationals Edwin Jackson - R Pirates Ivan Nova - R 5-4 1 W 0.0 P 11-6 0-0 2-1 -130 9.0 9
Sep 29, 2017 box Fri home Angels Tyler Skaggs - L Mariners Marco Gonzales - L 6-5 1 W 2.0 O 9-10 0-1 1-3 -132 9.0 9
Sep 29, 2017 box Fri home Giants Chris Stratton - R Padres Jhoulys Chacin - R 8-0 8 W -0.5 U 17-8 0-0 8-0 -127 8.5 9
Sep 29, 2017 box Fri home Indians Trevor Bauer - R White Sox Mike Pelfrey - R 10-1 9 W 2.0 O 9-5 0-1 10-0 -300 9.0 9
Sep 29, 2017 box Fri away Pirates Gerrit Cole - R Nationals Stephen Strasburg - R 1-6 -5 L -0.5 U 4-12 0-1 0-6 180 7.5 9
Sep 29, 2017 box Fri home Royals Ian Kennedy - R Diamondbacks Zack Greinke - R 2-1 1 W -6.0 U 9-6 0-0 1-0 135 9.0 9
Sep 30, 2017 box Sat home Cubs Jon Lester - L Reds Jackson Stephens - R 9-0 9 W 0.5 O 10-8 0-1 9-0 -200 8.5 9
Oct 01, 2017 box Sun away Braves Max Fried - L Marlins Jose Urena - R 8-5 3 W 4.0 O 11-8 1-0 4-1 142 9.0 9
Oct 01, 2017 box Sun home Phillies Nick Pivetta - R Mets Noah Syndergaard - R 11-0 11 W 2.0 O 11-2 0-1 11-0 -120 9.0 9
Oct 06, 2017 box Fri home Astros Dallas Keuchel - L Red Sox Drew Pomeranz - L 8-2 6 W 2.0 O 12-7 0-1 7-0 -170 8.0 9
Oct 06, 2017 box Fri home Dodgers Clayton Kershaw - L Diamondbacks Taijuan Walker - R 9-5 4 W 6.5 O 12-8 2-2 6-0 -260 7.5 9
Oct 08, 2017 box Sun home Yankees Masahiro Tanaka - R Indians Carlos Carrasco - R 1-0 1 W -7.0 U 5-5 0-0 1-0 -105 8.0 9
Oct 08, 2017 box Sun away Indians Carlos Carrasco - R Yankees Masahiro Tanaka - R 0-1 -1 L -7.0 U 5-5 0-0 0-1 -105 8.0 9
Oct 09, 2017 box Mon home Cubs Jose Quintana - L Nationals Max Scherzer - R 2-1 1 W -4.5 U 4-3 4-1 1-1 105 7.5 9
Oct 09, 2017 box Mon away Nationals Max Scherzer - R Cubs Jose Quintana - L 1-2 -1 L -4.5 U 3-4 1-4 1-1 -115 7.5 9
Oct 09, 2017 box Mon away Dodgers Yu Darvish - R Diamondbacks Zack Greinke - R 3-1 2 W -5.0 U 7-3 0-0 2-0 -112 9.0 9
Oct 12, 2017 box Thu away Cubs Kyle Hendricks - R Nationals Gio Gonzalez - L 9-8 1 W 9.5 O 9-14 0-2 4-3 105 7.5 9
Oct 17, 2017 box Tue away Dodgers Yu Darvish - R Cubs Kyle Hendricks - R 6-1 5 W -1.0 U 9-8 0-2 5-1 100 8.0 9
Oct 18, 2017 box Wed away Dodgers Alex Wood - L Cubs Jake Arrieta - R 2-3 -1 L -4.5 U 4-5 0-0 0-2 -110 9.5 9
Oct 25, 2017 box Wed home Dodgers Rich Hill - L Astros Justin Verlander - R 6-7 -1 L 5.5 O 5-14 0-1 2-4 105 7.5 10+
Oct 28, 2017 box Sat home Astros Charlie Morton - R Dodgers Alex Wood - L 2-6 -4 L -0.5 U 2-7 0-0 1-5 -115 8.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).