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 Giants are 138-152 AGAINST since Jun 25, 2016 at home.
SU: 138-152 (-0.31, 47.6%)   avg line: -112.1 / 100.7   on / against: -$3,555 / +$2,165   ROI: -9.9% / +6.4%
RL: 123-167 (-0.56, 42.4%)   avg line: 115.6 / -135.0   on / against: -$3,383 / +$1,157   ROI: -9.8% / +2.7%
OU: 132-146-12 (0.34, 47.5%)   avg total: 7.8   over / under: -$2,642 / +$274   ROI: -8.3% / +0.9%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 3.90 2.91 7.88 8.33 2.04 0.70 2.26 0.95 3.40 14.23 6.91 0.84 2.61 4.51
Opp 4.22 3.04 8.30 8.71 1.89 0.94 2.38 1.06 3.57 14.69 6.93 0.93 2.49 4.29
Date Link Day Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Aug 26, 2018 box Sun home Giants Derek Holland - L Rangers Yovani Gallardo - R 3-1 2 W -4.5 U 4-5 0-0 2-0 -158 8.5 9
Aug 27, 2018 box Mon home Giants Chris Stratton - R Diamondbacks Patrick Corbin - L 2-0 2 W -5.5 U 4-5 0-0 2-0 150 7.5 9
Aug 28, 2018 box Tue home Giants Madison Bumgarner - L Diamondbacks Clay Buchholz - R 1-0 1 W -6.0 U 7-6 2-1 1-0 -110 7.0 9
Aug 29, 2018 box Wed home Giants Dereck Rodriguez - R Diamondbacks Zack Godley - R 1-3 -2 L -3.5 U 3-5 1-0 0-3 110 7.5 9
Aug 31, 2018 box Fri home Giants Andrew Suarez - L Mets Zack Wheeler - R 7-0 7 W 0.0 P 10-3 0-0 7-0 -120 7.0 9
Sep 01, 2018 box Sat home Giants Derek Holland - L Mets Steven Matz - L 1-2 -1 L -4.5 U 3-7 0-1 1-1 -130 7.5 10+
Sep 02, 2018 box Sun home Giants Chris Stratton - R Mets Noah Syndergaard - R 1-4 -3 L -2.5 U 2-7 0-1 0-3 135 7.5 9
Sep 10, 2018 box Mon home Giants Dereck Rodriguez - R Braves Sean Newcomb - L 1-4 -3 L -2.5 U 3-7 1-0 1-3 105 7.5 9
Sep 11, 2018 box Tue home Giants Andrew Suarez - L Braves Mike Foltynewicz - R 1-4 -3 L -2.5 U 6-9 2-0 0-4 123 7.5 9
Sep 12, 2018 box Wed home Giants Derek Holland - L Braves Anibal Sanchez - R 1-2 -1 L -4.5 U 7-8 0-1 1-1 125 7.5 9
Sep 14, 2018 box Fri home Giants Chris Stratton - R Rockies Tyler Anderson - L 2-0 2 W -5.5 U 8-2 0-0 2-0 110 7.5 9
Sep 15, 2018 box Sat home Giants Madison Bumgarner - L Rockies German Marquez - R 3-0 3 W -4.0 U 8-7 1-0 3-0 125 7.0 9
Sep 16, 2018 box Sun home Giants Dereck Rodriguez - R Rockies Antonio Senzatela - R 2-3 -1 L -2.5 U 7-7 1-0 0-3 110 7.5 9
Sep 24, 2018 box Mon home Giants Derek Holland - L Padres Bryan Mitchell - R 0-5 -5 L -2.5 U 7-12 1-0 0-5 -130 7.5 9
Sep 25, 2018 box Tue home Giants Chris Stratton - R Padres Robbie Erlin - L 5-4 1 W 2.0 O 9-12 2-3 1-2 -120 7.0 10+
Sep 26, 2018 box Wed home Giants Casey Kelly - R Padres Luis Perdomo - R 2-3 -1 L -3.0 U 5-8 1-0 0-3 -106 8.0 9
Sep 28, 2018 box Fri home Giants Madison Bumgarner - L Dodgers Hyun Jin Ryu - L 1-3 -2 L -3.0 U 6-9 1-1 1-2 170 7.0 9
Sep 29, 2018 box Sat home Giants Dereck Rodriguez - R Dodgers Clayton Kershaw - L 6-10 -4 L 9.0 O 9-18 1-0 1-5 240 7.0 9
Sep 30, 2018 box Sun home Giants Andrew Suarez - L Dodgers Rich Hill - L 0-15 -15 L 7.5 O 2-16 0-0 0-15 210 7.5 9
Apr 05, 2019 box Fri home Giants Dereck Rodriguez - R Rays Tyler Glasnow - R 2-5 -3 L 0.0 P 8-11 1-2 0-5 115 7.0 9
Apr 06, 2019 box Sat home Giants Jeff Samardzija - R Rays Ryne Stanek - R 6-4 2 W 2.5 O 8-9 0-1 3-1 117 7.5 9
Apr 07, 2019 box Sun home Giants Drew Pomeranz - L Rays Yonny Chirinos - R 0-3 -3 L -4.5 U 5-10 0-0 0-3 103 7.5 9
Apr 08, 2019 box Mon home Giants Madison Bumgarner - L Padres Eric Lauer - L 5-6 -1 L 4.0 O 5-7 0-2 5-1 -125 7.0 9
Apr 09, 2019 box Tue home Giants Derek Holland - L Padres Joey Lucchesi - L 7-2 5 W 1.5 O 7-7 0-0 7-0 110 7.5 9
Apr 10, 2019 box Wed home Giants Dereck Rodriguez - R Padres Nick Margevicius - L 1-3 -2 L -4.0 U 7-6 1-0 0-2 100 8.0 9
Apr 11, 2019 box Thu home Giants Jeff Samardzija - R Rockies Jon Gray - R 1-0 1 W -6.0 U 6-3 0-0 1-0 100 7.0 9
Apr 12, 2019 box Fri home Giants Drew Pomeranz - L Rockies Chad Bettis - R 3-2 1 W -3.0 U 8-11 2-0 1-2 -140 8.0 10+
Apr 13, 2019 box Sat home Giants Madison Bumgarner - L Rockies Kyle Freeland - L 5-2 3 W 0.0 P 11-6 1-0 3-0 -120 7.0 9
Apr 14, 2019 box Sun home Giants Derek Holland - L Rockies German Marquez - R 0-4 -4 L -3.0 U 1-5 1-0 0-4 -103 7.0 9
Apr 26, 2019 box Fri home Giants Madison Bumgarner - L Yankees James Paxton - L 3-7 -4 L 3.5 O 5-15 2-0 0-4 110 6.5 9
Apr 27, 2019 box Sat home Giants Derek Holland - L Yankees JA Happ - L 4-6 -2 L 2.5 O 9-8 0-0 0-6 -105 7.5 9
Apr 28, 2019 box Sun home Giants Dereck Rodriguez - R Yankees Domingo German - R 5-11 -6 L 8.5 O 6-14 2-1 0-8 115 7.5 9
Apr 29, 2019 box Mon home Giants Jeff Samardzija - R Dodgers Kenta Maeda - R 3-2 1 W -2.5 U 11-9 0-0 1-2 137 7.5 9
Apr 30, 2019 box Tue home Giants Drew Pomeranz - L Dodgers Walker Buehler - R 3-10 -7 L 5.5 O 6-10 0-0 1-8 140 7.5 9
May 01, 2019 box Wed home Giants Madison Bumgarner - L Dodgers Hyun Jin Ryu - L 2-1 1 W -4.0 U 7-6 2-0 1-0 130 7.0 9
May 10, 2019 box Fri home Giants Dereck Rodriguez - R Reds Luis Castillo - R 0-7 -7 L -0.5 U 4-9 2-0 0-7 140 7.5 9
May 11, 2019 box Sat home Giants Jeff Samardzija - R Reds Anthony DeSclafani - R 4-5 -1 L 1.5 O 9-10 0-1 1-3 120 7.5 9
May 12, 2019 box Sun home Giants Madison Bumgarner - L Reds Tyler Mahle - R 6-5 1 W 4.0 O 10-11 2-0 1-2 -120 7.0 9
May 14, 2019 box Tue home Giants Nick Vincent - R Blue Jays Trent Thornton - R 3-7 -4 L 2.0 O 5-10 1-0 0-5 -106 8.0 9
May 15, 2019 box Wed home Giants Shaun Anderson - R Blue Jays Edwin Jackson - R 4-3 1 W -0.5 U 8-5 3-1 2-1 -144 7.5 9
May 20, 2019 box Mon home Giants Andrew Suarez - L Braves Mike Soroka - R 1-4 -3 L -2.5 U 2-6 1-1 0-3 135 7.5 9
May 21, 2019 box Tue home Giants Shaun Anderson - R Braves Julio Teheran - R 4-3 1 W -0.5 U 9-11 0-1 1-2 -103 7.5 9
May 22, 2019 box Wed home Giants Jeff Samardzija - R Braves Max Fried - L 2-9 -7 L 3.5 O 6-7 1-0 0-7 145 7.5 9
May 23, 2019 box Thu home Giants Madison Bumgarner - L Braves Kevin Gausman - R 4-5 -1 L 1.5 O 7-11 0-0 2-1 105 7.5 10+
May 24, 2019 box Fri home Giants Drew Pomeranz - L Diamondbacks Robbie Ray - L 2-18 -16 L 12.5 O 7-21 1-0 1-16 125 7.5 9
May 25, 2019 box Sat home Giants Andrew Suarez - L Diamondbacks Taylor Clarke - R 4-10 -6 L 6.0 O 9-13 2-0 0-9 -115 8.0 9
May 26, 2019 box Sun home Giants Shaun Anderson - R Diamondbacks Luke Weaver - R 2-6 -4 L 0.5 O 10-10 2-0 0-5 110 7.5 9
Jun 07, 2019 box Fri home Giants Drew Pomeranz - L Dodgers Clayton Kershaw - L 2-1 1 W -4.5 U 7-6 0-0 2-0 200 7.5 9
Jun 08, 2019 box Sat home Giants Jeff Samardzija - R Dodgers Rich Hill - L 2-7 -5 L 1.0 O 8-11 1-0 1-5 210 8.0 9
Jun 09, 2019 box Sun home Giants Madison Bumgarner - L Dodgers Walker Buehler - R 0-1 -1 L -6.5 U 5-5 1-0 0-1 145 7.5 9
Jun 11, 2019 box Tue home Giants Tyler Beede - R Padres Chris Paddack - R 6-5 1 W 3.5 O 9-7 0-1 2-1 140 7.5 9
Jun 12, 2019 box Wed home Giants Shaun Anderson - R Padres Joey Lucchesi - L 4-2 2 W -1.5 U 8-5 1-3 2-1 120 7.5 9
Jun 14, 2019 box Fri home Giants Drew Pomeranz - L Brewers Zach Davies - R 5-3 2 W -0.5 U 10-8 1-1 3-1 130 8.5 9
Jun 15, 2019 box Sat home Giants Madison Bumgarner - L Brewers Jimmy Nelson - R 8-7 1 W 7.0 O 15-8 1-1 2-4 -107 8.0 9
Jun 16, 2019 box Sun home Giants Jeff Samardzija - R Brewers Chase Anderson - R 3-5 -2 L -0.5 U 7-12 0-0 0-2 145 8.5 9
Jun 24, 2019 box Mon home Giants Drew Pomeranz - L Rockies Jon Gray - R 0-2 -2 L -5.5 U 6-5 1-0 0-2 115 7.5 9
Jun 25, 2019 box Tue home Giants Madison Bumgarner - L Rockies Chi Chi Gonzalez - R 4-2 2 W -1.5 U 8-3 0-1 2-0 -155 7.5 9
Jun 26, 2019 box Wed home Giants Jeff Samardzija - R Rockies German Marquez - R 3-6 -3 L 1.5 O 8-7 1-1 2-3 130 7.5 9
Jun 27, 2019 box Thu home Giants Tyler Beede - R Diamondbacks Alex Young - L 1-5 -4 L -2.5 U 3-8 0-0 0-4 -105 8.5 9
Jun 28, 2019 box Fri home Giants Shaun Anderson - R Diamondbacks Merrill Kelly - R 6-3 3 W 1.0 O 12-11 0-1 4-0 -104 8.0 9
Jun 29, 2019 box Sat home Giants Drew Pomeranz - L Diamondbacks Zack Greinke - R 3-4 -1 L -0.5 U 7-11 2-1 0-4 145 7.5 9
Jun 30, 2019 box Sun home Giants Madison Bumgarner - L Diamondbacks Robbie Ray - L 10-4 6 W 6.5 O 13-8 0-1 9-0 100 7.5 9
Jul 05, 2019 box Fri home Giants Drew Pomeranz - L Cardinals Dakota Hudson - R 4-9 -5 L 4.5 O 7-14 0-0 0-6 -105 8.5 9
Jul 06, 2019 box Sat home Giants Madison Bumgarner - L Cardinals Miles Mikolas - R 8-4 4 W 4.0 O 11-10 1-1 7-1 -122 8.0 9
Jul 07, 2019 box Sun home Giants Jeff Samardzija - R Cardinals Jack Flaherty - R 1-0 1 W -7.0 U 2-6 0-0 1-0 110 8.0 9
Jul 18, 2019 box Thu home Giants Madison Bumgarner - L Mets Noah Syndergaard - R 3-2 1 W -2.0 U 14-11 0-0 1-1 -120 7.0 10+
Jul 19, 2019 box Fri home Giants Tyler Beede - R Mets Jacob deGrom - R 1-0 1 W -6.5 U 3-3 0-1 1-0 160 7.5 10+
Jul 20, 2019 box Sat home Giants Jeff Samardzija - R Mets Walker Lockett - R 4-11 -7 L 6.0 O 9-17 0-0 0-10 -125 9.0 9
Jul 21, 2019 box Sun home Giants Connor Menez - L Mets Steven Matz - L 3-2 1 W -3.5 U 7-5 0-1 1-2 -120 8.5 10+
Jul 22, 2019 box Mon home Giants Shaun Anderson - R Cubs Alec Mills - R 5-4 1 W 0.5 O 13-6 0-0 1-3 102 8.5 9
Jul 23, 2019 box Tue home Giants Madison Bumgarner - L Cubs Yu Darvish - R 5-4 1 W 1.5 O 8-9 1-0 2-1 -105 7.5 10+
Jul 24, 2019 box Wed home Giants Tyler Beede - R Cubs Tyler Chatwood - R 1-4 -3 L -4.0 U 7-11 1-0 0-3 105 9.0 9
Aug 05, 2019 box Mon home Giants Jeff Samardzija - R Nationals Erick Fedde - R 0-4 -4 L -4.5 U 7-6 0-0 0-4 -120 8.5 9
Aug 06, 2019 box Tue home Giants Conner Menez - L Nationals Anibal Sanchez - R 3-5 -2 L -0.5 U 8-8 1-1 0-4 107 8.5 9
Aug 07, 2019 box Wed home Giants Shaun Anderson - R Nationals Joe Ross - R 1-4 -3 L -4.0 U 6-9 0-0 0-4 104 9.0 9
Aug 08, 2019 box Thu home Giants Madison Bumgarner - L Phillies Aaron Nola - R 5-0 5 W -2.5 U 10-1 0-1 5-0 -103 7.5 9
Aug 09, 2019 box Fri home Giants Tyler Beede - R Phillies Drew Smyly - L 6-9 -3 L 6.5 O 11-10 1-1 1-3 112 8.5 9
Aug 10, 2019 box Sat home Giants Jeff Samardzija - R Phillies Vince Velasquez - R 3-1 2 W -4.5 U 5-3 0-1 2-1 -107 8.5 9
Aug 11, 2019 box Sun home Giants Conner Menez - L Phillies Jake Arrieta - R 9-6 3 W 6.0 O 12-10 0-0 3-3 -104 9.0 9
Aug 13, 2019 box Tue home Giants Madison Bumgarner - L Athletics Brett Anderson - L 3-2 1 W -3.0 U 6-5 0-1 2-1 -120 8.0 9
Aug 14, 2019 box Wed home Giants Tyler Beede - R Athletics Homer Bailey - R 5-9 -4 L 5.0 O 7-15 0-0 0-7 110 9.0 9
Aug 26, 2019 box Mon home Giants Tyler Beede - R Diamondbacks Alex Young - L 4-6 -2 L 1.5 O 9-11 1-3 1-4 -104 8.5 9
Aug 27, 2019 box Tue home Giants Jeff Samardzija - R Diamondbacks Mike Leake - R 2-3 -1 L -3.0 U 5-7 0-1 1-2 -140 8.0 9
Aug 29, 2019 box Thu home Giants Dereck Rodriguez - R Padres Chris Paddack - R 3-5 -2 L 0.0 P 8-8 0-0 0-5 117 8.0 9
Aug 30, 2019 box Fri home Giants Madison Bumgarner - L Padres Dinelson Lamet - R 8-3 5 W 3.5 O 13-7 0-1 6-0 -130 7.5 9
Aug 31, 2019 box Sat home Giants Logan Webb - R Padres Joey Lucchesi - L 1-4 -3 L -3.0 U 9-11 0-0 1-3 106 8.0 9
Sep 01, 2019 box Sun home Giants Jeff Samardzija - R Padres Eric Lauer - L 4-8 -4 L 3.0 O 7-13 0-0 0-5 -110 9.0 9
Sep 09, 2019 box Mon home Giants Madison Bumgarner - L Pirates Trevor Williams - R 4-6 -2 L 2.5 O 9-10 1-0 2-2 -160 7.5 9
Sep 10, 2019 box Tue home Giants Johnny Cueto - R Pirates Mitch Keller - R 5-4 1 W 0.5 O 9-7 0-1 5-0 -125 8.5 9
Sep 11, 2019 box Wed home Giants Logan Webb - R Pirates Dario Agrazal - R 3-6 -3 L 0.0 P 3-9 2-2 0-4 -145 9.0 9
Sep 12, 2019 box Thu home Giants Jeff Samardzija - R Pirates Joe Musgrove - R 2-4 -2 L -2.5 U 8-8 0-0 0-3 -113 8.5 9
Sep 13, 2019 box Fri home Giants Tyler Beede - R Marlins Sandy Alcantara - R 1-0 1 W -7.5 U 9-4 0-0 1-0 -142 8.5 9
Sep 14, 2019 box Sat home Giants Madison Bumgarner - L Marlins Robert Dugger - R 2-4 -2 L -2.0 U 8-7 1-0 0-2 -220 8.0 9
Sep 15, 2019 box Sun home Giants Johnny Cueto - R Marlins Elieser Hernandez - R 2-1 1 W -5.0 U 7-5 1-1 1-0 -175 8.0 9
Sep 24, 2019 box Tue home Giants Madison Bumgarner - L Rockies Jeff Hoffman - R 5-8 -3 L 5.0 O 8-12 1-1 2-3 -170 8.0 10+
Sep 25, 2019 box Wed home Giants Jeff Samardzija - R Rockies Tim Melville - R 2-1 1 W -6.0 U 7-8 2-0 1-0 -160 9.0 9
Sep 26, 2019 box Thu home Giants Tyler Beede - R Rockies Kyle Freeland - L 8-3 5 W 2.5 O 12-8 1-1 5-0 -122 8.5 9
Sep 27, 2019 box Fri home Giants Johnny Cueto - R Dodgers Walker Buehler - R 2-9 -7 L 3.5 O 8-9 0-2 0-7 180 7.5 9
Sep 28, 2019 box Sat home Giants Logan Webb - R Dodgers Hyun Jin Ryu - L 0-2 -2 L -6.5 U 7-7 0-0 0-2 190 8.5 9
Sep 29, 2019 box Sun home Giants Dereck Rodriguez - R Dodgers Rich Hill - L 0-9 -9 L 0.5 O 3-12 0-0 0-9 160 8.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).