"P" stands for previous matchup...is there a way to tighten the parameter even more to only include if that matchup occurred in the previous season? (i.e. remove the results where the previous matchup between the 2 teams was 2 or more seasons ago). Thanks
Good question. This is no problem. The SDQL parameter
season
is the season in which the referenced game occurred. So,
P:season
is the season of the previous game.
If the season of the current game is one greater than the season of the previous game, then the previous match-up was from the previous season. So, to insist that the last time these two teams met was the previous season, use:
P:season+1=season
To include only divisional match-ups, use:
DIV
Ed
Thanks Ed, as always
8/1/2012
The Saints are 13-0 ATS (+13.7 ppg) since November 2007 when they are off an away loss.
team=Saints and p:AL and 20071101<=date
Dr M.
8/2/2012
The 49ers are 10-0 OU (+13.2 ppg) since 1998 on the road when they are off a road win.
team=Fortyniners and A and p:AW and season>=1998
8/3/2012
The Redskins are 8-0 ATS (+9.4 ppg) since 2003 as a road dog when they played at home in each of the previous two weeks.
team=Redskins and AD and p:H and pp:H and NB and p:NB and season>=2003
This one should be active in week 7 and might be active in week 15.
8/4/2012
The Giants are 14-0 ATS (+10.6 ppg) since 2000 as a dog after a win in which they committed no turnovers.
team=Giants and D and p:W and p:TO=0 and season>=2000
P.S. This one was active in the Giants' 37-20 win over the Packers as a 7.5 dog in last season's playoffs. It was our 2011 NFL Playoffs Game of the Year. It was also active in the Super Bowl.
8/5/2012
The Browns are 9-0 ATS (+8.2 ppg) since 2007 when they are off a road game in which they had at least 30 minutes of possession time.
team=Browns and 1800<=p:TOP and p:A and season>=2007
8/6/2012
The Raiders are 9-0 ATS (+17.6 ppg) since 2009 as a road dog vs a divisional opponent.
team=Raiders and AD and DIV and season>=2009
Note that the Raiders are 8-1 straight up in this spot.
8/7/2012
The Steelers are 15-0 OU (+13.7 ppg) since November 1998 when they are off a road loss and hosting a team with more wins.
team=Steelers and H and p:AL and wins<o:wins and 19981101<=date