NBA Stituational Bet, SDQL

I'm sorry for all the questions, but why this query doesn't give me Pacers - Spurs game?
tA(o: points)<=94 and site=home and p:L and 20121131<=date and o:TPP>=37

Spurs shoot above 37% from three point...

Originally Posted by dmitean

Memphis are at season average of 14 three point attempts a game. How do I write it in SDQL?

tA(TPA)<=14

team's season average of three-point attempts equals or is below 14. Note, if a team averages 14.1 3-pointers a game, they will not show up.

Thanks!

tA(TPA)<=15 and rest=0 and WP>=50 - nothing interesting, but at least I manage to check what I wanted

HD and total>200 and season=2013

add "and rest"

HD and total>200 and season=2013 and o:rest=0

AF and total>200 and season=2013 and o:rest=0 this is as good

Originally Posted by Tillos

Simple, but wow. Few other but I like these two the best.

19-1 record: team=Pacers and p:A and H and rest>=0 and season=2013
17-0 record: team=Pacers and p:A and H and rest>=0 and o:rest=1 and op:W and season>=2012

Sorry to ask, but what exactly does this mean? lol thx for the help

Originally Posted by dmitean

Thanks!

tA(TPA)<=15 and rest=0 and WP>=50 - nothing interesting, but at least I manage to check what I wanted

That's the way data mining goes.
May not produce a "super" query, but the experience will pay for itself in time.

A and P:ats margin <=-10 and P:season=season and P:H and season=2013

wizards- 76s-spurs.

p:margin >= 25 and line > p:line and season >= 2013

opposite sixers.

Some from me tonight.

Previous match-up was a home loss, Away, 0<=line<=4, opponent has allowed 100 or more points in its last 2 games, opponent rest>1

tS(L, N=5)=5 and tS(o: points>=100, N=5)>=4 and o:WP<=30 and 210<=total

p:L and p:ats margin>0 and p:line>=10 and 2<=line<=4 and op:L and op:margin<=-13
(This is a support trend for the SAC pick)

JA, your first trend - I moved back the p to the semicolon and still doesn't pop up. What's wrong with it? I even lower cased the p in P:LH

Originally Posted by Tillos

JA, your first trend - I moved back the p to the semicolon and still doesn't pop up. What's wrong with it? I even lower cased the p in P:LH

No, that's the problem "P:LH" must be capitalised.
But something gone terribly wrong while copying I'll fix it.

I don't know why forum interface is deleting some parts of query when I save the reply, so I wrote it down 'in words'.

Originally Posted by JAnthony

Two tasty trends pointing on Kings tonight. Both situations were posted previously by JMon, if I'm not mistaking.

p:L and op:L and A and rest>=1 and 0<=line<=3 and P:margin>=5 and season>=2010

A and tA(o: points)>=103 and p:M2<=-10 and pp:M2<=-10 and o:rest<3 and rest<=3 and line<=14

First one don't ring a bell, but second one yes ! Have you check the ML on dogs of 4 or less