NBA Stituational Bet, SDQL

**JMon** · 04-02-14, 04:38 PM

Originally posted by green7

p:HFW and AD and division=o:division and rest=0 and o:rest>0 and month=4 and line<5

I am typing this with my fingers and toes crossed.....hope I don't put the hex on it.

check out dogs in the following

A and 102 >= tA(points) >= 98 and 102 >= oA(o: points) >= 98 and p: points >= 100 and pp: points >= 100 and wins + losses >= 42 and 2009<=season and line<=4

**Enjoi** · 04-02-14, 04:40 PM

Also am leaning the raptors as they are still without Howard and Beverly and Lin is terrible lately. Just a kittle worried about them missing Lowry. What is the trend for Toronto tonight?

**JMon** · 04-02-14, 05:08 PM

Keep fading the pacers??

H and month = 4 and p:H and p:margin <= -20 and line < 13

A and po: points >= 105 and op: points <= 85 and op2: points <= 85 and op3: points <= 85 and line > -9.5

**JMon** · 04-02-14, 05:25 PM

189.5 > total >= 182 and p:U and 98 >= tA(points) >= 92 and oA(o: points) >= 102 and rest < 2

Bulls perfect in this total. Road much better

**JR007** · 04-02-14, 08:37 PM

late ml/spread move killed the warriors play

**figue** · 04-02-14, 10:06 PM

Originally posted by figue

Look like easy line for Houston, lets play Raptors!!

**figue** · 04-02-14, 10:08 PM

Originally posted by figue

tomorrow bobcats.

**figue** · 04-02-14, 10:09 PM

Originally posted by figue

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

tomorrow buks,warriors.

0-2

2-2 today

**parlayin** · 04-02-14, 10:12 PM

Is there any way to query quality of opponents? Like if you want to see how a team has performed against top teams

**JAnthony** · 04-02-14, 10:44 PM

Originally posted by parlayin

Is there any way to query quality of opponents? Like if you want to see how a team has performed against top teams

Opponent quality can be defined by win percentage, points scored and allowed.

**figue** · 04-02-14, 11:47 PM

Originally posted by JAnthony

So we play Raps today?

WP>=65 and rest=0 and 50<=o:WP<=60 and AD and line<=4 and game number>=62

**figue** · 04-03-14, 12:49 AM

Originally posted by JAnthony

Or maybe some Knicks?

p:WHF and po:WP>=65 and rest=0 and AD and season>=2007

**parlayin** · 04-03-14, 01:55 AM

Originally posted by JAnthony

Opponent quality can be defined by win percentage, points scored and allowed.

Thanks...what's the parameter for win percentage?

**green7** · 04-03-14, 04:45 AM

Some nice finds

Figue, J Anthony, JMon, Nash, you guys are coming up with some very nice finds...thanks for sharing.

I had a mediocre day, hope you guys did better.

Best to all of us tomorrow and going forward.

**Enjoi** · 04-03-14, 05:42 AM

Just echoing the above comment; appreciate your work and thank each and every one of you guys

**JAnthony** · 04-03-14, 11:53 AM

Thanks for the kind words, guys!

Such a sweet spot for trend digging today. Got some sweet ones already for the SAS v. OKC game.

WP>=70 and rest=0 and A and P:LF and season>=2005 and total>=203 (total only)

P:L and PP:L and PPP:L and conference=o:conference and WP>=70 and rest=0 and season>=2007

**nash13** · 04-03-14, 12:23 PM

I wanted to add my 2 star plays:
These are not so good as the ones I mentioned before
MLB:
temperature < 67 and site == home and line > -105 and line < 180 (Dogs only)
p:start time >= 1700 and start time < 1250 and rest = 0 and temperature < 80 and 5 < month < 10
HF and p:HD and p:margin > 4
D and p

and p:W and p:runs <= 3
month = 8 and D and sssss:SSO = 5 and 3 < ssss:SSO < 6 and 1 < sss:SSO and ss:SSO < 10 and s:SSO < 10 and -7 < streak < 4 and -2 < o:streak
H and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month != 7 and month != 8) and 2008 <= season and SG > 1 and total > 6.5
HD and tA(W) < .42 and month < 7 and division = o:division
site == home and line >= 100 and Average(errors@team and season) <= .5 and p:runs <= 3 and po:runs <= 3 and 2007 <= season

