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 = Pirates and season = 2019 and month > 5
SU: 41-65 (-0.84, 38.7%)   avg line: 130.4 / -143.4   on / against: -$1,804 / +$1,365   ROI: -16.1% / +8.8%
RL: 48-57 (0.13, 45.7%)   avg line: -119.2 / -101.0   on / against: -$1,830 / +$1,120   ROI: -13.4% / +9.0%
OU: 60-40-5 (1.26, 60.0%)   avg total: 9.5   over / under: +$1,580 / -$2,486   ROI: +13.5% / -21.7%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.95 2.60 7.08 9.48 2.32 1.02 2.55 1.34 2.83 14.09 None 0.89 3.43 4.51
Opp 5.79 3.64 9.00 9.58 2.40 1.61 3.00 1.50 4.49 15.11 None 0.80 2.79 4.40
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jun 08, 2019 box Sat away Pirates Jordan Lyles - R Brewers Zach Davies - R 3-5 -2 L -1.5 U 8-10 0-1 2-2 160 9.5 9
Jun 09, 2019 box Sun away Pirates Steven Brault - L Brewers Chase Anderson - R 2-5 -3 L -2.0 U 5-9 1-0 2-3 180 9.0 9
Jun 10, 2019 box Mon away Pirates Joe Musgrove - R Braves Kevin Gausman - R 7-13 -6 L 10.0 O 10-13 0-3 1-6 145 10.0 9
Jun 11, 2019 box Tue away Pirates Chris Archer - R Braves Mike Foltynewicz - R 5-7 -2 L 9-10 1-0 2-3 135 9
Jun 12, 2019 box Wed away Pirates Mitch Keller - R Braves Mike Soroka - R 7-8 -1 L 6.0 O 13-15 1-0 1-4 185 9.0 10+
Jun 13, 2019 box Thu away Pirates Joe Musgrove - R Braves Julio Teheran - R 5-6 -1 L 1.5 O 9-10 0-1 1-4 148 9.5 9
Jun 14, 2019 box Fri away Pirates Steven Brault - L Marlins Trevor Richards - R 11-0 11 W 2.5 O 18-9 1-2 11-0 105 8.5 9
Jun 15, 2019 box Sat away Pirates Dario Agrazal - R Marlins Pablo Lopez - R 3-4 -1 L -0.5 U 8-10 1-0 3-1 115 7.5 9
Jun 16, 2019 box Sun away Pirates Chris Archer - R Marlins Sandy Alcantara - R 5-4 1 W 0.5 O 11-9 0-0 2-2 -130 8.5 9
Jun 18, 2019 box Tue home Pirates Mitch Keller - R Tigers Daniel Norris - L 4-5 -1 L 0.5 O 8-6 3-1 1-3 -140 8.5 9
Jun 19, 2019 box Wed home Pirates Trevor Williams - R Tigers Jordan Zimmermann - R 8-7 1 W 6.0 O 11-11 1-0 1-6 -200 9.0 9
Jun 21, 2019 box Fri home Pirates Joe Musgrove - R Padres Eric Lauer - L 2-1 1 W -5.5 U 6-7 2-2 1-0 -113 8.5 9
Jun 22, 2019 box Sat home Pirates Chris Archer - R Padres Chris Paddack - R 6-3 3 W 0.0 P 10-6 0-0 4-1 105 9.0 9
Jun 23, 2019 box Sun home Pirates Steven Brault - L Padres Joey Lucchesi - L 11-10 1 W 11.5 O 17-13 0-1 1-3 125 9.5 10+
Jun 25, 2019 box Tue away Pirates Trevor Williams - R Astros Gerrit Cole - R 1-5 -4 L -2.5 U 8-10 1-0 0-4 250 8.5 9
Jun 26, 2019 box Wed away Pirates Dario Agrazal - R Astros Framber Valdez - L 14-2 12 W 6.5 O 15-9 0-1 12-0 205 9.5 9
Jun 27, 2019 box Thu away Pirates Joe Musgrove - R Astros Brad Peacock - R 10-0 10 W 0.5 O 14-9 0-1 10-0 172 9.5 9
Jun 28, 2019 box Fri away Pirates Chris Archer - R Brewers Jhoulys Chacin - R 3-2 1 W -5.0 U 9-6 0-0 1-2 137 10.0 9
Jun 29, 2019 box Sat away Pirates Jordan Lyles - R Brewers Brandon Woodruff - R 1-3 -2 L -5.0 U 6-5 1-0 1-2 190 9.0 9
Jun 30, 2019 box Sun away Pirates Steven Brault - L Brewers Zach Davies - R 1-2 -1 L -7.5 U 7-8 4-0 1-1 150 10.5 9
Jul 01, 2019 box Mon home Pirates Trevor Williams - R Cubs Adbert Alzolay - R 18-5 13 W 13.5 O 23-13 0-2 13-0 106 9.5 9
Jul 02, 2019 box Tue home Pirates Joe Musgrove - R Cubs Kyle Hendricks - R 5-1 4 W -3.0 U 7-6 0-0 5-0 117 9.0 9
Jul 03, 2019 box Wed home Pirates Chris Archer - R Cubs Yu Darvish - R 6-5 1 W 1.5 O 11-9 1-0 1-2 105 9.5 9
Jul 04, 2019 box Thu home Pirates Jordan Lyles - R Cubs Jose Quintana - L 3-11 -8 L 4.5 O 6-15 0-1 0-8 110 9.5 9
Jul 05, 2019 box Fri home Pirates Steven Brault - L Brewers Zach Davies - R 6-7 -1 L 2.5 O 13-13 0-1 0-5 105 10.5 10+
Jul 06, 2019 box Sat home Pirates Dario Agrazal - R Brewers Adrian Houser - R 12-2 10 W 3.5 O 17-7 0-0 10-1 115 10.5 9
Jul 07, 2019 box Sun home Pirates Joe Musgrove - R Brewers Chase Anderson - R 6-5 1 W 1.5 O 10-8 0-0 3-0 -115 9.5 9
Jul 12, 2019 box Fri away Pirates Chris Archer - R Cubs Yu Darvish - R 3-4 -1 L -2.5 U 5-6 0-0 0-3 155 9.5 9
Jul 13, 2019 box Sat away Pirates Jordan Lyles - R Cubs Jon Lester - L 4-10 -6 L 3.5 O 11-13 2-1 0-10 165 10.5 9
Jul 14, 2019 box Sun away Pirates Trevor Williams - R Cubs Jose Quintana - L 3-8 -5 L 1.0 O 9-13 0-0 2-5 162 10.0 9
Jul 15, 2019 box Mon away Pirates Joe Musgrove - R Cardinals Miles Mikolas - R 0-7 -7 L -1.0 U 8-8 1-1 0-7 127 8.0 9
Jul 16, 2019 box Tue away Pirates Dario Agrazal - R Cardinals Jack Flaherty - R 3-1 2 W -5.0 U 5-5 1-0 2-0 155 9.0 9
Jul 17, 2019 box Wed away Pirates Chris Archer - R Cardinals Daniel Ponce de Leon - ? 5-6 -1 L 2.0 O 11-7 1-0 2-2 130 9.0 9
Jul 19, 2019 box Fri home Pirates Jordan Lyles - R Phillies Jake Arrieta - R 1-6 -5 L -3.0 U 7-15 1-0 1-5 -108 10.0 9
Jul 20, 2019 box Sat home Pirates Joe Musgrove - R Phillies Zach Eflin - R 5-1 4 W -4.0 U 13-3 1-1 4-0 -130 10.0 9
Jul 21, 2019 box Sun home Pirates Dario Agrazal - R Phillies Drew Smyly - L 1-2 -1 L -8.0 U 6-6 0-0 1-1 -120 11.0 10+
Jul 22, 2019 box Mon home Pirates Trevor Williams - R Cardinals Daniel Ponce de Leon - ? 5-6 -1 L 1.0 O 12-8 3-1 0-4 103 10.0 10+
Jul 23, 2019 box Tue home Pirates Chris Archer - R Cardinals Dakota Hudson - R 3-4 -1 L -2.0 U 6-7 0-0 3-1 -125 9.0 9
Jul 24, 2019 box Wed home Pirates Jordan Lyles - R Cardinals Adam Wainwright - R 8-14 -6 L 12.5 O 11-15 1-1 2-9 -104 9.5 9
Jul 25, 2019 box Thu home Pirates Joe Musgrove - R Cardinals Miles Mikolas - R 3-6 -3 L 0.0 P 7-8 1-0 0-5 -116 9.0 9
Jul 26, 2019 box Fri away Pirates Dario Agrazal - R Mets Zack Wheeler - R 3-6 -3 L -0.5 U 8-6 0-2 1-3 160 9.5 9
Jul 27, 2019 box Sat away Pirates Trevor Williams - R Mets Steven Matz - L 0-3 -3 L -6.0 U 5-4 0-1 0-3 130 9.0 9
Jul 28, 2019 box Sun away Pirates Chris Archer - R Mets Jacob deGrom - L 7-8 -1 L 6.0 O 9-8 3-1 0-6 120 9.0 9
Jul 29, 2019 box Mon away Pirates Alex McRae - R Reds Sonny Gray - R 6-11 -5 L 7.0 O 9-13 1-0 1-9 205 10.0 9
Jul 30, 2019 box Tue away Pirates Joe Musgrove - R Reds Tanner Roark - R 11-4 7 W 5.5 O 12-8 2-0 8-0 115 9.5 9
Jul 31, 2019 box Wed away Pirates Dario Agrazal - R Reds Luis Castillo - R 1-4 -3 L -4.5 U 6-10 0-0 0-4 190 9.5 9
Aug 02, 2019 box Fri home Pirates Trevor Williams - R Mets Steven Matz - L 8-4 4 W 3.0 O 10-9 1-1 4-3 102 9.0 9
Aug 03, 2019 box Sat home Pirates Chris Archer - R Mets Marcus Stroman - R 5-7 -2 L 3.0 O 10-12 0-0 2-4 122 9.0 9
Aug 04, 2019 box Sun home Pirates Joe Musgrove - R Mets Noah Syndergaard - R 2-13 -11 L 6.5 O 4-16 1-0 0-13 125 8.5 9
Aug 05, 2019 box Mon home Pirates Dario Agrazal - R Brewers Jordan Lyles - R 7-9 -2 L 6.0 O 8-13 1-1 0-5 130 10.0 9
Aug 06, 2019 box Tue home Pirates Steven Brault - L Brewers Chase Anderson - R 3-4 -1 L -2.5 U 10-7 1-0 0-2 135 9.5 9
Aug 07, 2019 box Wed home Pirates Trevor Williams - R Brewers Drew Pomeranz - L 3-8 -5 L 1.5 O 6-10 2-2 0-7 120 9.5 9
Aug 09, 2019 box Fri away Pirates Chris Archer - R Cardinals Dakota Hudson - R 2-6 -4 L -1.0 U 7-10 1-0 1-4 135 9.0 9
Aug 10, 2019 box Sat away Pirates Joe Musgrove - R Cardinals Adam Wainwright - R 1-3 -2 L -4.5 U 6-7 1-0 1-2 155 8.5 9
Aug 11, 2019 box Sun away Pirates Steven Brault - L Cardinals Miles Mikolas - R 9-11 -2 L 11.0 O 13-14 1-1 4-3 175 9.0 9
Aug 12, 2019 box Mon away Pirates Mitch Keller - R Angels Jose Suarez - L 10-2 8 W 2.0 O 13-9 1-3 8-0 135 10.0 9
Aug 13, 2019 box Tue away Pirates Trevor Williams - R Angels Griffin Canning - R 10-7 3 W 7.0 O 17-10 0-2 5-4 150 10.0 9
Aug 14, 2019 box Wed away Pirates Chris Archer - R Angels Dillon Peters - L 4-7 -3 L 1.0 O 6-10 1-1 2-4 120 10.0 9
Aug 16, 2019 box Fri home Pirates Joe Musgrove - R Cubs Kyle Hendricks - R 3-2 1 W -4.0 U 5-5 0-1 1-1 120 9.0 9
Aug 17, 2019 box Sat home Pirates Steven Brault - L Cubs Jon Lester - L 0-2 -2 L -8.5 U 4-4 1-2 0-2 134 10.5 9
Aug 18, 2019 box Sun home Pirates Mitch Keller - R Cubs Jose Quintana - L 1-7 -6 L -1.5 U 7-9 1-1 0-7 145 9.5 9
Aug 19, 2019 box Mon home Pirates Trevor Williams - R Nationals Joe Ross - R 0-13 -13 L 2.5 O 4-15 1-0 0-13 116 10.5 9
Aug 20, 2019 box Tue home Pirates Chris Archer - R Nationals Stephen Strasburg - R 4-1 3 W -3.5 U 7-6 0-0 3-1 140 8.5 9
Aug 21, 2019 box Wed home Pirates Joe Musgrove - R Nationals Patrick Corbin - L 1-11 -10 L 3.0 O 5-12 2-0 0-11 140 9.0 9
Aug 22, 2019 box Thu home Pirates Steven Brault - L Nationals Max Scherzer - R 1-7 -6 L 0.0 P 7-14 1-0 0-6 190 8.0 9
Aug 23, 2019 box Fri home Pirates Mitch Keller - R Reds Anthony DeSclafani - R 3-2 1 W -4.0 U 9-8 0-1 1-1 -112 9.0 9
Aug 24, 2019 box Sat home Pirates Trevor Williams - R Reds Alex Wood - L 14-0 14 W 5.0 O 10-7 0-1 14-0 -103 9.0 9
Aug 25, 2019 box Sun home Pirates Dario Agrazal - R Reds Trevor Bauer - R 9-8 1 W 8.0 O 12-11 0-1 5-3 122 9.0 9
Aug 26, 2019 box Mon away Pirates Joe Musgrove - R Phillies Jason Vargas - L 5-6 -1 L 2.0 O 13-11 0-0 2-2 127 9.0 10+
Aug 27, 2019 box Tue away Pirates Steven Brault - L Phillies Drew Smyly - L 5-4 1 W -1.0 U 11-11 0-1 2-1 120 10.0 9
Aug 28, 2019 box Wed away Pirates Mitch Keller - R Phillies Vince Velasquez - R 3-12 -9 L 5.0 O 9-17 2-0 0-9 135 10.0 9
Aug 29, 2019 box Thu away Pirates Trevor Williams - R Rockies Chi Chi Gonzalez - R 11-8 3 W 5.0 O 15-12 0-0 8-0 -104 14.0 9
Aug 30, 2019 box Fri away Pirates Dario Agrazal - R Rockies Antonio Senzatela - R 9-4 5 W -1.0 U 16-10 0-2 5-0 110 14.0 9
Aug 31, 2019 box Sat away Pirates Joe Musgrove - R Rockies Tim Melville - R 11-4 7 W 1.5 O 17-9 0-3 7-0 -130 13.5 9
Sep 01, 2019 box Sun away Pirates Steven Brault - L Rockies Jeff Hoffman - R 6-2 4 W -6.0 U 14-4 2-3 4-0 100 14.0 9
Sep 03, 2019 box Tue home Pirates Mitch Keller - R Marlins Sandy Alcantara - R 4-5 -1 L 0.0 P 4-7 2-0 1-2 -160 9.0 10+
Sep 04, 2019 box Wed home Pirates Trevor Williams - R Marlins Robert Dugger - R 6-5 1 W 2.0 O 10-10 1-1 1-2 -185 9.0 9
Sep 05, 2019 box Thu home Pirates Dario Agrazal - R Marlins Elieser Hernandez - R 7-10 -3 L 8.0 O 10-16 2-2 4-5 -145 9.0 9
Sep 06, 2019 box Fri home Pirates Alex McRae - R Cardinals Miles Mikolas - R 9-4 5 W 3.5 O 12-9 0-0 5-3 150 9.5 9
Sep 07, 2019 box Sat home Pirates Steven Brault - L Cardinals Adam Wainwright - R 1-10 -9 L 2.0 O 6-11 2-0 0-9 135 9.0 9
Sep 08, 2019 box Sun home Pirates James Marvel - R Cardinals Jack Flaherty - R 0-2 -2 L -6.5 U 5-5 0-0 0-2 210 8.5 9
Sep 09, 2019 box Mon away Pirates Trevor Williams - R Giants Madison Bumgarner - L 6-4 2 W 2.5 O 10-9 0-1 2-2 150 7.5 9
Sep 10, 2019 box Tue away Pirates Mitch Keller - R Giants Johnny Cueto - R 4-5 -1 L 0.5 O 7-9 1-0 0-5 115 8.5 9
Sep 11, 2019 box Wed away Pirates Dario Agrazal - R Giants Logan Webb - R 6-3 3 W 0.0 P 9-3 2-2 4-0 135 9.0 9
Sep 12, 2019 box Thu away Pirates Joe Musgrove - R Giants Jeff Samardzija - R 4-2 2 W -2.5 U 8-8 0-0 3-0 103 8.5 9
Sep 13, 2019 box Fri away Pirates Steven Brault - L Cubs Jon Lester - L 8-17 -9 L 14.0 O 13-16 0-3 4-10 165 11.0 9
Sep 14, 2019 box Sat away Pirates James Marvel - R Cubs Kyle Hendricks - R 1-14 -13 L 5.0 O 8-14 0-0 0-13 205 10.0 9
Sep 15, 2019 box Sun away Pirates Trevor Williams - R Cubs Jose Quintana - L 6-16 -10 L 10.5 O 14-19 1-1 2-10 220 11.5 9
Sep 17, 2019 box Tue home Pirates Mitch Keller - R Mariners Marco Gonzales - L 0-6 -6 L -2.5 U 8-10 0-0 0-6 -117 8.5 9
Sep 18, 2019 box Wed home Pirates Dario Agrazal - R Mariners Justin Dunn - R 1-4 -3 L -4.5 U 6-7 0-0 0-4 -108 9.5 9
Sep 19, 2019 box Thu home Pirates Joe Musgrove - R Mariners Yusei Kikuchi - L 5-6 -1 L 2.0 O 11-13 3-1 1-4 -135 9.0 10+
Sep 20, 2019 box Fri away Pirates Steven Brault - L Brewers Chase Anderson - R 1-10 -9 L 1.5 O 6-10 1-2 0-9 190 9.5 9
Sep 21, 2019 box Sat away Pirates James Marvel - R Brewers Zach Davies - R 1-10 -9 L 2.0 O 6-10 2-1 1-9 220 9.0 9
Sep 22, 2019 box Sun away Pirates Trevor Williams - R Brewers Brandon Woodruff - R 3-4 -1 L -2.0 U 4-7 1-1 0-4 250 9.0 9
Sep 24, 2019 box Tue home Pirates Mitch Keller - R Cubs Kyle Hendricks - R 9-2 7 W 2.5 O 10-9 0-4 7-1 170 8.5 9
Sep 25, 2019 box Wed home Pirates Dario Agrazal - R Cubs Jon Lester - L 4-2 2 W -3.5 U 9-6 1-0 2-1 170 9.5 9
Sep 26, 2019 box Thu home Pirates Joe Musgrove - R Cubs Jose Quintana - L 9-5 4 W 5.0 O 16-6 1-2 7-0 -102 9.0 9
Sep 27, 2019 box Fri home Pirates Steven Brault - L Reds Anthony DeSclafani - R 6-5 1 W 2.5 O 10-7 1-2 1-4 130 8.5 9
Sep 28, 2019 box Sat home Pirates James Marvel - R Reds Lucas Sims - R 2-4 -2 L -3.0 U 5-13 1-1 1-2 115 9.0 10+
Sep 29, 2019 box Sun home Pirates Trevor Williams - R Reds Tyler Mahle - R 1-3 -2 L -4.5 U 7-8 1-0 0-2 128 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).