'League'='League' and site=home and line<0 and o:team= 'EMCH' and tp:site=home and tp:season=season and 19920919<=date
SU: 25-3-0 (25.4) ATS: 18-10-0 (4.8) avg line: -20.6 O/U: 5-4-0 (3.2) avg total: 51.6
Date Day # Season Team Opp Site Final Rest Line Total SUm ATSm SUr ATSr OUr Conf Type Conf. OT Sep 19, 1992 SAT 3 1992 PNST EMCH H 52-7 6 -35' 45 +9' W W O 0 RS IND 0 Sep 09, 1995 SAT 2 1995 PIT EMCH H 66-30 6 -20 36 +16 W W O 0 RS BE 0 Oct 14, 1995 SAT 6 1995 SYR EMCH H 52-24 6 -23 28 +5 W W O 0 RS BE 0 Oct 21, 1995 SAT 8 1995 BALL EMCH H 35-40 6 -7' -5 -12' L L O 1 RS MAC 0 Sep 28, 1996 SAT 4 1996 MCST EMCH H 47-0 6 -19 47 +28 W W O 0 RS B10 0 Oct 19, 1996 SAT 8 1996 CMCH EMCH H 41-36 6 -8' 5 -3' W L O 1 RS MAC 0 Sep 13, 1997 SAT 2 1997 TOL EMCH H 38-35 6 -7 3 -4 W L O 1 RS MAC 0 Sep 19, 1998 SAT 3 1998 MICH EMCH H 59-20 6 -35 39 +4 W W O 0 RS B10 0 Sep 11, 1999 SAT 2 1999 MCST EMCH H 51-7 8 -32 44 +12 W W O 0 RS B10 0 Oct 02, 1999 SAT 5 1999 LOU EMCH H 45-10 6 -23 35 +12 W W O 0 RS USA 0 Oct 30, 1999 SAT 8 1999 CFL EMCH H 31-6 6 -8 25 +17 W W O 0 RS IND 0 Sep 16, 2000 SAT 3 2000 SCAR EMCH H 41-6 6 -23 35 +12 W W O 0 RS SEC 0 Sep 23, 2000 SAT 4 2000 TEM EMCH H 49-40 6 -14' 9 -5' W L O 0 RS BE 0 Sep 08, 2001 SAT 2 2001 MARY EMCH H 50-3 6 -25 47 +22 W W O 0 RS ACC 0 Nov 17, 2001 SAT 9 2001 TOL EMCH H 28-7 10 -33 21 -12 W L O 1 RS MAC 0 Sep 21, 2002 SAT 4 2002 MARY EMCH H 45-3 6 -34' 42 +7' W W O 0 RS ACC 0 Oct 16, 2004 SAT 6 2004 WMCH EMCH H 31-35 6 -3' -4 -7' L L O 1 RS MAC 0 Sep 17, 2005 SAT 3 2005 MICH EMCH H 55-0 6 -30 55 +25 W W O 0 RS B10 0 Date Day # Season Team Opp Site Final Rest Line Total SUm ATSm SUr ATSr OUr Conf Type Conf. OT Oct 15, 2005 SAT 6 2005 NIL EMCH H 24-8 9 -21 16 -5 W L O 1 RS MAC 0 Sep 09, 2006 SAT 2 2006 MCST EMCH H 52-20 6 -25' 53 32 +6' W W O 0 RS B10 0 Sep 16, 2006 SAT 3 2006 NORW EMCH H 14-6 6 -17 52' 8 -9 W L U 0 RS B10 0 Sep 15, 2007 SAT 3 2007 NIL EMCH H 19-21 6 -13 43 -2 -15 L L U 1 RS MAC 0 Sep 29, 2007 SAT 4 2007 VAN EMCH H 30-7 13 -22' 46 23 +0' W W U 0 RS SEC 0 Nov 03, 2007 SAT 10 2007 TOL EMCH H 52-28 6 -8 63 24 +16 W W O 1 RS MAC 0 Sep 20, 2008 SAT 4 2008 MARY EMCH H 51-24 6 -21' 52 27 +5' W W O 0 RS ACC 0 Sep 12, 2009 SAT 2 2009 NORW EMCH H 27-24 6 -20' 52' 3 -17' W L U 0 RS B10 0 Sep 19, 2009 SAT 3 2009 MICH EMCH H 45-17 6 -23' 54' 28 +4' W W O 0 RS B10 0 Nov 05, 2009 THU 9 2009 NIL EMCH H 50-6 4 -21' 48 44 +22' W W O 1 RS MAC 0

Query Fundamentals: A query consists of one or more clauses joined by and or or. The full format for reference to the NCAA Football SportsDataBase is game reference:parameter. The simplest game reference is 'p' which stands for previous game. Also useful is 'o' which stands for opponent. You can combine any number of 'p's and 'o's. If a game reference is not given then the results for the current game are checked. See below for the current list of parameters and examples. Examples: The query: team and site=home returns the results of home games for each p:points<10 and pp:points<10 returns games after a team scored fewer than 10 points the past two games. If no game reference is given then results for the current game are checked. points<10 returns games in which teams scored fewer than 10 points. If no conditional is imposed then the results are grouped by the reference. p:points returns games grouped by all occurrences of previous points. Multiple conditions can be imposed using a comma delimited format. p:points<7,10,14 gives results grouped by previous points < 7, previous points < 10, and previous points < 14. Game Reference: 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:points<10 and PP:points<10 returns home games where team scored fewer than 10 point the past two head-to-head match ups Parameters: (point your mouse on a parameter for additional information) Prest, ats margin, conference, date, day, division, full name, game number, game type, line, losses, margin, opponents, ou margin, overtime, points, rest, season, site, team, total, wins Short Cuts H,A,W,L,F,D are allowed short cuts for home,away,win,loss,favorite, and dog. Examples: The query: p:WD and pp:WD and HF returns home favorites after they won their last two as dogs.