NBA:
AF and line < -3 and line > -10 and Average(margin@team and season) >= 3 and p

oints > 104 and pp

oints > 104 and ppp

oints > 104 and rest < 2 and WP > 64.1 and game number > 16
p:dps < -11 and op:dpa < -11 and rest <= 1 and o:rest <= 1
rest + p:rest = 1 and o:rest > 0 and H and season = 2013
H and Average(margin@team and season) <= -6 and p:W and p:margin < 5
A and p:AFL and p:line >= -4 and season > 2007
line <= -5 and site = away and tp:margin < 0 and tp:site = away and 0 < tp:line
season >= 2008 and p

u margin > 20 and op

u margin > 20 and H
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
total >= 200 and P:FL and 75 >= WP >= 60 and 75 >= o:WP >= 60 and 2005 <= season and o:rest > 0
A and tA(points) >= 102 and oA(o

oints) >= 102 and op:W and p

oints >= 100 and pp

oints >= 100 and month in [12 , 1 , 2 , 3 , 4]
AD and rest < 2 and p:HW and p:dps >= 15 and p:margin >= 10 and season >= 2006
(F or AD) and WP > 62 and o:WP > 35 and P:FL and p:AW and pp:AW and game number >= 25
A and P:ats margin <= -10 and P:season = season and P:H and season > 2012
P:FL and 75 >= WP >= 60 and 75 >= o:WP >= 60 and total >= 200 and o:rest > 0
AD and p:AL and p:margin <= -13 and tA(points) >= 100 and o:WP >= 60 and o:rest > 0
total <= 199.5 and p

oints >= 108 and p

vertime = 0 and pp

oints >= 102 and op:quarter scores op:P1 + op:quarter scores op:P2 >= 57 and op:W and season >= 2000
H and line > -6 and p:AW and pp:AW and season >= 2011
total <= 199.5 and p

oints >= 108 and p

vertime = 0 and pp

oints >= 102 and op:quarter scores op:P1 + op:quarter scores op:P2 >= 57 and op:W
HF and WP >= 72 and game number >= 25 and p:LF and line <= -9.5 and total >= 187.5
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
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
p:LAF and p

oints <= 90 and rest >= 1 and tA(points) >= 103 and total < 210 and playoffs = 0

NCAAF:
p:margin > 34 and site == 'home'

NHL:
A and p:A and p:F and p:W and date>=20111204
A and p:F and p:L and date>=20131012
A and p:H and p:L and date>=20131015
H and D and p:H and date>=20120214
H and D and p:H and p:F and date>=20120116
A and D and p:H and p:F and date>=20131014
p:U and p

W and D and line < 150
pt:shots on goal / pt:goals <= 6.7 and Sum(W@team,N=3) = 2 and op:date = date -1 and HWP > o:HWP and season >= 2011

NFL:
Sum(ats margin > 0@team and season, N=6) < 2 and WP < 25 and site != p:site
Sum(ats margin > 0@team and season, N=6) < 2 and WP < 25 and site != p:site
AF and p:W and pp:W and ppp:W and conference != o:conference and total < 46

**figue** · 04-03-14, 12:27 PM

Originally posted by JAnthony

Thanks for the kind words, guys!

Such a sweet spot for trend digging today. Got some sweet ones already for the SAS v. OKC game.

WP>=70 and rest=0 and A and P:LF and season>=2005 and total>=203 (total only)

P:L and PP:L and PPP:L and conference=o:conference and WP>=70 and rest=0 and season>=2007

thnaks buddy

**figue** · 04-03-14, 12:27 PM

Originally posted by nash13

I wanted to add my 2 star plays:
These are not so good as the ones I mentioned before
MLB:
temperature < 67 and site == home and line > -105 and line < 180 (Dogs only)
p:start time >= 1700 and start time < 1250 and rest = 0 and temperature < 80 and 5 < month < 10
HF and p:HD and p:margin > 4
D and p

