Winning Picks, Guaranteed

featuring the Sports Data Query Language
Create New Account
--- or ---
username
password
forgot password?
   Home  |  Trend Mart   ||   NFL  |  NBA  |  WNBA  |  MLB  |  NHL  |  CFL  |  NCAA FB  |  NCAA BB   ||   MLB: Home | Tables | Trends | Query Matrix | SDQL Query  

MLB SDQL Query Access - In Testing Your query timeout is 15 seconds.

Content will appear here


team = Pirates and A and P:HL
SU: 78-103 (-0.72, 43.1%)   avg line: 111.5 / -133.6   on / against: -$240 / -$630   ROI(test): -1.3% / -2.2%
RL: 84-68-0 (0.36, 55.3%)   avg line(test): -83.8 / 56.0   on / against(test): -$24 / -$876   ROI(test): -0.1% / -5.2%
O/U: 86-84-11 (0.85, 50.6%)   avg total: 8.4   over / under(test): -$526 / -$811   ROI(test): -2.6% / -4.1%
Runs Walks SO Hits XBH HR SII MRI IL LOB TLOB ODP SRA PU
Team 4.26 2.99 8.08 8.50 2.64 0.90 2.36 1.12 3.24 14.60 6.86 1.01 2.96 4.05
Opp 4.98 3.39 7.35 9.07 2.96 1.11 2.60 1.23 4.22 14.74 7.11 0.94 2.46 4.20
Date Link Day Season Site Team Starter Opp Starter Final SUm W/L OUm O/U Hits Errors BL Line Total Innings
Jul 24, 2017 recap Mon 2017 away Pirates Gerrit Cole-R Giants Matt Cain-R 10-3 7 W 5.0 O 14-9 0-1 7-0 -155.0 8.0 9
Aug 11, 2017 recap Fri 2017 away Pirates Jameson Taillon-R Blue Jays Marcus Stroman-R 4-2 2 W -2.5 U 4-8 0-2 3-1 125.0 8.5 9
Apr 10, 2018 recap Tue 2018 away Pirates Ivan Nova-R Cubs Tyler Chatwood-R 8-5 3 W 4.0 O 12-10 1-0 6-1 140.0 9.0 9
May 31, 2018 recap Thu 2018 away Pirates Trevor Williams-R Cardinals Jack Flaherty-R 8-10 -2 L 9.5 O 12-14 1-3 3-4 140.0 8.5 9
Jun 11, 2018 recap Mon 2018 away Pirates Joe Musgrove-R Diamondbacks Patrick Corbin-L 5-9 -4 L 6.0 O 8-9 1-1 5-4 145.0 8.0 9
Jun 29, 2018 recap Fri 2018 away Pirates Joe Musgrove-R Padres Eric Lauer-L 6-3 3 W 1.5 O 11-12 0-2 6-0 -105.0 7.5 9
Jul 02, 2018 recap Mon 2018 away Pirates Nick Kingham-R Dodgers Alex Wood-L 1-17 -16 L 10.5 O 9-21 3-1 0-16 200.0 7.5 9
Jul 20, 2018 recap Fri 2018 away Pirates Jameson Taillon-R Reds Tyler Mahle-R 12-1 11 W 4.0 O 16-9 0-2 11-0 -105.0 9.0 9
Aug 09, 2018 recap Thu 2018 away Pirates Ivan Nova-R Giants Andrew Suarez-L 10-5 5 W 7.0 O 13-6 1-3 8-0 125.0 8.0 9
Aug 14, 2018 recap Tue 2018 away Pirates Jameson Taillon-R Twins Jake Odorizzi-R 2-5 -3 L -1.5 U 7-10 0-0 2-3 -121.0 8.5 9
Aug 28, 2018 recap Tue 2018 away Pirates Ivan Nova-R Cardinals Jack Flaherty-R 2-5 -3 L -1.0 U 6-10 0-0 0-4 155.0 8.0 9
Aug 31, 2018 recap Fri 2018 away Pirates Jameson Taillon-R Braves Anibal Sanchez-R 3-2 1 W -3.0 U 7-7 0-2 2-0 110.0 8.0 9
May 09, 2019 recap Thu 2019 away Pirates Joe Musgrove-R Cardinals Michael Wacha-R 4-17 -13 L 12.5 O 10-16 1-0 1-13 135.0 8.5 9
May 13, 2019 recap Mon 2019 away Pirates Nick Kingham-R Diamondbacks Robbie Ray-L 3-9 -6 L 3.0 O 13-13 0-1 2-7 165.0 9.0 9
Jun 07, 2019 recap Fri 2019 away Pirates Rookie Davis-R Brewers Brandon Woodruff-R 4-10 -6 L 4.5 O 7-14 1-0 0-7 220.0 9.5 9
Jun 25, 2019 recap Tue 2019 away Pirates Trevor Williams-R Astros Gerrit Cole-R 1-5 -4 L -2.5 U 8-10 1-0 0-4 250.0 8.5 9
Jul 12, 2019 recap Fri 2019 away Pirates Chris Archer-R Cubs Yu Darvish-R 3-4 -1 L -2.5 U 5-6 0-0 0-3 155.0 9.5 9
Jul 26, 2019 recap Fri 2019 away Pirates Dario Agrazal-R Mets Zack Wheeler-R 3-6 -3 L -0.5 U 8-6 0-2 1-3 160.0 9.5 9
Aug 09, 2019 recap Fri 2019 away Pirates Chris Archer-R Cardinals Dakota Hudson-R 2-6 -4 L -1.0 U 7-10 1-0 1-4 135.0 9.0 9
Aug 12, 2019 recap Mon 2019 away Pirates Mitch Keller-R Angels Jose Suarez-L 10-2 8 W 2.0 O 13-9 1-3 8-0 135.0 10.0 9
Aug 26, 2019 recap Mon 2019 away Pirates Joe Musgrove-R Phillies Jason Vargas-L 5-6 -1 L 2.0 O 13-11 0-0 2-2 127.0 9.0 10
Sep 09, 2019 recap Mon 2019 away Pirates Trevor Williams-R Giants Madison Bumgarner-L 6-4 2 W 2.5 O 10-9 0-1 2-2 150.0 7.5 9
Sep 13, 2019 recap Fri 2019 away Pirates Steven Brault-L Cubs Jon Lester-L 8-17 -9 L 14.0 O 13-16 0-3 4-10 165.0 11.0 9
Sep 20, 2019 recap Fri 2019 away Pirates Steven Brault-L Brewers Chase Anderson-R 1-10 -9 L 1.5 O 6-10 1-2 0-9 190.0 9.5 9
Jul 24, 2020 recap Fri 2020 away Pirates Joe Musgrove-R Cardinals Jack Flaherty-R 4-5 -1 L 1.0 O 8-9 1-1 0-3 160.0 8.0 9
Aug 13, 2020 recap Thu 2020 away Pirates Trevor Williams-R Reds Anthony DeSclafani-R 9-6 3 W 6.0 O 11-12 0-0 9-0 155.0 9.0 9
Sep 04, 2020 recap Fri 2020 away Pirates Cody Ponce-R Reds Trevor Bauer-R 4-3 1 W 1.0 O 6-4 0-1 1-2 180.0 6.0 7
Sep 18, 2020 recap Fri 2020 away Pirates Chad Kuhl-R Cardinals Daniel Ponce de Leon-R 2-7 -5 L 2.0 O 4-6 3-0 1-5 160.0 7.0 7
Sep 25, 2020 recap Fri 2020 away Pirates Mitch Keller-R Guardians Carlos Carrasco-R 3-4 -1 L -1.0 U 6-4 0-0 2-1 220.0 8.0 9
Apr 21, 2021 recap Wed 2021 away Pirates Tyler Anderson-L Tigers Michael Fulmer-R 3-2 1 W -0.5 U 7-3 0-0 2-1 115.0 5.5 7
May 03, 2021 recap Mon 2021 away Pirates Tyler Anderson-L Padres Miguel Diaz-R 0-2 -2 L -6.0 U 4-3 1-1 0-2 167.0 8.0 9
May 18, 2021 recap Tue 2021 away Pirates JT Brubaker-R Cardinals John Gant-R 2-5 -3 L -0.5 U 6-11 0-0 0-5 120.0 7.5 9
May 31, 2021 recap Mon 2021 away Pirates Chad Kuhl-R Royals Mike Minor-L 3-7 -4 L 2.0 O 6-13 2-0 1-4 175.0 8.0 9
Jun 14, 2021 recap Mon 2021 away Pirates JT Brubaker-R Nationals Jon Lester-L 2-3 -1 L -3.0 U 7-6 1-0 1-1 115.0 8.0 9
Jun 28, 2021 recap Mon 2021 away Pirates Tyler Anderson-L Rockies Kyle Freeland-L 0-2 -2 L -9.0 U 6-5 1-1 0-2 109.0 11.0 9
Jul 09, 2021 recap Fri 2021 away Pirates JT Brubaker-R Mets Taijuan Walker-R 4-13 -9 L 9.0 O 9-10 0-0 1-10 180.0 8.0 9
Jul 23, 2021 recap Fri 2021 away Pirates Chad Kuhl-R Giants Johnny Cueto-R 6-4 2 W 1.5 O 4-8 0-1 3-0 162.0 8.5 9
Aug 02, 2021 recap Mon 2021 away Pirates Bryse Wilson-R Brewers Eric Lauer-L 2-6 -4 L -1.0 U 6-6 0-0 0-6 185.0 9.0 9
Aug 05, 2021 recap Thu 2021 away Pirates Wil Crowe-R Reds Sonny Gray-R 4-7 -3 L 1.5 O 8-9 1-0 0-7 200.0 9.5 9
Aug 16, 2021 recap Mon 2021 away Pirates Steven Brault-L Dodgers Justin Bruihl-L 1-2 -1 L -6.0 U 5-5 0-1 1-1 230.0 9.0 9
Aug 20, 2021 recap Fri 2021 away Pirates Mitch Keller-R Cardinals Miles Mikolas-R 4-0 4 W -4.5 U 4-10 0-1 4-0 180.0 8.5 9
Aug 31, 2021 recap Tue 2021 away Pirates Bryse Wilson-R White Sox Lucas Giolito-R 2-4 -2 L -3.0 U 5-6 1-1 0-2 250.0 9.0 9
Sep 02, 2021 recap Thu 2021 away Pirates Mitch Keller-R Cubs Keegan Thompson-R 5-6 -1 L 3.0 O 7-13 1-2 3-2 118.0 8.0 11
Sep 17, 2021 recap Fri 2021 away Pirates Wil Crowe-R Marlins Elieser Hernandez-R 2-1 1 W -4.5 U 7-5 0-0 1-0 140.0 7.5 9
Sep 20, 2021 recap Mon 2021 away Pirates Dillon Peters-L Reds Vladimir Gutierrez-R 5-9 -4 L 4.5 O 8-11 0-0 5-4 141.0 9.5 9
Sep 23, 2021 recap Thu 2021 away Pirates Connor Overton-R Phillies Aaron Nola-R 6-12 -6 L 10.0 O 6-11 0-0 6-6 240.0 8.0 9
Apr 18, 2022 recap Mon 2022 away Pirates Zach Thompson-R Brewers Eric Lauer-L 1-6 -5 L -1.5 U 8-6 0-0 0-5 160.0 8.5 9
May 04, 2022 recap Wed 2022 away Pirates Dillon Peters-L Tigers Michael Pineda-R 2-3 -1 L -3.0 U 5-3 3-0 2-1 143.0 8.0 9
May 07, 2022 recap Sat 2022 away Pirates JT Brubaker-R Reds Connor Overton-R 2-9 -7 L 2.5 O 8-8 3-0 0-7 -120.0 8.5 9
May 27, 2022 recap Fri 2022 away Pirates Jose Quintana-L Padres Joe Musgrove-R

