'League'='League' and site=home and o:team= 'TLS' and 20061104<=date
SU: 11-11-0 (-0.8) ATS: 15-7-0 (6.6) avg line: 7.4 O/U: 11-11-0 (2.5) avg total: 65.3
Date Day # Season Team Opp Site Final Rest Line Total SUm ATSm SUr ATSr OUr Conf Type Conf. OT Nov 04, 2006 SAT 10 2006 HOU TLS H 27-10 6 +3' 55 17 +20' W W U 1 RS USA 0 Nov 18, 2006 SAT 11 2006 SMU TLS H 34-24 6 +6 51' 10 +16 W W O 1 RS USA 0 Aug 30, 2007 THU 1 2007 LMON TLS H 17-35 +4' 50 -18 -13' L L O 0 RS SBC 0 Oct 06, 2007 SAT 6 2007 UTEP TLS H 48-47 6 +3 72 1 +4 W W O 1 RS USA 0 Oct 20, 2007 SAT 7 2007 CFL TLS H 44-23 6 -3 72' 21 +18 W W U 1 RS USA 0 Nov 03, 2007 SAT 9 2007 TLN TLS H 25-49 6 +6' 68 -24 -17' L L O 1 RS USA 0 Nov 17, 2007 SAT 11 2007 ARMY TLS H 39-49 7 +15 63' -10 +5 L W O 0 RS IND 0 Nov 24, 2007 SAT 12 2007 RICE TLS H 43-48 6 +12 81 -5 +7 L W O 1 RS USA 0 Dec 01, 2007 SAT 13 2007 CFL TLS H 44-25 6 -7' 74' 19 +11' W W U 1 CH USA 0 Aug 30, 2008 SAT 1 2008 UAB TLS H 22-45 +14 68 -23 -9 L L U 1 RS USA 0 Sep 06, 2008 SAT 2 2008 NTX TLS H 26-56 6 +22 67 -30 -8 L L O 0 RS SBC 0 Oct 11, 2008 SAT 7 2008 SMU TLS H 31-37 6 +24' 78' -6 +18' L W U 1 RS USA 0 Nov 01, 2008 SAT 9 2008 ARK TLS H 30-23 6 +7' 76' 7 +14' W W U 0 RS SEC 0 Nov 15, 2008 SAT 10 2008 HOU TLS H 70-30 6 +4 80' 40 +44 W W O 1 RS USA 0 Nov 29, 2008 SAT 12 2008 MRSH TLS H 35-38 6 +15' 64' -3 +12' L W O 1 RS USA 0 Sep 04, 2009 FRI 1 2009 TLN TLS H 13-37 +14 62' -24 -10 L L U 1 RS USA 0 Sep 12, 2009 SAT 2 2009 NMX TLS H 10-44 6 +16' 57 -34 -17' L L U 0 RS MWC 0 Date Day # Season Team Opp Site Final Rest Line Total SUm ATSm SUr ATSr OUr Conf Type Conf. OT Sep 19, 2009 SAT 3 2009 OKLA TLS H 45-0 6 -17' 57' 45 +27' W W U 0 RS B12 0 Oct 03, 2009 SAT 5 2009 RICE TLS H 10-27 6 +16 63 -17 -1 L L U 1 RS USA 0 Oct 21, 2009 WED 7 2009 UTEP TLS H 28-24 10 +7' 59' 4 +11' W W U 1 RS USA 0 Nov 21, 2009 SAT 11 2009 SMIS TLS H 44-34 6 -8' 54' 10 +1' W W O 1 RS USA 0 Sep 05, 2010 SUN 1 2010 ECAR TLS H 51-49 +7 59 2 +9 W W O 1 RS USA 0 Sep 18, 2010 SAT 3 2010 OKST TLS H 6 0 RS B12 0 Oct 02, 2010 SAT 5 2010 MEM TLS H 6 1 RS USA 0 Oct 09, 2010 SAT 6 2010 SMU TLS H 6 1 RS USA 0 Oct 30, 2010 SAT 9 2010 NOTD TLS H 6 0 RS IND 0 Nov 13, 2010 SAT 10 2010 HOU TLS H 7 -10 1 RS USA 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.