and p:W and p:runs <= 3
month = 8 and D and sssss:SSO = 5 and 3 < ssss:SSO < 6 and 1 < sss:SSO and ss:SSO < 10 and s:SSO < 10 and -7 < streak < 4 and -2 < o:streak
H and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month != 7 and month != 8) and 2008 <= season and SG > 1 and total > 6.5
HD and tA(W) < .42 and month < 7 and division = o:division
site == home and line >= 100 and Average(errors@team and season) <= .5 and p:runs <= 3 and po:runs <= 3 and 2007 <= season

NBA:
AF and line < -3 and line > -10 and Average(margin@team and season) >= 3 and p

oints > 104 and pp

oints > 104 and ppp

oints > 104 and rest < 2 and WP > 64.1 and game number > 16
p:dps < -11 and op:dpa < -11 and rest <= 1 and o:rest <= 1
rest + p:rest = 1 and o:rest > 0 and H and season = 2013
H and Average(margin@team and season) <= -6 and p:W and p:margin < 5
A and p:AFL and p:line >= -4 and season > 2007
line <= -5 and site = away and tp:margin < 0 and tp:site = away and 0 < tp:line
season >= 2008 and p

u margin > 20 and op

u margin > 20 and H
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
total >= 200 and P:FL and 75 >= WP >= 60 and 75 >= o:WP >= 60 and 2005 <= season and o:rest > 0
A and tA(points) >= 102 and oA(o

oints) >= 102 and op:W and p

oints >= 100 and pp

oints >= 100 and month in [12 , 1 , 2 , 3 , 4]
AD and rest < 2 and p:HW and p:dps >= 15 and p:margin >= 10 and season >= 2006
(F or AD) and WP > 62 and o:WP > 35 and P:FL and p:AW and pp:AW and game number >= 25
A and P:ats margin <= -10 and P:season = season and P:H and season > 2012
P:FL and 75 >= WP >= 60 and 75 >= o:WP >= 60 and total >= 200 and o:rest > 0
AD and p:AL and p:margin <= -13 and tA(points) >= 100 and o:WP >= 60 and o:rest > 0
total <= 199.5 and p

oints >= 108 and p

vertime = 0 and pp

oints >= 102 and op:quarter scores op:P1 + op:quarter scores op:P2 >= 57 and op:W and season >= 2000
H and line > -6 and p:AW and pp:AW and season >= 2011
total <= 199.5 and p

oints >= 108 and p

vertime = 0 and pp

oints >= 102 and op:quarter scores op:P1 + op:quarter scores op:P2 >= 57 and op:W
HF and WP >= 72 and game number >= 25 and p:LF and line <= -9.5 and total >= 187.5
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
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
p:LAF and p

oints <= 90 and rest >= 1 and tA(points) >= 103 and total < 210 and playoffs = 0

NCAAF:
p:margin > 34 and site == 'home'

NHL:
A and p:A and p:F and p:W and date>=20111204
A and p:F and p:L and date>=20131012
A and p:H and p:L and date>=20131015
H and D and p:H and date>=20120214
H and D and p:H and p:F and date>=20120116
A and D and p:H and p:F and date>=20131014
p:U and p

W and D and line < 150
pt:shots on goal / pt:goals <= 6.7 and Sum(W@team,N=3) = 2 and op:date = date -1 and HWP > o:HWP and season >= 2011

NFL:
Sum(ats margin > 0@team and season, N=6) < 2 and WP < 25 and site != p:site
Sum(ats margin > 0@team and season, N=6) < 2 and WP < 25 and site != p:site
AF and p:W and pp:W and ppp:W and conference != o:conference and total < 46

nice work

**Enjoi** · 04-03-14, 05:10 PM

Anthony, could you post the plays for the Spurs game please. Ty

**JMon** · 04-03-14, 05:21 PM

Nothing for me tonight...too many competing situations. Gl fellas

I did dig one up possible for the Knicks game tomorrow,,