Game Parameters: after all star break, at bats, attendance, bad start, biggest lead, bullpen runs allowed, date, day, division, double header, double plays, doubles, dpa, dps, earned runs, errors, extra base hits, extra innings, game number, hit batters, hit by pitchers, hits, home runs, inning runs, innings, innings led, innings tied, league, left on base, line, location, losses, margin, matchup losses, matchup wins, month, multiple run innings, opponent, opponents, ou margin, ou streak, over, over_invest, over_profit, pitchers used, playoffs, profit, quality start, rest, rl margin, rl streak, rl_invest, rl_profit, round, run line, run line runs, runs, scored first, scored in innings, season, seed, series game, series games, series losses, series wins, site, site streak, start time, starter, starter balls, starter batters faced, starter earned run average, starter hits, starter homeruns, starter innings pitched, starter losses, starter matchup losses, starter matchup wins, starter pitches thrown, starter rest, starter runs allowed, starter strikeouts, starter strikes thrown, starter throws, starter walks, starter wins, streak, strike outs, su_invest, su_profit, team, team left on base, team strikes thrown, temperature, time zone, times tied, total, triples, umpires, under, under_invest, under_profit, walks, wins


How to Query:

The syntax for access to the MLB team data is: game reference:parameter. To see the date, team, and opponent where the team scored +120 points after scoring +120 runs in the previous game use the SDQL: date,team,o:team@points>120 and p:points>120

