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)