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

team = Cardinals and p:L and p:runs < 3 and season = 2013
RL: 25-21 (1.26, 54.3%)   avg line: -104.8 / -108.4   on / against: +$404 / -$654   ROI: +6.8% / -10.7%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.85 2.46 7.24 9.24 1.89 0.85 2.33 1.17 3.98 12.89 None 1.07 2.26 4.22
Opp 3.20 3.13 7.65 7.48 1.72 0.54 1.83 0.76 2.48 14.28 None 1.11 3.07 4.09
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Apr 02, 2013 box Tue away Cardinals Jaime Garcia - L Diamondbacks Trevor Cahill - R 6-1 5 W -2.0 U 10-3 1-0 5-1 105 9.0 9
Apr 06, 2013 box Sat away Cardinals Shelby Miller - R Giants Ryan Vogelsong - R 6-3 3 W 1.5 O 11-7 0-0 3-1 120 7.5 9
Apr 18, 2013 box Thu away Cardinals Adam Wainwright - R Phillies Cole Hamels - L 4-3 1 W 0.0 P 7-13 0-0 2-0 -120 7.0 9
Apr 20, 2013 box Sat away Cardinals Lance Lynn - R Phillies Cliff Lee - L 5-0 5 W -2.5 U 8-3 1-0 5-0 126 7.5 9
Apr 29, 2013 box Mon home Cardinals Adam Wainwright - R Reds Mat Latos - R 1-2 -1 L -4.0 U 7-6 0-0 0-2 -120 7.0 9
Apr 30, 2013 box Tue home Cardinals Jaime Garcia - L Reds Bronson Arroyo - R 2-1 1 W -4.5 U 7-7 0-0 1-1 -132 7.5 9
May 08, 2013 box Wed away Cardinals Jake Westbrook - R Cubs Carlos Villanueva - R 5-4 1 W 1.5 O 11-11 1-1 1-2 -120 7.5 9
May 13, 2013 box Mon home Cardinals Lance Lynn - R Mets Jeremy Hefner - R 6-3 3 W 1.0 O 11-4 0-0 3-1 -190 8.0 9
May 17, 2013 box Fri home Cardinals Jaime Garcia - L Brewers Wily Peralta - R 7-6 1 W 4.5 O 13-8 0-2 6-0 -165 8.5 9
May 21, 2013 box Tue away Cardinals Adam Wainwright - R Padres Edinson Volquez - R 10-2 8 W 5.0 O 13-7 1-1 9-1 -147 7.0 9
Jun 01, 2013 box Sat home Cardinals Shelby Miller - R Giants Matt Cain - R 8-0 8 W 0.5 O 10-7 0-0 8-0 -150 7.5 9
Jun 03, 2013 box Mon home Cardinals Lance Lynn - R Diamondbacks Trevor Cahill - R 7-1 6 W 0.5 O 14-7 0-0 6-0 -150 7.5 9
Jun 09, 2013 box Sun away Cardinals Lance Lynn - R Reds Bronson Arroyo - R 11-4 7 W 6.5 O 14-6 1-0 7-2 -113 8.5 10+
Jun 13, 2013 box Thu away Cardinals Adam Wainwright - R Mets Matt Harvey - R 2-1 1 W -3.5 U 10-7 0-0 2-0 -133 6.5 9
Jun 17, 2013 box Mon home Cardinals Shelby Miller - R Cubs Travis Wood - L 5-2 3 W -0.5 U 8-5 0-2 4-0 -210 7.5 9
Jun 19, 2013 box Wed home Cardinals Jake Westbrook - R Cubs Edwin Jackson - R 4-1 3 W -3.0 U 9-2 2-0 3-0 -170 8.0 9
Jun 23, 2013 box Sun home Cardinals Adam Wainwright - R Rangers Nicholas Tepesch - R 1-2 -1 L -4.5 U 7-7 1-0 1-1 -200 7.5 9
Jun 25, 2013 box Tue away Cardinals Jake Westbrook - R Astros Lucas Harrell - R 13-5 8 W 9.0 O 15-6 0-1 9-0 -155 9.0 9
Jun 29, 2013 box Sat away Cardinals Adam Wainwright - R Athletics Jarrod Parker - R 7-1 6 W 0.5 O 10-5 1-0 7-0 -117 7.5 9
Jul 03, 2013 box Wed away Cardinals Shelby Miller - R Angels Jerome Williams - R 12-2 10 W 5.5 O 13-6 0-1 10-0 100 8.5 9
Jul 12, 2013 box Fri away Cardinals Joe Kelly - R Cubs Carlos Villanueva - R 3-2 1 W -3.5 U 7-5 0-0 2-0 -115 8.5 9
Jul 27, 2013 box Sat away Cardinals Joe Kelly - R Braves Julio Teheran - R 0-2 -2 L -6.5 U 2-9 0-0 0-2 120 8.5 9
Jul 28, 2013 box Sun away Cardinals Shelby Miller - R Braves Kris Medlen - R 2-5 -3 L -0.5 U 8-12 2-0 0-3 -113 7.5 9
Jul 29, 2013 box Mon away Cardinals Jake Westbrook - R Pirates Francisco Liriano - L 2-9 -7 L 4.0 O 7-9 0-0 0-8 135 7.0 9
Jul 30, 2013 box Tue away Cardinals Lance Lynn - R Pirates AJ Burnett - R 1-2 -1 L -4.0 U 6-6 2-1 0-1 110 7.0 10+
Jul 30, 2013 box Tue away Cardinals Tyler Lyons - L Pirates Brandon Cumpton - R 0-6 -6 L -2.5 U 3-11 1-2 0-6 -115 8.5 9
Jul 31, 2013 box Wed away Cardinals Adam Wainwright - R Pirates Jeff Locke - L 4-5 -1 L 2.0 O 13-10 0-1 2-1 -115 7.0 9
Aug 06, 2013 box Tue home Cardinals Joe Kelly - R Dodgers Clayton Kershaw - L 5-1 4 W -0.5 U 8-9 1-0 4-0 140 6.5 9
Aug 09, 2013 box Fri home Cardinals Lance Lynn - R Cubs Christopher Rusin - L 0-3 -3 L -5.0 U 7-5 0-0 0-3 -205 8.0 9
Aug 10, 2013 box Sat home Cardinals Michael Wacha - R Cubs Carlos Villanueva - R 5-6 -1 L 3.0 O 9-10 0-0 2-2 -200 8.0 9
Aug 15, 2013 box Thu home Cardinals Lance Lynn - R Pirates AJ Burnett - R 6-5 1 W 4.0 O 12-13 0-0 1-4 -120 7.0 10+
Aug 17, 2013 box Sat away Cardinals Joe Kelly - R Cubs Travis Wood - L 4-0 4 W -4.0 U 5-5 0-0 4-0 -127 8.0 9
Aug 26, 2013 box Mon home Cardinals Tyler Lyons - L Reds Mike Leake - R 8-6 2 W 5.5 O 8-6 1-0 3-4 -108 8.5 9
Aug 30, 2013 box Fri away Cardinals Shelby Miller - R Pirates Francisco Liriano - L 0-5 -5 L -2.0 U 4-9 1-0 0-5 115 7.0 9
Aug 31, 2013 box Sat away Cardinals Lance Lynn - R Pirates AJ Burnett - R 1-7 -6 L 0.5 O 6-13 0-0 0-6 120 7.5 9
Sep 01, 2013 box Sun away Cardinals Joe Kelly - R Pirates Kris Johnson - L 7-2 5 W 1.0 O 12-6 0-0 7-0 -110 8.0 9
Sep 03, 2013 box Tue away Cardinals Michael Wacha - R Reds Homer Bailey - R 0-1 -1 L -7.0 U 2-5 0-0 0-1 130 8.0 9
Sep 04, 2013 box Wed away Cardinals Shelby Miller - R Reds Bronson Arroyo - R 5-4 1 W 1.0 O 12-10 0-1 2-2 108 8.0 10+
Sep 06, 2013 box Fri home Cardinals Joe Kelly - R Pirates AJ Burnett - R 12-8 4 W 12.5 O 16-13 2-1 11-0 -102 7.5 9
Sep 15, 2013 box Sun home Cardinals Shelby Miller - R Mariners Erasmo Ramirez - R 12-2 10 W 6.5 O 19-5 1-0 10-0 -200 7.5 9
Sep 17, 2013 box Tue away Cardinals Joe Kelly - R Rockies Juan Nicasio - R 11-4 7 W 5.5 O 18-9 1-0 10-0 -137 9.5 9
Oct 06, 2013 box Sun away Cardinals Joe Kelly - R Pirates Francisco Liriano - L 3-5 -2 L 1.5 O 7-8 1-0 0-2 150 6.5 9
Oct 15, 2013 box Tue away Cardinals Lance Lynn - R Dodgers Ricky Nolasco - R 4-2 2 W -1.0 U 6-8 0-1 3-0 117 7.0 9
Oct 24, 2013 box Thu away Cardinals Michael Wacha - R Red Sox John Lackey - R 4-2 2 W -1.0 U 7-4 1-2 2-1 109 7.0 9
Oct 28, 2013 box Mon home Cardinals Adam Wainwright - R Red Sox Jon Lester - L 1-3 -2 L -2.5 U 4-9 0-0 0-2 -125 6.5 9
Oct 30, 2013 box Wed away Cardinals Michael Wacha - R Red Sox John Lackey - R 1-6 -5 L 0.0 P 9-8 1-1 0-6 110 7.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).