"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
is the season in which the referenced game occurred. So,
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:
To include only divisional match-ups, use:
Thanks Ed, as always
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
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
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.
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.
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
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.
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