MLB SDQL Access

Enter your SDQL in the text box below and click the query button when finished.

---

site==home and line < -105 and p:site==home and p:line < -105 and p:points<po:points and pp:site==home and pp:line < -105 and pp:points<ppo:points
SU: 476-311 (0.8 rpg) average line: -162 / +147 on / against: -$1,060 / -$3,300 ROI: -0.8% / -4.2% O/U: 361-383-43 (0.4 rpg) average total: 9.0 over / under: -$6,110 / -$1,350 ROI: -7.0% / -1.6%
Runs Hits Errors Walks Strike Outs Grounders Fly Balls Team left on base Team: 5.1 9.2 0.55 3.5 6.0 10.0 9.3 7.1 Opp: 4.3 8.8 0.71 3.2 7.5 10.4 9.1 7.1
Recap Date Site Team Starter Opp Starter Score SUm W/L OUm O/U Hits Errors BL Line Total Innings view 08-12-2010 home Indians Gomez - R Orioles Millwood - R 4-1 3 W -4.0 U 11-6 0-1 3-0 -135 9.0 9 view 08-17-2010 home Cardinals Garcia - L Brewers Bush - R 2-3 -1 L -3.5 U 6-7 2-1 0-3 -185 8.5 9 view 08-18-2010 home Cardinals Wainwright - R Brewers Wolf - L 2-3 -1 L -2.5 U 4-7 0-2 0-3 -260 7.5 9 view 08-20-2010 home Cardinals Westbrook - R Giants Bumgarner - L 3-6 -3 L 1.0 O 13-13 0-0 0-5 -150 8.0 9 view 08-21-2010 home Cardinals Carpenter - R Giants Lincecum - R 5-1 4 W -1.0 U 8-8 0-1 4-0 -150 7.0 9 Recap Date Site Team Starter Opp Starter Score SUm W/L OUm O/U Hits Errors BL Line Total Innings view 08-21-2010 home Red Sox Matsuzaka - R Blue Jays Romero - L 5-4 1 W 0.5 O 10-7 2-2 3-0 -135 8.5 10+ view 08-25-2010 home Phillies Halladay - R Astros Happ - L 2-3 -1 L -2.0 U 7-6 0-0 0-1 -340 7.0 9 view 08-26-2010 home Phillies Kendrick - R Astros Rodriguez - L 1-5 -4 L -2.5 U 7-13 0-0 0-4 -165 8.5 9 view 08-27-2010 home Brewers Narveson - L Pirates McDonald - R 7-2 5 W 0.0 P 10-7 0-1 5-2 -160 9.0 9 view 08-27-2010 home Mets Pelfrey - R Astros Figueroa - R 2-1 1 W -4.5 U 3-9 1-1 2-0 -145 7.5 9 view 08-28-2010 home Giants Zito - L Diamondbacks Hudson - R 3-11 -8 L 6.5 O 4-8 2-1 0-8 -145 7.5 9 view 08-28-2010 home Padres Garland - R Phillies Blanton - R 1-3 -2 L -3.5 U 6-3 0-0 0-2 -130 7.5 9 view 08-29-2010 home Angels Weaver - R Orioles Guthrie - R 0-1 -1 L -6.5 U 4-5 1-0 0-1 -210 7.5 9 view 08-29-2010 home Giants Cain - R Diamondbacks Lopez - R 9-7 2 W 8.0 O 13-13 0-1 4-1 -230 8.0 9 view 09-03-2010 home Dodgers Billingsley - R Giants Zito - L 4-2 2 W -1.5 U 7-2 1-0 2-0 -135 7.5 9 Recap Date Site Team Starter Opp Starter Score SUm W/L OUm O/U Hits Errors BL Line Total Innings view 09-03-2010 home Mariners French - L Indians Carmona - R 1-0 1 W -6.0 U 4-3 0-0 1-0 -115 7.0 9 view 09-05-2010 home Padres Richard - L Rockies Rosa - L 2-4 -2 L -0.5 U 7-12 2-0 0-2 -130 6.5 9 view 09-05-2010 home Red Sox Beckett - R White Sox Buehrle - L 5-7 -2 L 3.0 O 11-13 2-1 2-2 -140 9.0 9 view 09-06-2010 home Padres Stauffer - R Dodgers Padilla - R 4-2 2 W -0.5 U 7-9 0-0 2-0 -125 6.5 9 view 09-06-2010 home Phillies Oswalt - R Marlins Sanchez - R 7-4 3 W 3.0 O 10-7 0-0 4-1 -180 8.0 9 view 09-06-2010 home Red Sox Lester - L Rays Niemann - R 12-5 7 W 8.5 O 9-8 0-0 9-1 -160 8.5 9 view 09-07-2010 home Yankees Sabathia - L Orioles Arrieta - R 2-6 -4 L -0.5 U 8-9 1-0 0-4 -380 8.5 9 view 09-08-2010 home Angels Kazmir - L Indians Tomlin - R 4-3 1 W -2.0 U 6-14 2-0 2-1 -145 9.0 10+ view 09-08-2010 home Yankees Nova - R Orioles Bergesen - R 3-2 1 W -5.0 U 7-6 1-0 1-1 -230 10.0 9 09-10-2010 home Nationals Lannan - L Marlins Sanabia - R -110 9.0

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.) Parameters: at bats, attendance, balls, biggest lead, conference, date, day, division, double header, earned runs, errors, fly balls, ground balls, hits, hitters faced, home runs, inning runs, innings led, innings tied, left on base, line, losses, margin, matchup losses, matchup wins, month, opponents, ou margin, ou streak, over, pitchers used, pitches, playoffs, points, rbi, rest, run line, run line runs, run line streak, runs, scored first, season, series game, series games, site, site streak, start time, starter, starter balls, starter earned runs, starter fly balls, starter ground balls, starter hits, starter hitters faced, starter home runs, starter innings pitched, starter losses, starter matchup losses, starter matchup wins, starter pitches, starter rest, starter runs, starter strike outs, starter strikes, starter throws, starter walks, starter whip, starter wins, starters previous game, starters previous match up, streak, strike outs, strikes, team, team left on base, temperature, time zone, times tied, total, umpires, under, walks, wins Note that the parameters pitchers used, hitters faced, balls, strikes, pitches, and starter [parameter] refer to the defensive team while all other parameters refer to the offensive team. 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. 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) DIV - Divisional game FGS - First Game of a Series HR - Home Runs HPR - Hits Per Run HPU - Home Plate Umpire IL - Innings Led IT - Innings Tied LGS - Last Game of a Series LOB - Left on Base NGT - Night (start time>=1800) PBRS - Percent Base Runners Scored PU - Pitchers Used QS - Quality Start (at least 6 innings and 3 or fewer earned runs) RMAX - The maximum runs the team scored in any one inning SERA - Starters' Earned Run Average in the Referenced Game SF - Scored First 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