A and 199>=total>=190 and p:P1+p:P2>=55 and p2:P1+p2:P2>=55 and op: P1+op: P2>=60

**JMon** · 04-03-14, 05:23 PM

Did post dog winners on the Cubs, Twins and hopefully the Mariners in the MLB thread

. Yesterday had a total cash and one push(extra innings). Missed two big dogs both by walk offs. Like to see some of you guys get active in there.

**JAnthony** · 04-03-14, 09:47 PM

This is why you have to stay away from Spurs games like this. Pop was just testing out different things and plays for the whole 2nd half. No worries, take the over in Dallas game.

**19th Hole** · 04-03-14, 10:39 PM

Originally posted by JMon

Nothing for me tonight...too many competing situations. Gl fellas

I did dig one up possible for the Knicks game tomorrow,,

A and 199>=total>=190 and p:P1+p:P2>=55 and p2:P1+p2:P2>=55 and op: P1+op: P2>=60

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Curious if this is applicable for Friday as the 30th (last) entry was for Dec. 9, 2012

Thank You.

**figue** · 04-04-14, 12:01 AM

A and P:L and Po

oints > 74 and WP >= 40 and WP <= 49 and o:WP > 29 and o:WP < 54 and rest > 0 and season = 2013

tomorrow cavs.

**figue** · 04-04-14, 12:16 AM

Originally posted by JAnthony

This is why you have to stay away from Spurs games like this. Pop was just testing out different things and plays for the whole 2nd half. No worries, take the over in Dallas game.

nice late call

**figue** · 04-04-14, 12:38 AM

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

minesota

A and rest=0 and o:WP>=60 and o:rest>=1 and game number>=42

houston SU

**parlayin** · 04-04-14, 12:58 AM

Originally posted by parlayin

Thanks...what's the parameter for win percentage?

Bump

**green7** · 04-04-14, 04:07 AM

Win percentage query is tA(W) if you wish to query a team whose winning percentage is over 60 percent, then tA(W)>.6

If you wish to query winning percentage of opponent...say one whose WP is less than 40 percent oA(W)<.4

It is all in the query manual on the killersports website.

**green7** · 04-04-14, 04:16 AM

Fo Saturday

pp:AFW and p:HFW and HF and op:HFW and division!=o:division and 188<=total<=204<total<204 and="" rest=""> and o:rest>0 and rest>0 and line>=-6

Versus Knicks.

</total<204>

**green7** · 04-04-14, 04:23 AM

Adding to Figue's query, the total looks interesting

re-ran it and it didn't look so good. Here's what I have in an expanded query. Side (T'wolves) still looks interesting.

AD and rest>0 and o:WP>=60 and o:rest>=1 and game number>=42 and 12> line>6 and total>200 and division!=o:division and P:HDL and season>2012

SU: 4-7 (-5.36, 36.4%)
ATS:8-3-0 (4.09, 72.7%)
avg line: 9.5
O/U: 5-6-0 (-4.00, 45.5%)
avg total: 206.8

**JMon** · 04-04-14, 09:46 AM

Originally posted by 19th Hole

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Curious if this is applicable for Friday as the 30th (last) entry was for Dec. 9, 2012

Thank You.

Definitely a personal criteria worth noting regarding whether a particular situation is worthy of a play

**green7** · 04-04-14, 10:08 AM

AD and rest=0 and po:streak>= 4 and p:HFW and division!= o:division and total>200

**Wojo** · 04-04-14, 11:57 AM

Originally posted by green7

AD and rest=0 and po:streak>= 4 and p:HFW and division!= o:division and total>200

Cool one, green! If you eliminate the non-division parameter, you almost double your sample size.

And, if you add o:rest>0, it improves a little more.

GL2A!

**JMon** · 04-04-14, 02:30 PM

Two potential dog MLs

H and 102>=tA(points)>=98 and 102>=oA(points)>=98 and wins+losses>=48 and p:M2>=20

A and -3<=line<=3 and 102>=tA(points)>=98 and 102>=oA(o: points)>=98 and po: points>=100 and ppo: points>=100 and 2008<=season