A team whose scored 100+ points in each of their last 6 games over the last two seasons are 50-23 (68.5%) straight up when playing their next game at home. Knicks fall under this tonight
A team whose scored 100+ points in each of their last 6 games over the last two seasons are 50-23 (68.5%) straight up when playing their next game at home. Knicks fall under this tonight
Collected a decent amount of queries from this thread for anyone who wants to copy them down. There will be smilies to translate:
AD and WP<50 and o:WP>50 and ats streak<0 and o:ats streak>0 and on:H and 10<=game number<=60 and season>=2009
(F or AD) and WP>62 and o:WP>35 and P:FL and p:AW and pp:AW and game number>=25
H and line>-6 and p:AW and pp:AW and season>=2011
H and total>205 and p:HL and po:P3-p:P3 + po:P4-p:P4>14 and season>=2010
HD and total>205 and p:ADW and p:line>=4 and rest>0 and season >= 2005
A and P:ats margin <=-10 and P:season=season and P:H and season > 2012
line <=-11 and pooints <=80 and opooints >=110
H and p:margin<-9.5 and op:margin<-9.5 and opp:margin<-9.5 and oppp:margin<-9.5 and opppp:margin<-9.5
H and total>=201 and n:A and p:ADL and pp:ADL and season>=2011
HD and p:AL and P:AL and P:margin<=-30 and rest<=2 and line<8.5
HF and WP>=72 and game number>=25 and p:LF and line<=-9.5 and total>=187.5 and o:rest<3
P:AL and op:margin>10 and p:HW and 65>WP>o:WP and -10<=line<=-5 and H
H and total>199 and 99>tA(ooints)>91 and 103>oA(ooints)>97 and game number > 41 and p:margin>9 and pp:margin>9
rest=0 and p:W and pvertime>0
tS(W, N=10)>=8 and AF and line>=-5 and o:rest=0 and rest>o:rest
tA(ooints)<94 and opoints>100 and oppoints>100 and opppoints>100 and oppppoints>100 and HD and 185
AF and p:HW and pp:HW and p:margin>8 and pp:margin>8 and division!=o:division and line<-4 and season>=2006
P:FL and 75>=WP>=60 and 75>=o:WP>=60 and total>=200 and o:rest>0 and season>=2009
F and p:AL and p:margin<=-8 and WP>=o:WP and line<=-10.5 and game number<=68 and total>=187 and total<=212 and season>=2006
AF and -3<=ats streak<=-1 and 1<=o:ats streak<=2 and 1<= rest<=2 and season>2010
H and 9>=line>=3.5 and tS(L, N=4)=3 and 7-(rest+p:rest+pp:rest+ppp:rest)=5
rest=0 and p:rest=1 and pp:rest=0
H and season > 2009 and line > 5 and p:margin < -15 and op:margin > 5 and p:A and pp:A
-9.5<=line<=-3.5 and tA(points)>=102 and 102>=oA(ooints)>=98 and wins+losses>=42 and points+pooints>=205 and ppoints+ppooints>=205 and pppoints+pppooints>=205 and ppppoints+ppppooints>=205
Raptors on a back to back off an overtime game.
cool Noleaf, but it would have been a lot cooler if you have gave credit to whom posted each query.
Thanks for responding!
I get that the previous DPS result being higher means they overperformed offensively but that doesn't seem to only include weaker offensive teams, which I think you were going for. Even a top-scoring team like the blazers or clippers might score 15+ over their expected. Maybe we should include a parameter for team average between 92 and 98 or something like that and see if that makes a difference. I'd have to look up how to do that...I know it involves brackets.
Okay, I will try to tinker with it when I have some time. I was just curious if you had a theory for including home/away or won/loss. Since you ran it with previous game on road and next game at home, I didn't understand the logic of limiting it that way. I would think some momentum could be lost if coming back from a road trip as opposed to consecutive home games. But the numbers for each year with your query were very good.
Hey fellas,
Isnt' there a certain SDQL query that someone in here psoted before about a team getting beaten by 25+ points on the road (Lakers @ Spurs) to then covering at home when the line is bigger than -10?
Spurs 4q
Under 31tt -115 pts 2*
Lak 4q
+4.5 -115 1*
Woah my bad thought this was my thread
Nice, great job Leaf, this will help others who have entered the thread late or are a bit lost have a more complete base to experiment with.
I took out the smilies in them so they're now formatted to be used through cut/paste more easily.
Lot of money in that list...:an_dance:
This one likes the rockets cause the wolves won in overtime last night:
rest=0 and p:W and p: overtime>0
This one likes the wolves to get revenge:
A and P:ats margin <=-10 and P:season=season and P:H and season > 2012
But the revenge is for a 2nd meeting, so it may be rockets have their number. One of the wolves' greatest strength is their rebounding, where the Rockets are also strong. But missing Dwight, the wolves may get their revenge for the first 2. It's a pass for me, but those are the sdqls.