NBA Stituational Bet, SDQL

Originally Posted by Ronald S.

Hey guys I just started learning this sdql stuff. What do you think about this trend for tonight?

AD and p:ADW and rest = 0 and o:rest = 1

O/U:	119-168-6 (-2.39, 41.5%)	avg total: 195.2

AD and p:ADW and rest=0 and o:rest=1 and p:line>9

O/U:	12-25-0 (-4.96, 32.4%)	avg total: 194.7

Kings/Nuggets 202

The query looks solid although I see this one going the other way. Total is down to 201 and Nuggs still playing at a top 5 pace but just not making shots. Nuggs also love to play extra fast when they have an opponent on a b2b. I really like the over here despite the trend outlined.

Glad to see this back around

where can you find statistics on pace? thanks

Originally Posted by hyahya

The query looks solid although I see this one going the other way. Total is down to 201 and Nuggs still playing at a top 5 pace but just not making shots. Nuggs also love to play extra fast when they have an opponent on a b2b. I really like the over here despite the trend outlined.

It looks like it was pure gold from around 1998 to 2007, but has slipped a bit in more recent years:
18 8-9-1 (-0.89, 47.1%) 199.3 season = 2006
15 3-11-1 (-10.23, 21.4%) 199.6 season = 2007
15 6-8-1 (-2.80, 42.9%) 193. season = 2008
12 6-6-0 (1.25, 50.0%) 197.6 season = 2009
14 6-7-1 (0.39, 46.2%) 202.0 season = 2010
17 8-9-0 (-2.68, 47.1%) 193.0 season = 2011
15 7-8-0 (-2.03, 46.7%) 198.4 season = 2012
18 8-9-1 (2.83, 47.1%) 202.8 season = 2013

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

AD and rest<2 and p:HW and p:dps>=15 and p:margin>=10 and season>=2006

thanks for the feeback guys. I did it again with total >199.5 and it is somewhat weaker but I think I will go with the under anyway along with SAC +7. Interestingly, Kings 1st 3 games have all gone under.

AD and p:ADW and rest = 0 and o:rest = 1 and total > 199.5

O/U:	36-53-4 (-1.81, 40.4%)	avg total: 207.4

and small sample size but pretty decent for 2013
AD and p:ADW and rest = 0 and o:rest = 1 and total > 199.5 and season = 2013

O/U:	2-8-1 (-8.09, 20.0%)	avg total: 207.9

Originally Posted by nash13

One of the easiest:
HF and o:rest=0 and rest > 3

O/U:83-48-5 (5.57, 63.4%) avg total: 196.8

Nice on nash! Eliminate those end of the season games.

Hey fellas,

Trying to figure out a play on the Kings @ Nugs over. 202 seems low for a Nugs home game and I think after their bad efforts against OKC the other night the Nuggets can get their offense moving in the right direction. Kings on a back to back as well, can't see them playing too much defense in the Mile High City. Does anyone have any SDQL to fit this play?

The basis of this is fading a home fav that is poor at drawing fouls.

H and tA(FTA)<=21 and month=11 and F and -8.5<=line<=-3 and 2002<=season and rest<4 and o:rest<3 and losses>0 and o:wins<7 and o:losses<9

Originally Posted by pip2

Nice one coming up tomorrow courtesy of mako himself...

AD and p:AL and p:margin<=-13 and tA(points)>=100 and o:WP>=60 and o:rest>0

Originally Posted by FunkFreaker

Really enjoy the numbers here but what is the logic in this trend ? Really don't know if we can trust on that "tA(points)>=100" after only couple of games for Celts... they score 120 (home) and 90 (road).

Agree Funk, this is a good scenario once teams have more games under their belts, am also not playing it yet.

Actually I'm holding off until next Monday to start my NBA betting across the board for that same reason, the beginning of the season (and the end of the regular season for that matter) introduce too many variables for me to follow a query unless said query is specifically targeting those time frames.

Hard to hold back, believe me, JMon and everyone else make it tough to resist!!

Sorry I didn't lay this down before, too busy. This might be worth saving for the future. To me it is interesting because today's game seems very counter intuitive. It is from a guy named Tom on the Google group and shows a decent chance the 76ers will cover vs. the Rockets...

H and (line>10 or line<-15) and p:L and rest+p:rest+pp:rest>1 and rest<3 and playoffs=0 and p:line<=15

Really loving this thread, especially to confirm picks that you come to using other methods.

HF and p:AD and p:margin<0 and p:fouls>25 and rest=0 and line>-6 and o:rest>0

SU:	35-21 (2.38, 62.5%)
ATS:	25-30-1 (-0.75, 45.5%)	avg line: -3.1
O/U:	37-18-1 (5.78, 67.3%)	avg total: 195.6

A quality team with no rest after a tough game in which they weren't expected to win, and they got into foul trouble. The next game they go home and play more loose on defense against a quality opponent who has rest.

Feel free to criticize.

Not bad for your first post +1

Originally Posted by FlyinAir

Not bad for your first post +1

Thanks!

Updates to queries brought to you by Nash13. They are all similar but lead to one conclusion.

AF and p:AFL and 1 <= rest <= 2 and season>2007

AF and p:AFL and 1 <= rest <= 2 and season > 2007
SU: 95-35 (6.70, 73.1%) ATS: 80-46-4 (1.59, 63.5%) avg line: -5.1 O/U: 56-72-2 (-1.24, 43.8%) avg total: 197.1

p:margin < -15 and AF and season > 2007 and total>199

p:margin < -15 and AF and season > 2007 and total > 199
SU: 45-14 (6.92, 76.3%) ATS: 42-17-0 (2.82, 71.2%) avg line: -4.1 O/U: 29-29-1 (-0.42, 50.0%) avg total: 206.8

AF and p:AFL and p:line >= -4 and season > 2007 and total>199

AF and p:AFL and p:line >= -4 and season > 2007 and total > 199
SU: 42-11 (7.74, 79.2%) ATS: 39-13-1 (2.91, 75.0%) avg line: -4.8 O/U: 26-27-0 (-0.42, 49.1%) avg total: 206.6