'League'='League' and o:team= 'PIT' and tp:site=home and tp:season=season and 20061116<=date
SU: 11-12-0 (1.4) ATS: 14-7-2 (2.7) avg line: 1.3 O/U: 11-12-0 (3.3) avg total: 49.6
Date Day # Season Team Opp Site Final Rest Line Total SUm ATSm SUr ATSr OUr Conf Type Conf. OT Nov 16, 2006 THU 10 2006 WVA PIT A 45-17 4 -10' 54 28 +17' W W O 1 RS BE 0 Nov 25, 2006 SAT 11 2006 LOU PIT A 48-24 6 -11' 59 24 +12' W W O 1 RS BE 0 Sep 15, 2007 SAT 3 2007 MCST PIT H 17-13 6 -10 51' 4 -6 W L U 0 RS B10 0 Sep 22, 2007 SAT 4 2007 CON PIT A 34-14 6 +7' 44 20 +27' W W O 1 RS BE 0 Sep 29, 2007 SAT 5 2007 VIR PIT H 44-14 6 -6' 40 30 +23' W W O 0 RS ACC 0 Oct 10, 2007 WED 6 2007 NAVY PIT A 48-45 10 +4 52' 3 +7 W W O 0 RS IND 1 Oct 20, 2007 SAT 8 2007 CIN PIT A 17-24 6 -9' 50' -7 -16' L L U 1 RS BE 0 Nov 03, 2007 SAT 9 2007 SYR PIT A 17-20 13 +12' 47' -3 +9' L W U 1 RS BE 0 Nov 24, 2007 SAT 12 2007 SFL PIT A 48-37 6 -10' 48 11 +0' W W O 1 RS BE 0 Dec 01, 2007 SAT 12 2007 WVA PIT H 9-13 6 -28' 59 -4 -32' L L U 1 RS BE 0 Sep 06, 2008 SAT 2 2008 BUF PIT A 16-27 8 +13 45' -11 +2 L W U 0 RS MAC 0 Sep 20, 2008 SAT 4 2008 IOWA PIT A 20-21 6 +1 41' -1 0 L P U 0 RS B10 0 Sep 27, 2008 SAT 5 2008 SYR PIT H 24-34 6 +15 47 -10 +5 L W O 1 RS BE 0 Oct 25, 2008 SAT 8 2008 RUT PIT A 54-34 6 +9' 43 20 +29' W W O 1 RS BE 0 Dec 31, 2008 WED 13 2008 ORST PIT N 3-0 31 -1' 52 3 +1' W W U 0 BG P10 0 Sep 19, 2009 SAT 3 2009 NAVY PIT A 14-27 6 +8 51 -13 -5 L L U 0 RS IND 0 Date Day # Season Team Opp Site Final Rest Line Total SUm ATSm SUr ATSr OUr Conf Type Conf. OT Sep 26, 2009 SAT 3 2009 NCST PIT H 38-31 13 +1 47' 7 +8 W W O 0 RS ACC 0 Oct 10, 2009 SAT 5 2009 CON PIT A 21-24 13 +7 47 -3 +4 L W U 1 RS BE 0 Oct 16, 2009 FRI 6 2009 RUT PIT H 17-24 5 +6 46' -7 -1 L L U 1 RS BE 0 Oct 24, 2009 SAT 7 2009 SFL PIT A 14-41 8 +7 48' -27 -20 L L O 1 RS BE 0 Nov 07, 2009 SAT 9 2009 SYR PIT A 10-37 6 +21 49' -27 -6 L L U 1 RS BE 0 Nov 14, 2009 SAT 10 2009 NOTD PIT A 22-27 6 +6' 58' -5 +1' L W U 0 RS IND 0 Dec 05, 2009 SAT 12 2009 CIN PIT A 45-44 7 -1 57' 1 0 W P O 1 RS BE 0 Oct 23, 2010 SAT 7 2010 RUT PIT A 6 1 RS BE 0 Oct 30, 2010 SAT 8 2010 LOU PIT A 6 1 RS BE 0 Nov 11, 2010 THU 9 2010 CON PIT H 12 +1 1 RS BE 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.