I intend to post an NFL Query of the Day for every day through the start of the NFL season. After the preseason, I'll focus on trends that are active for the upcoming week of action. I have decided to put all the queries in the same thread. I hope this is the desirable choice.
6/10/2012 NFL Query of the Day
The Steelers are 14-0 ATS (+8.3 ppg) since 2000 when they get a team that won by 20-plus points last week, as long as they are not off a 20-plus point loss.
team=Steelers and op:margin>=20 and o:NB and p:margin>=-20 and season>=2000
SDQL Guru
sweet. please post the results in the thread as well. thanks for the work. GO TEXANS!!!!!
SDQL Query of the Day 6/11/2012
HOU001 The Texans are 14-0 ATS (+11.8 ppg) since December 2004 as a road dog when they are off a road game last week in which their opponent failed on two or fewer red zone attempts. The SDQL text is:
team=Texans and AD and p:A and po:RZF<=2 and NB and 20041201<=date
Running this SDQL text reveals that in the Texans' lone active date last season they whomped the Titans 41-7 as a FG dog.
SDQL Tip: The SDQL phrase po:RZF<=2 translates as; previous opponent's red zone failures is less than or equal to two.
The Falcons are 0-12 ATS (-13.0 ppg) since 2001 at home when they allowed 17 points or fewer in each of their last two games. The SDQL text is:
team=Falcons and H and po:points<=17 and ppo:points<=17 and season>=2001
Note that the Falcons have allowed an average of 28.6 ppg over these dozen games and, since 2005, they have allowed an average of 33.4 ppg.
can you run double digit home dogs ats......been to site but I can't figure it out,lol.....think they were 100% last yr....
Mr Deliveryman3,
I have great respect for your work and think I can increase your efficiency by 1000% by showing you some SDQL. The combination of the SDQL and your sports betting experience and knowledge will make a deadly combination. This is probably best done over the phone with both of us in front of a computer.
Whatever, baseball, NBA, etc.. Send me a private message and I'll send you a number to call.
The SDQL for double digit home dogs is:
H and line>=10
That is, the team is at home and their line is ten points or higher.
Thanks for your interest in the SDQL.
6/13/2012
The Falcons are 10-0 ATS (+11.8 ppg) since 2002 when visiting a team that is on a 2+ game losing streak.
team=Falcons and A and o:streak<=-2 and season>=2002
thx Guru...got that to work.....will try and get in touch soon
results for HD of 10 or more were 71-51 ats since 1990......36-25 since 2000 and 35-26 1990 up to 2000season.......pretty steady...7-0 last yr
6/14/2012
CHI012 The Bears are 0-21 OU (-10.5 ppg) since 1996 on Sunday when they are off a road loss by more than a field goal in which they suffered a two-plus turnover margin. The SDQL text is:
team=Bears and day=Sunday and p:A and p:margin<-3 and 2<=p:TOM and season>=1996
When you run this query, you'll note the two double-digit unders from last season.
6/15/2012
SEA006 -- The Seahawks are 0-18 ATS (-10.1 ppg) since 2003 when they are off a game as a favorite of more than four points in which they benefited from a positive takeaway margin. The SDQL text is:
p:line<-4 and p:TOM<=-1 and team=Seahawks and season>=2003