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

The Mariners are 5-9 AGAINST since Aug 29, 2019 as a road dog.
SU: 5-9 (-1.43, 35.7%)   avg line: 186.5 / -212.2   on / against: -$298 / +$250   ROI: -21.3% / +8.4%
RL: 8-6 (0.07, 57.1%)   avg line: -121.4 / 100.7   on / against: +$215 / -$260   ROI: +11.2% / -14.8%
OU: 5-9-0 (-0.32, 35.7%)   avg total: 9.6   over / under: -$497 / +$325   ROI: -32.7% / +20.9%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 3.93 3.50 10.29 8.00 1.57 1.00 2.36 0.93 3.29 14.64 6.86 1.00 2.93 4.57
Opp 5.36 3.57 7.14 8.57 3.00 0.93 2.64 1.14 3.29 14.93 6.79 0.86 2.36 4.71
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Aug 29, 2019 box Thu away Mariners Felix Hernandez - R Rangers Lance Lynn - R 5-3 2 W -2.5 U 7-7 0-2 2-1 155 10.5 9
Aug 30, 2019 box Fri away Mariners Marco Gonzales - L Rangers Kolby Allard - L 3-6 -3 L -1.5 U 10-7 2-1 1-4 116 10.5 9
Aug 31, 2019 box Sat away Mariners Tommy Milone - L Rangers Brock Burke - L 2-3 -1 L -5.5 U 9-6 0-1 1-1 120 10.5 9
Sep 01, 2019 box Sun away Mariners Yusei Kikuchi - L Rangers Brett Martin - L 11-3 8 W 3.5 O 13-9 0-0 8-0 115 10.5 9
Sep 02, 2019 box Mon away Mariners Justus Sheffield - L Cubs Kyle Hendricks - R 1-5 -4 L -3.0 U 4-7 1-0 1-4 250 9.0 9
Sep 03, 2019 box Tue away Mariners Felix Hernandez - R Cubs Jon Lester - L 1-6 -5 L -2.5 U 9-8 1-0 0-6 230 9.5 9
Sep 05, 2019 box Thu away Mariners Marco Gonzales - L Astros Wade Miley - L 9-11 -2 L 10.5 O 12-11 1-0 7-2 220 9.5 10+
Sep 06, 2019 box Fri away Mariners Reggie McClain - R Astros Framber Valdez - L 4-7 -3 L 0.5 O 4-9 1-1 2-3 220 10.5 9
Sep 07, 2019 box Sat away Mariners Yusei Kikuchi - L Astros Justin Verlander - R 1-2 -1 L -5.5 U 6-6 0-1 1-1 370 8.5 9
Sep 08, 2019 box Sun away Mariners Felix Hernandez - R Astros Gerrit Cole - R 1-21 -20 L 13.0 O 1-22 1-0 0-20 370 9.0 9
Sep 17, 2019 box Tue away Mariners Marco Gonzales - L Pirates Mitch Keller - R 6-0 6 W -2.5 U 10-8 0-0 6-0 107 8.5 9
Sep 18, 2019 box Wed away Mariners Justin Dunn - R Pirates Dario Agrazal - R 4-1 3 W -4.5 U 7-6 0-0 4-0 -102 9.5 9
Sep 19, 2019 box Thu away Mariners Yusei Kikuchi - L Pirates Joe Musgrove - R 6-5 1 W 2.0 O 13-11 1-3 4-1 125 9.0 10+
Sep 22, 2019 box Sun away Mariners Marco Gonzales - L Orioles John Means - L 1-2 -1 L -6.5 U 7-3 2-0 1-1 115 9.5 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).