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 = 5 and season = 2017
SU: 404-378 (0.32, 51.7%)   avg line: -106.5 / -105.5   on / against: +$872 / -$4,766   ROI: +0.9% / -4.9%
RL: 422-359 (0.33, 54.0%)   avg line: -111.1 / -110.3   on / against: +$3,729 / -$11,498   ROI: +3.7% / -11.4%
OU: 386-366-29 (0.37, 51.3%)   avg total: 8.9   over / under: -$1,177 / -$5,214   ROI: -1.4% / -6.1%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.80 3.38 8.17 8.43 1.91 1.26 2.53 1.23 3.90 14.45 None 0.88 2.89 4.26
Opp 4.47 3.26 8.27 8.28 1.83 1.26 2.51 1.14 3.47 14.36 None 0.90 3.05 4.24
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Sep 09, 2017 box Sat home White Sox James Shields - R Giants Jeff Samardzija - R 13-1 12 W 5.0 O 18-3 0-1 12-0 135 9.0 9
Sep 10, 2017 box Sun away Tigers Anibal Sanchez - R Blue Jays JA Happ - L 2-8 -6 L 0.5 O 7-16 0-1 0-6 165 9.5 9
Sep 10, 2017 box Sun home Braves RA Dickey - R Marlins Odrisamer Despaigne - R 10-8 2 W 9.0 O 13-13 0-0 2-3 -135 9.0 10+
Sep 10, 2017 box Sun home Dodgers Rich Hill - L Rockies Tyler Chatwood - R 1-8 -7 L 0.5 O 8-11 0-0 0-8 -200 8.5 9
Sep 10, 2017 box Sun away Rockies Tyler Chatwood - R Dodgers Rich Hill - L 8-1 7 W 0.5 O 11-8 0-0 8-0 180 8.5 9
Sep 10, 2017 box Sun away Rays Alex Cobb - R Red Sox Rick Porcello - R 4-1 3 W -4.0 U 9-5 1-1 3-1 135 9.0 9
Sep 11, 2017 box Mon away Orioles Ubaldo Jimenez - R Blue Jays Marco Estrada - R 3-4 -1 L -3.0 U 6-8 2-0 0-2 -105 10.0 9
Sep 11, 2017 box Mon home Rays Jake Odorizzi - R Yankees CC Sabathia - L 1-5 -4 L -2.5 U 8-4 2-0 1-4 125 8.5 9
Sep 12, 2017 box Tue away Reds Robert Stephenson - R Cardinals Lance Lynn - R 4-13 -9 L 8.5 O 9-14 2-1 1-9 155 8.5 9
Sep 12, 2017 box Tue away Tigers Matthew Boyd - L Indians Corey Kluber - R 0-2 -2 L -6.0 U 5-9 0-0 0-2 410 8.0 9
Sep 12, 2017 box Tue away Braves Julio Teheran - R Nationals Gio Gonzalez - L 8-0 8 W -0.5 U 14-9 0-1 8-0 155 8.5 9
Sep 12, 2017 box Tue home Rays Blake Snell - L Yankees Sonny Gray - R 2-1 1 W -5.0 U 5-3 0-0 1-1 125 8.0 9
Sep 12, 2017 box Tue home Royals Sam Gaviglio - R White Sox Dylan Covey - R 4-3 1 W -3.0 U 4-13 0-0 4-0 -190 10.0 9
Sep 13, 2017 box Wed home Angels Tyler Skaggs - L Astros Mike Fiers - R 9-1 8 W 1.5 O 13-5 0-0 9-0 -125 8.5 9
Sep 13, 2017 box Wed away Astros Mike Fiers - R Angels Tyler Skaggs - L 1-9 -8 L 1.5 O 5-13 0-0 0-9 115 8.5 9
Sep 13, 2017 box Wed home Cubs Jon Lester - L Mets Matt Harvey - R 17-5 12 W 13.5 O 16-10 0-1 12-1 -290 8.5 9
Sep 13, 2017 box Wed home Giants Matt Moore - L Dodgers Yu Darvish - R 1-4 -3 L -3.0 U 5-6 2-0 0-4 200 8.0 9
Sep 13, 2017 box Wed away Dodgers Yu Darvish - R Giants Matt Moore - L 4-1 3 W -3.0 U 6-5 0-2 4-0 -230 8.0 9
Sep 13, 2017 box Wed away Marlins Dan Straily - R Phillies Aaron Nola - R 1-8 -7 L 0.5 O 4-13 0-0 0-7 125 8.5 9
Sep 13, 2017 box Wed home Rangers Martin Perez - L Mariners Mike Leake - R 1-8 -7 L -2.0 U 5-11 1-1 0-7 -105 11.0 9
Sep 13, 2017 box Wed away Mariners Mike Leake - R Rangers Martin Perez - L 8-1 7 W -2.0 U 11-5 1-1 7-0 -105 11.0 9
Sep 13, 2017 box Wed home Rays Blake Snell - R Yankees Jaime Garcia - L 2-3 -1 L -3.0 U 9-10 1-0 0-3 -117 8.0 9
Sep 13, 2017 box Wed away Padres Dinelson Lamet - R Twins Ervin Santana - R 1-3 -2 L -5.0 U 7-10 1-0 0-2 138 9.0 10+
Sep 14, 2017 box Thu home Red Sox Drew Pomeranz - L Athletics Daniel Gossett - R 6-2 4 W -2.0 U 8-8 1-1 5-1 -220 10.0 9
Sep 14, 2017 box Thu home Twins Jose Berrios - R Blue Jays Brett Anderson - L 3-2 1 W -4.5 U 7-8 0-1 1-1 -160 9.5 10+
Sep 15, 2017 box Fri away Cardinals Carlos Martinez - R Cubs John Lackey - R 2-8 -6 L 1.0 O 7-8 1-0 1-6 110 9.0 9
Sep 15, 2017 box Fri away White Sox Carson Fulmer - R Tigers Anibal Sanchez - R 2-3 -1 L -4.5 U 8-6 0-1 1-1 105 9.5 9
Sep 15, 2017 box Fri away Blue Jays JA Happ - L Twins Bartolo Colon - R 4-3 1 W -2.5 U 8-7 0-0 1-2 -112 9.5 9
Sep 15, 2017 box Fri away Orioles Gabriel Ynoa - R Yankees Luis Severino - R 2-8 -6 L 1.0 O 3-10 2-1 1-6 300 9.0 9
Sep 16, 2017 box Sat away Rangers Cole Hamels - L Angels Parker Bridwell - R 0-2 -2 L -7.0 U 3-4 0-0 0-2 130 9.0 9
Sep 16, 2017 box Sat away Mariners Erasmo Ramirez - R Astros Dallas Keuchel - L 6-8 -2 L 5.0 O 10-12 1-1 0-6 185 9.0 9
Sep 16, 2017 box Sat home Cubs Kyle Hendricks - R Cardinals Michael Wacha - R 4-1 3 W -4.5 U 10-6 0-0 3-0 -150 9.5 9
Sep 16, 2017 box Sat home Indians Carlos Carrasco - R Royals Jason Hammel - R 8-4 4 W 3.5 O 13-9 0-1 5-0 -240 8.5 9
Sep 16, 2017 box Sat home Nationals AJ Cole - R Dodgers Rich Hill - L 2-3 -1 L -4.0 U 5-7 0-0 0-2 142 9.0 9
Sep 16, 2017 box Sat home Rays Alex Cobb - R Red Sox Rick Porcello - R 1-3 -2 L -4.0 U 5-7 0-2 0-3 -110 8.0 9
Sep 17, 2017 box Sun away Cardinals Lance Lynn - R Cubs Jose Quintana - L 3-4 -1 L -1.0 U 10-11 0-1 0-3 150 8.0 9
Sep 17, 2017 box Sun away Brewers Brandon Woodruff - R Marlins Dillon Peters - L 10-3 7 W 4.0 O 16-8 1-1 8-0 -140 9.0 9
Sep 17, 2017 box Sun away Dodgers Hyun Jin Ryu - L Nationals Max Scherzer - R 1-7 -6 L 0.0 P 5-8 0-1 1-6 145 8.0 9
Sep 17, 2017 box Sun home Tigers Matthew Boyd - L White Sox Dylan Covey - R 12-0 12 W 1.0 O 13-1 0-0 12-0 -130 11.0 9
Sep 19, 2017 box Tue home Astros Collin McHugh - ? White Sox Lucas Giolito - R 3-1 2 W -5.0 U 8-6 2-0 2-1 -260 9.0 9
Sep 19, 2017 box Tue home Blue Jays Marcus Stroman - R Royals Ian Kennedy - R 5-2 3 W -2.0 U 8-6 0-1 4-0 -170 9.0 9
Sep 19, 2017 box Tue away Rockies German Marquez - R Giants Johnny Cueto - R 3-4 -1 L -0.5 U 10-12 0-0 2-1 -113 7.5 9
Sep 19, 2017 box Tue home Mariners Mike Leake - R Rangers Martin Perez - L 1-3 -2 L -5.5 U 6-10 0-0 0-2 -150 9.5 9
Sep 19, 2017 box Tue away Red Sox Drew Pomeranz - L Orioles Kevin Gausman - R 1-0 1 W -7.5 U 6-5 1-0 1-0 -105 8.5 10+
Sep 19, 2017 box Tue home Tigers Chad Bell - L Athletics Daniel Gossett - R 8-9 -1 L 6.5 O 15-14 1-0 4-3 113 10.5 9
Sep 19, 2017 box Tue home Yankees CC Sabathia - L Twins Jose Berrios - R 5-2 3 W -1.5 U 11-8 0-1 3-1 -160 8.5 9
Sep 20, 2017 box Wed away Indians Josh Tomlin - R Angels Ricky Nolasco - R 6-5 1 W 2.5 O 13-11 1-0 3-0 -118 8.5 9
Sep 20, 2017 box Wed away White Sox James Shields - R Astros Brad Peacock - R 3-4 -1 L -2.5 U 4-9 1-0 1-2 300 9.5 9
Sep 20, 2017 box Wed home Rays Blake Snell - L Cubs Jon Lester - L 8-1 7 W 1.0 O 10-5 0-0 7-0 113 8.0 9
Sep 21, 2017 box Thu away Twins Adalberto Mejia - L Tigers Jordan Zimmermann - R 12-1 11 W 2.5 O 14-6 1-0 11-1 -135 10.5 9
Sep 22, 2017 box Fri home Braves Sean Newcomb - L Phillies Ben Lively - R 7-2 5 W -0.5 U 11-6 0-0 6-0 -125 9.5 9
Sep 23, 2017 box Sat home Astros Charlie Morton - R Angels Bud Norris - R 6-2 4 W -1.0 U 8-5 0-1 5-0 -155 9.0 9
Sep 23, 2017 box Sat home Athletics Raul Alcantara - R Rangers Miguel Gonzalez - R 1-0 1 W -9.0 U 5-4 0-0 1-0 100 10.0 9
Sep 23, 2017 box Sat away Rangers Miguel Gonzalez - R Athletics Raul Alcantara - R 0-1 -1 L -9.0 U 4-5 0-0 0-1 -110 10.0 9
Sep 23, 2017 box Sat home Braves Julio Teheran - R Phillies Henderson Alvarez - R 4-2 2 W -3.5 U 9-8 0-0 2-2 -150 9.5 9
Sep 23, 2017 box Sat away Giants Madison Bumgarner - L Dodgers Hyun Jin Ryu - L 2-1 1 W -4.0 U 9-6 0-1 2-0 100 7.0 9
Sep 23, 2017 box Sat home Pirates Gerrit Cole - R Cardinals Lance Lynn - R 11-6 5 W 9.0 O 14-9 2-0 7-2 -115 8.0 9
Sep 23, 2017 box Sat away Twins Ervin Santana - R Tigers Matthew Boyd - L 10-4 6 W 4.5 O 12-8 0-1 7-2 -165 9.5 9
Sep 24, 2017 box Sun home Diamondbacks Patrick Corbin - L Marlins Dan Straily - R 3-2 1 W -5.5 U 8-5 0-2 1-2 -180 10.5 9
Sep 24, 2017 box Sun home Mariners Mike Leake - R Indians Corey Kluber - R 2-4 -2 L -1.5 U 6-9 1-2 0-2 180 7.5 9
Sep 24, 2017 box Sun home Tigers Buck Farmer - R Twins Jose Berrios - R 4-10 -6 L 4.0 O 9-12 2-0 0-8 155 10.0 9
Sep 24, 2017 box Sun home White Sox Lucas Giolito - R Royals Ian Kennedy - R 8-1 7 W -0.5 U 10-5 1-3 7-0 100 9.5 9
Sep 25, 2017 box Mon home Diamondbacks Zack Godley - R Giants Johnny Cueto - R 2-9 -7 L 2.0 O -113-11 9-0 2-7 -135 9.0 9
Sep 25, 2017 box Mon away Nationals AJ Cole - R Phillies Aaron Nola - R 3-1 2 W -4.5 U 8--200 0-0 2-0 145 8.5 9
Sep 25, 2017 box Mon home Rockies Tyler Chatwood - R Marlins Odrisamer Despaigne - R 4-5 -1 L -2.5 U -165-10 12-0 0-4 -160 11.5 9
Sep 26, 2017 box Tue away Mariners James Paxton - L Athletics Daniel Mengden - R 6-3 3 W 0.5 O 10-9 0-0 3-1 -120 8.5 9
Sep 26, 2017 box Tue away Reds Deck McGuire - R Brewers Zach Davies - R 6-7 -1 L 3.5 O 11-10 1-1 0-4 170 9.5 9
Sep 26, 2017 box Tue home Diamondbacks Robbie Ray - L Giants Matt Moore - L 11-4 7 W 5.5 O 10-10 2-1 8-0 -240 9.5 9
Sep 26, 2017 box Tue home Phillies Jake Thompson - R Nationals Gio Gonzalez - L 4-1 3 W -4.0 U 6-4 0-1 3-1 155 9.0 9
Sep 26, 2017 box Tue away Orioles Kevin Gausman - R Pirates Trevor Williams - R 1-10 -9 L 2.5 O 5-11 1-0 0-9 -112 8.5 9
Sep 26, 2017 box Tue home Rockies Tyler Anderson - L Marlins Jose Urena - R 6-0 6 W -5.0 U 12-5 0-0 6-0 -160 11.0 9
Sep 26, 2017 box Tue home Yankees Jordan Montgomery - L Rays Blake Snell - L 6-1 5 W -1.5 U 10-6 0-0 5-1 -170 8.5 9
Sep 27, 2017 box Wed home Phillies Mark Leiter - R Nationals Tanner Roark - R 7-5 2 W 3.0 O 9-11 0-1 3-2 145 9.0 9
Sep 27, 2017 box Wed home Pirates Chad Kuhl - R Orioles Gabriel Ynoa - R 5-3 2 W -1.0 U 9-10 0-0 2-2 -130 9.0 9
Sep 27, 2017 box Wed home Rockies Jon Gray - R Marlins Adam Conley - L 15-9 6 W 12.5 O 14-14 0-2 11-0 -200 11.5 9
Sep 28, 2017 box Thu home Cardinals Lance Lynn - R Cubs Kyle Hendricks - R 1-2 -1 L -5.0 U 6-7 1-0 0-1 -150 8.0 10+
Sep 28, 2017 box Thu home Rangers Miguel Gonzalez - R Athletics Sean Manaea - L 1-4 -3 L -5.5 U 4-9 1-1 0-3 105 10.5 9
Sep 28, 2017 box Thu home White Sox Dylan Covey - R Angels Bud Norris - R 5-4 1 W -1.5 U 10-5 0-2 1-3 102 10.5 9
Sep 29, 2017 box Fri away Brewers Chase Anderson - R Cardinals John Gant - R 5-3 2 W -0.5 U 9-6 0-1 4-0 -130 8.5 9
Sep 29, 2017 box Fri home Cubs Jose Quintana - L Reds Robert Stephenson - R 5-4 1 W 2.0 O 9-8 0-2 2-2 -185 7.0 9
Sep 29, 2017 box Fri away Padres Jhoulys Chacin - R Giants Chris Stratton - R 0-8 -8 L -0.5 U 8-17 0-0 0-8 117 8.5 9
Sep 29, 2017 box Fri home Red Sox Doug Fister - R Astros Charlie Morton - R 2-3 -1 L -4.5 U 5-6 1-0 0-3 102 9.5 9
Sep 29, 2017 box Fri away Tigers Matthew Boyd - L Twins Kyle Gibson - R 3-6 -3 L 0.0 P 9-9 0-0 3-3 160 9.0 9
Sep 30, 2017 box Sat away Mariners Andrew Moore - L Angels Ricky Nolasco - R 6-4 2 W 1.0 O 13-10 0-0 2-3 110 9.0 9
Sep 30, 2017 box Sat away Brewers Junior Guerra - R Cardinals Luke Weaver - R 6-7 -1 L 4.5 O 13-8 1-0 6-1 140 8.5 9
Sep 30, 2017 box Sat away Reds Jackson Stephens - R Cubs Jon Lester - L 0-9 -9 L 0.5 O 8-10 1-0 0-9 180 8.5 9
Sep 30, 2017 box Sat home Nationals Max Scherzer - R Pirates Jameson Taillon - R 1-4 -3 L -2.0 U 4-5 0-0 1-3 -240 7.0 9
Sep 30, 2017 box Sat away Pirates Jameson Taillon - R Nationals Max Scherzer - R 4-1 3 W -2.0 U 5-4 0-0 3-1 210 7.0 9
Sep 30, 2017 box Sat home Royals Jakob Junis - R Diamondbacks Taijuan Walker - R 4-3 1 W -2.0 U 7-8 0-0 2-1 -105 9.0 9
Oct 01, 2017 box Sun home Cardinals Jack Flaherty - R Brewers Aaron Wilkerson - R 1-6 -5 L -1.5 U 3-7 0-1 0-5 -150 8.5 9
Oct 01, 2017 box Sun away Brewers Aaron Wilkerson - R Cardinals Jack Flaherty - R 6-1 5 W -1.5 U 7-3 1-0 5-0 140 8.5 9
Oct 01, 2017 box Sun home Rangers Cole Hamels - L Athletics Daniel Mengden - R 2-5 -3 L -3.0 U 8-10 1-0 0-5 -144 10.0 9
Oct 06, 2017 box Fri away Yankees CC Sabathia - L Indians Corey Kluber - R 8-9 -1 L 10.0 O 11-9 3-2 5-1 200 7.0 10+
Oct 12, 2017 box Thu home Nationals Gio Gonzalez - L Cubs Kyle Hendricks - R 8-9 -1 L 9.5 O 14-9 2-0 3-4 -115 7.5 9
Oct 16, 2017 box Mon home Yankees CC Sabathia - L Astros Charlie Morton - R 8-1 7 W 0.5 O 7-4 1-0 8-0 -130 8.5 9
Oct 17, 2017 box Tue home Cubs Kyle Hendricks - R Dodgers Yu Darvish - R 1-6 -5 L -1.0 U 8-9 2-0 1-5 -110 8.0 9
Oct 19, 2017 box Thu away Dodgers Clayton Kershaw - L Cubs Jose Quintana - L 11-1 10 W 5.0 O 16-4 0-0 10-0 -155 7.0 9
Oct 21, 2017 box Sat home Astros Charlie Morton - R Yankees CC Sabathia - L 4-0 4 W -4.0 U 10-3 0-0 4-0 -150 8.0 9
Oct 25, 2017 box Wed away Astros Justin Verlander - R Dodgers Rich Hill - L 7-6 1 W 5.5 O 14-5 1-0 4-2 -115 7.5 10+
Oct 31, 2017 box Tue home Dodgers Rich Hill - L Astros Justin Verlander - R 3-1 2 W -3.5 U 5-6 0-0 2-1 -130 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).