NBA Stituational Bet, SDQL

**dmitean** · 03-31-14, 08:56 AM

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...

**Wojo** · 03-31-14, 09:20 AM

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.

**dmitean** · 03-31-14, 09:24 AM

Thanks!

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

**green7** · 03-31-14, 11:05 AM

HD and total>200 and season=2013

add "and rest"

**green7** · 03-31-14, 11:08 AM

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

**nash13** · 03-31-14, 11:19 AM

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

**nflguru1** · 03-31-14, 11:30 AM

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

**b1slickguy** · 03-31-14, 11:53 AM

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.

**figue** · 03-31-14, 02:56 PM

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

wizards- 76s-spurs.

**figue** · 03-31-14, 03:02 PM

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

opposite sixers.

**JAnthony** · 03-31-14, 03:17 PM

Some from me tonight.

<line<=4 and="" opo

<line<=4 and="" opo

<line<=4 and="" opo:="" points=""><line<=4 and="" opo:="" points="">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
</line<=4></line<=4>(This is a support trend for the SAC pick)</line<=4></line<=4>

**Tillos** · 03-31-14, 03:21 PM

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

**JAnthony** · 03-31-14, 03:26 PM

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.

**JAnthony** · 03-31-14, 03:32 PM

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'.

**JMon** · 03-31-14, 04:28 PM

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

**azn1234** · 03-31-14, 04:40 PM

Originally posted by JAnthony

Some from me tonight.

<line<=4 and="" opo

<line<=4 and="" opo

<line<=4 and="" opo:="" points=""><line<=4 and="" opo:="" points="">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
</line<=4></line<=4></line<=4></line<=4>

A and P:HL and 0<=line<=4 and opo: points>=100 and oppo: points>=100 and o:rest>1

Is that correct? Thanks

**JMon** · 03-31-14, 04:44 PM

199.5>=total>=190 and 98>=tA(points)>=92 and 102>=oA(o: points)>=98 and wins+losses>=42 and po: points>=110 and ppo: points>=110 and rest<3 and o:rest<3

total for bobcats...this would be a good translation test..

**azn1234** · 03-31-14, 04:44 PM

Originally posted by JMon

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

SU: 23-5 (5.25, 82.1%) for dogs. Wow

**JMon** · 03-31-14, 04:51 PM

Originally posted by azn1234

SU: 23-5 (5.25, 82.1%) for dogs. Wow

actually 12-2, as you have to use line<=4 and D or you will capture all the favs in the situation

. A good way to see a situation that has both favs and dogs in it just filter it by using....and line

**JMon** · 03-31-14, 04:59 PM

check out the eastern conference in the total tonight

total > 202 and p: ou margin <= -18 and WP <= 25 and 2009 <= season

**JMon** · 03-31-14, 05:09 PM

simple but powerful total

197.5>=total>191 and tA(points)>=99 and p: points+po: points<=160

**cofaga** · 03-31-14, 05:22 PM

Originally posted by JMon

199.5>=total>=190 and 98>=tA(points)>=92 and 102>=oA(o: points)>=98 and wins+losses>=42 and po: points>=110 and ppo: points>=110 and rest<3 and o:rest<3

total for bobcats...this would be a good translation test..

1) total between 199.5-190
2) Below average offensive team
3) Opponent average defensive team
4) After 42 games or more
5) Allowing 110 points or more then last two games
6) both teams greater then 3 rest days

Pretty good results however I worry about the fact that those 110 points allowed only happened due to overtime so I may skip this query. Always appreciate it tho.

**FortySix** · 03-31-14, 05:24 PM

Hey fellas, sometimes I am unsure that you guys actually play the queries you post. I see a lot of queries on the page but do you guys play all of them? Is it possible to say that you are "playing" the query so we all can see how strong you feel about the play?

**cofaga** · 03-31-14, 05:34 PM

Originally posted by FortySix

Hey fellas, sometimes I am unsure that you guys actually play the queries you post. I see a lot of queries on the page but do you guys play all of them? Is it possible to say that you are "playing" the query so we all can see how strong you feel about the play?

I've always gone under the assumption that you play it if it feels right to you. I can't speak for everyone here but it's definitely not the best idea to just go by queries that hit 60%+, it's just an additional tool. Imo, it's best to asses the lines and totals and then checking to see if any good queries match your initial leans since queries have a habit of influencing your decisions, at least to me anyway.

**FortySix** · 03-31-14, 05:37 PM

Thanks Cofaga for your reply mate. Much appreciation from Australia. Love this thread. Best of SBR. Just trying to learn the SDQL query myself.

**evangelizelee** · 03-31-14, 05:47 PM

Originally posted by JAnthony

Some from me tonight.

<line<=4 and="" opo

<line<=4 and="" opo

<line<=4 and="" opo:="" points=""><line<=4 and="" opo:="" points="">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
</line<=4></line<=4>(This is a support trend for the SAC pick)</line<=4></line<=4>

What would the picks be fo these?

**evangelizelee** · 03-31-14, 06:12 PM

Originally posted by JMon

199.5>=total>=190 and 98>=tA(points)>=92 and 102>=oA(o: points)>=98 and wins+losses>=42 and po: points>=110 and ppo: points>=110 and rest<3 and o:rest<3

total for bobcats...this would be a good translation test..

What r ur picks for tonight?

**Mako-SBR** · 03-31-14, 06:17 PM

Originally posted by evangelizelee

What r ur picks for tonight?

We try not to post "picks" in the thread per se, just the situations we find interesting.

We do that to encourage people to get involved with SDQL and then learn its language for the longer term goal of then contributing their own unique angles after they master the verbiage.

"Teach someone hungry to fish instead of just giving them a fish", yada yada yada, you get the drift.

**evangelizelee** · 03-31-14, 06:24 PM

Originally posted by Mako-SBR

We try not to post "picks" in the thread per se, just the situations we find interesting.

We do that to encourage people to get involved with SDQL and then learn its language for the longer term goal of then contributing their own unique angles after they master the verbiage.

"Teach someone hungry to fish instead of just giving them a fish", yada yada yada, you get the drift.

Yea I understand. I have been trying to enter the code it doesnt pop up. So I tried to change the 'words'. Still doesnt work. Im trying to look at the examples belows to change it correctly but I cant find all the codes.

**JR007** · 03-31-14, 06:34 PM

just copy and paste into the query box, you can figure it out from there

**JMon** · 03-31-14, 06:37 PM

Originally posted by FortySix

Hey fellas, sometimes I am unsure that you guys actually play the queries you post. I see a lot of queries on the page but do you guys play all of them? Is it possible to say that you are "playing" the query so we all can see how strong you feel about the play?

I play every query I post, unless I state otherwise =)

**Mako-SBR** · 03-31-14, 08:20 PM

Originally posted by JMon

199.5>=total>=190 and 98>=tA(points)>=92 and 102>=oA(o: points)>=98 and wins+losses>=42 and po: points>=110 and ppo: points>=110 and rest<3 and o:rest<3

Winnnnnnnnnerrrrr

**JMon** · 03-31-14, 08:54 PM

Originally posted by Mako-SBR

yWinnnnnnnnnerrrrr

that one scared me. Looks like a 2-2 night for me

**figue** · 03-31-14, 09:33 PM

Originally posted by figue

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

wizards- 76s-spurs.

2-1 for me

**GiveMeaBJ** · 04-01-14, 01:08 PM

Got ****** with them Wiz.