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: 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 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, biggest lead, box id, conference, date, day, division, double header, earned runs, errors, fly balls, ground balls, hits, hitters faced, home runs, inning runs, 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, runs, season, series game, series games, site, site streak, start time, starter, starter earned runs, starter era, 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, total, umpires, under, walks, wins Note that the parameters pitchers used, hitters faced, 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: H, A, W, L, F, D, O, U, X are allowed short cuts for home,away,win,loss,favorite,dog,over the total,under the total, and extra innings. As with the parameter prefixex, 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.