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 = Yankees and H and o:team = Blue Jays and season >= 2011 and SG = SGS
RL: 16-11 (0.80, 59.3%)   avg line: -100.7 / -114.4   on / against: +$576 / -$738   ROI: +18.0% / -22.0%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 5.32 3.71 7.46 8.18 1.61 1.71 2.71 1.43 5.39 13.00 None 0.64 2.46 4.04
Opp 3.54 2.54 9.43 7.93 1.54 1.11 2.21 0.86 2.43 14.29 None 0.64 3.68 3.93
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
May 01, 2011 box Sun home Yankees Ivan Nova - R Blue Jays Jesse Litsch - R 5-2 3 W -3.0 U 6-6 0-0 3-1 -160 10.0 9
May 25, 2011 box Wed home Yankees Freddy Garcia - R Blue Jays Jo Jo Reyes - L 7-3 4 W 1.0 O 9-10 0-2 6-0 -165 9.0 9
Sep 04, 2011 box Sun home Yankees CC Sabathia - L Blue Jays Brett Cecil - L 9-3 6 W 3.0 O 9-8 1-3 6-0 -265 9.0 9
Jul 18, 2012 box Wed home Yankees Hiroki Kuroda - R Blue Jays Ricky Romero - L 6-0 6 W 12-4 1-0 6-0 -165 9
Aug 29, 2012 box Wed home Yankees CC Sabathia - L Blue Jays JA Happ - L 5-8 -3 L 4.5 O 8-12 3-0 2-3 -250 8.5 9
Sep 20, 2012 box Thu home Yankees Phil Hughes - R Blue Jays Aaron Laffey - L 10-7 3 W 7.5 O 8-10 0-1 6-2 -240 9.5 9
Apr 28, 2013 box Sun home Yankees Phil Hughes - R Blue Jays RA Dickey - R 3-2 1 W -4.0 U 4-8 0-0 1-1 -110 9.0 9
May 18, 2013 box Sat home Yankees David Phelps - R Blue Jays Brandon Morrow - R 7-2 5 W 0.5 O 8-8 0-2 5-0 -120 8.5 9
Aug 22, 2013 box Thu home Yankees Andy Pettitte - L Blue Jays JA Happ - L 5-3 2 W -1.0 U 4-8 0-1 4-1 -155 9.0 9
Jun 19, 2014 box Thu home Yankees David Phelps - R Blue Jays Drew Hutchison - R 6-4 2 W 1.0 O 10-8 0-0 4-0 100 9.0 9
Jul 27, 2014 box Sun home Yankees Shane Greene - R Blue Jays JA Happ - L 4-5 -1 L 0.0 P 7-12 1-0 0-2 -131 9.0 9
Sep 21, 2014 box Sun home Yankees Masahiro Tanaka - R Blue Jays Drew Hutchison - R 5-2 3 W -0.5 U 8-7 0-0 4-1 -145 7.5 9
Apr 09, 2015 box Thu home Yankees CC Sabathia - L Blue Jays Daniel Norris - L 3-6 -3 L 1.0 O 7-9 1-0 0-4 110 8.0 9
Aug 09, 2015 box Sun home Yankees Masahiro Tanaka - R Blue Jays Marco Estrada - R 0-2 -2 L -6.0 U 3-5 0-0 0-2 -145 8.0 9
Sep 13, 2015 box Sun home Yankees Masahiro Tanaka - R Blue Jays RA Dickey - R 5-0 5 W -3.5 U 7-4 0-0 5-0 -148 8.5 9
May 26, 2016 box Thu home Yankees CC Sabathia - L Blue Jays JA Happ - L 1-3 -2 L -4.5 U 4-6 1-0 1-2 107 8.5 9
Aug 17, 2016 box Wed home Yankees CC Sabathia - L Blue Jays JA Happ - L 4-7 -3 L 1.5 O 9-11 1-0 0-5 145 9.5 9
Sep 07, 2016 box Wed home Yankees Bryan Mitchell - R Blue Jays Marcus Stroman - R 2-0 2 W -7.0 U 9-5 0-1 2-0 155 9.0 9
May 03, 2017 box Wed home Yankees CC Sabathia - L Blue Jays Marcus Stroman - R 8-6 2 W 5.5 O 12-8 0-0 2-4 100 8.5 9
Jul 05, 2017 box Wed home Yankees Michael Pineda - R Blue Jays Marco Estrada - R 6-7 -1 L 3.5 O 6-11 1-0 1-5 -160 9.5 9
Oct 01, 2017 box Sun home Yankees Jordan Montgomery - L Blue Jays Brett Anderson - L 1-2 -1 L -5.5 U 5-2 0-0 0-1 -155 8.5 9
Apr 22, 2018 box Sun home Yankees Luis Severino - R Blue Jays Jaime Garcia - L 5-1 4 W -2.5 U 9-4 0-1 4-0 -240 8.5 9
Aug 19, 2018 box Sun home Yankees JA Happ - L Blue Jays Ryan Borucki - L 10-2 8 W 3.0 O 12-9 0-1 8-1 -250 9.0 9
Sep 16, 2018 box Sun home Yankees Lance Lynn - R Blue Jays Thomas Pannone - L 2-3 -1 L -4.5 U 6-7 0-1 2-1 -215 9.5 9
Jun 26, 2019 box Wed home Yankees James Paxton - L Blue Jays Trent Thornton - R 8-7 1 W 5.0 O 16-13 2-0 1-5 -260 10.0 9
Jul 14, 2019 box Sun home Yankees Masahiro Tanaka - R Blue Jays Marcus Stroman - R 4-2 2 W -3.5 U 10-6 3-0 2-0 -220 9.5 9
Sep 22, 2019 box Sun home Yankees Luis Severino - R Blue Jays Wilmer Font - R 8-3 5 W 1.0 O 7-9 0-0 8-0 -320 10.0 9
Sep 17, 2020 box Thu home Yankees Masahiro Tanaka - R Blue Jays Julian Merryweather - R 10-7 3 W 7.5 O 14-12 0-1 7-0 -230 9.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).