The syntax for access to the MLB player data: [team:]player name:game reference:parameter. To see the date, team, opponent and number of points by Kobe Bryant in the game after he scored more than 30 use the SDQL: date,team,o:team,Kobe Bryant:points@Kobe Bryant:p:points>30
How to use the Baseball query page:

Use this page to type in queries to check the records and net profits of any situation. Profits are calculated based on risking the line to win $100 when playing on favorites and risking $100 to win the line when playing on dogs.

A query consists of one or more clauses joined by and or or.
The full format for reference to the MLB SportsDataBase is game reference:parameter.

Examples:

The query:
team and site=home
returns the home records for all teams

p:runs<=1 and 5<=po:runs
returns games after a team scored 1 or fewer runs while their opponent scored 5 or more runs.

p:runs
returns games grouped by all occurrences of the teams previous runs

p:runs<1,2,3,4,5
gives results grouped by previous runs fewer than 1,2,3,4, and 5.

Game Reference:

Use of the game reference lets you probe any game relative to the game for which you want to see stats. We saw this above with
p:runs<=1
meaning "How do teams do after scoring 1 or fewer runs?"
To reqire this same condition also on the team's run productions 2 games back use:
p:runs<=1 and pp:runs<=1

Allowed game references are:

t => team's stats
o => opponent's stats
p => team's previous game
op => opp's previous game
P => previous match up
n => team's next game
on => opp's next game
N => next match up
s => starter's previous start
S => starter's previous match up start

Examples:

The query:
site=home and P:runs=0 and PP:runs=0
returns home games where the team was shut out their two previous matchups. (Remember that 'P' refers to the previous matchup between the two teams while 'p' refers to the team's previous game.)

Examples:

The query:
o:walks=0 and team=Cubs
returns games where the Cubs' pitchers gave up no walks.

The query:
6<o:strike outs and team=Mets
returns games where the Mets' pitchers struck out more than 6 hitters.

Short Cuts:

Short cuts come in three flavors:

  • Single letter short cuts (e.g.: `H` means `site=home`)
  • Single letter plus number short cuts (e.g.: `R5` means 'runs scored in the fifth inning')
  • Multi-character short cuts (e.g.: `SO` means `strike outs`)

Single letter short cuts

Single letter short cuts are great because you can easily combine them and you only need to specify the prefix once. H, A, W, L, F, D, O, U, C, X are allowed short cuts for home,away,win,loss,favorite,dog,over the total,under the total, a same-conference game, and extra innings. As with the parameter prefixes, these can be strung together without limit.

Examples:

The query:
HF and p:HFL and pp:HFL
returns home favorites after they just lost as home favorites their last two games.

The query:
P:O and PP:O and PPP:O and PPPP:O and PPPPP:O and PPPPPP:O
returns games where teams have gone over the total their last six matchups.

The query:
HF and p:WADX
returns games where the team is a home favorite after winning as an away dog in extra innings.

Single letter plus number short cuts

The runs scored in each inning is saved as a list in the database under the header `inning runs`. The short cuts
   R1, R2,...R9 (runs in the specified inning)
   M1, M2,...M9 (the margin after the specified innings)
   S1, S2,...S9 (the score after the specified inning)
facilitate access to this parameter.

Examples:

The query:
p:M8<-4 and p:R9>5 and p:W
returns games after the team was down by +4 after 8, scored more than 5 in the 9th to win.

The query:
p:S3>10 and p:L
returns games after the team scored more than 10 runs in the first three innings and lost.

Multi-character short cuts

Multi-character short cuts save on typing and can make your SDQL more readable.

  • AASB - After All-Star Break
  • AWP - Away Winning Percentage
  • BASB - Before All-Star Break
  • BL - Biggest Lead
  • BPRA - Bull Pen Runs Allowed
  • BS - Bad Start (4 or fewer innings and 5 or more earned runs)
  • DAY - Day (start time<1800)
  • DDP - Defensive Double Plays
  • DIV - Divisional Game
  • FGS - First Game of a Series
  • HR - Home Runs
  • HPR - Hits Per Run
  • HPU - Home Plate Umpire
  • HWP - Home Winning Percentage
  • IL - Innings Led
  • IT - Innings Tied
  • LGS - Last Game of a Series
  • LOB - Left on Base
  • MRI - Multiple Run Innings
  • NDIV - Not a Divisional Game
  • NGT - Night (start time>=1800)
  • NQS - Non Quality Start
  • ODP - Offensive Double Plays (hit into double plays)
  • PBRS - Percent Base Runners Scored
  • PO - During the Playoffs
  • PU - Pitchers Used
  • QS - Quality Start (at least 6 innings and 3 or fewer earned runs)
  • REG - During the Regular Season
  • RG3 - Rubber Game 3 (3rd game of a 3 game series and they split the first 2)
  • RMAX - The maximum runs the team scored in any one inning
  • SERA - Starters' Earned Run Average in the Referenced Game
  • SF - Scored First: How many runs a team scored before their opponent scored
  • SG - Series Game
  • SGS - Series Games
  • SHA - Starter's Hits Allowed
  • SHF - Starter's Hitters Faced
  • SHRA - Starter's Home Runs Allowed
  • SII - Scored In Innings
  • SIP - Starter's Innings Pitched
  • SO - Strikeouts
  • SOPW - Strikeouts Per Walk
  • SPPH - Starter's Pitch Per Hitter
  • SPB - Strike Per Ball
  • SPT - Starter Pitches Thrown
  • SRA - Starter's Runs Allowed
  • SSO - Starter's Strike Outs
  • SSPB - Starter's Strike Per Ball
  • STDHPR - Season To Date Hits Per Run
  • STDSERA - Starter's Season To Date ERA
  • STDSOPW - Season To Date Stike Outs Per Walk
  • STDSSOPW - Starter's Season To Date Stike Outs Per Walk
  • STDSPB - Season To Date Stikes Per Ball
  • STDSSPB - Starter's Season To Date Stikes Per Ball
  • STDSWHIP - Starter's Season To Date WHIP
  • STR - Starter Throws Right
  • STL - Starter Throws Left
  • SWA - Starter's Walks Allowed
  • SWHIP - Starter's Walks Plus Hits Per Inning Pitched
  • TLOB - Team Left On Base
  • TT - Times Tied
  • WOW - Walk Off Win
  • WP - Winning Percentage
  • XBH - eXtra Base Hits (doubles + triples)


support@KillerSports.com   

The information available here is believed, but not guaranteed, to be accurate, is for recreational purposes only, and is not intended to violate any state, local, or federal laws.