Login Search

NBA Stituational Bet, SDQL

Last Post
#2073

Default

Went through the file and here are the queries that have games today:
http://sportsdatabase.com/nba/query?output=default&sdql=season+%3E+2002+and+11+%3E+p%3AM1+% 3E+4+and+p%3AM2+%3C+0+and+p%3AL+and+rest +%3D+0+and+o%3Arest+%3E+0&submit=++S+D+Q+L+!++


http://sportsdatabase.com/nba/query?output=default&sdql=208+%3E%3D+total+%3E%3D+201+and+tS% 28ou+margin%2C+N%3D5%29+%3E%3D+30+and+60 +%3E%3D+WP+%3E%3D+51+and+2009+%3C%3D+sea son+and+site+%3D+home&submit=++S+D+Q+L+!++


http://sportsdatabase.com/nba/query?output=default&sdql=%28AD+or+HF%29+and+p%3APTP%3E%3D33+ and+pp%3APTP%3E%3D33+and+%28p%3AW+or+p%3 AFL%29+and+rest%3C%3D2+and+o%3Arest%3C%3 D1+and+game+number%3C%3D80&submit=++S+D+Q+L+!++


http://sportsdatabase.com/nba/query?output=default&sdql=+AF+and+p%3AHW+and+pp%3AHW+and+p%3A margin%3E8+and+pp%3Amargin%3E8+and+divis ion!%3Do%3Adivision+and+line%3C-4+and+season%3E%3D2006+&submit=++S+D+Q+L+!++


http://sportsdatabase.com/nba/query?output=default&sdql=H+and+209+%3E+total+%3E+201+and+60+ %3E%3D+WP+%3E%3D+51+and+Sum%28ou+margin% 40team+and+season%2C+N%3D5%29+%3E%3D+36+ and+season+%3E+2007+and+playoffs+%3D+0+&submit=++S+D+Q+L+!++


http://sportsdatabase.com/nba/query?output=default&sdql=po%3Adefensive+rebounds+-+p%3Aoffensive+rebounds+%3E+33+and+%28p% 3AHL+or+p%3AW%29&submit=++S+D+Q+L+%21++


http://sportsdatabase.com/nba/query?output=default&sdql=p%3Amargin+%3E%3D+25+and+line+%3E+p %3Aline+and+season+%3E%3D+2012&submit=++S+D+Q+L+%21++


http://sportsdatabase.com/nba/query?output=default&sdql=p%3Adefensive+rebounds+%2B+po%3Aoff ensive+rebounds+%3E+52+and+H+and+p%3Afou ls+%3C26+and+season+%3E+2011&submit=++S+D+Q+L+%21++


http://sportsdatabase.com/nba/query?output=default&sdql=+tA%28points%29%3E%3D94.5+and+p%3AM 3%3E3.5+and+pp%3AM3%3E3.5+and+tA%28o%3Ap oints%29%3C%3D94+and+season+%3E+2012+and +o%3Arest%3C2&submit=++S+D+Q+L+%21++


http://sportsdatabase.com/nba/query?output=default&sdql=H+and+60%3E%3D+WP%3E%3D51+and+tS%28 ou+margin%2C+N%3D5%29%3E%3D18+and+198%3C %3Dtotal%3C%3D207+and+C+and+season%3E%3D 2006&submit=++S+D+Q+L+%21++


http://sportsdatabase.com/nba/query?output=default&sdql=A+and+102%3E%3DtA%28points%29%3E%3D 98+and+102%3E%3DoA%28o%3Apoints%29%3E%3D 98+and+po%3Apoints%3E%3D100+and+ppo%3Apo ints%3E%3D100+and+2009%3C%3Dseason+and+l ine%3C8&submit=++S+D+Q+L+%21++


http://sportsdatabase.com/nba/query?output=default&sdql=conference+%21%3D+o%3Aconference+an d+p%3ALF+and+p%3Amargin+%3C+-9+and+season+%3E+2010+and+site%3Dhome+an d+playoffs%3D0+&submit=++S+D+Q+L+%21++


http://sportsdatabase.com/nba/query?output=default&sdql=210%3Etotal%3E199.5+and+60%3E%3DWP% 3E%3D51+and+Sum%28ou+margin@team+and+sea son%2C+N%3D5%29+%3E%3D36+and+season%3E20 07+and+playoffs%3D0+and+H&submit=++S+D+Q+L+%21++


http://sportsdatabase.com/nba/query?output=default&sdql=HD+and+p%3AL+and+p%3Aats+margin%3C0 +and+p%3ATPA%3E%3D18+and+p%3ATPP%3C25+an d+rest%3E0+and+o%3Astreak%3E1+and+line%3 E%3D4+and+season%3E%3D2006&submit=++S+D+Q+L+%21++


http://sportsdatabase.com/nba/query?output=default&sdql=season+%3E%3D+2005+and+HD+and+p%3AL +and+rest%3D0+and+game+number+%3E+10+and +game+number+%3C+60+&submit=++S+D+Q+L+%21++


http://killersports.com/nba/query?sdql=+p%3Aou+margin%3E10+and+rest+ %3C1+and+P%3AL+and+season%3E2008+and+11. 5+%3E+line+%3E+-10+&submit=++S+D+Q+L+!++


http://killersports.com/nba/query?sdql=p%3Arebounds%3Cpo%3Arebounds+ and+HD+and+p%3ADW+and+season+%3E%3D2006&submit=++S+D+Q+L+%21++


http://killersports.com/nba/query?sdql=tA%28P4%29+-5+%3E+oA%28P4%29+and+game+number+%3E%3D+ 10+&submit=++S+D+Q+L+%21++


http://killersports.com/nba/query?sdql=line+%3C%3D+-5+and+site+%3D+away+and+tp%3Amargin+%3C+ 0+and+tp%3Asite+%3D+away+and+0+%3C+tp%3A line&submit=++S+D+Q+L+!++


http://killersports.com/nba/query?sdql=A+and+F+and+p%3AA+and+p%3AL+a nd+total+%3E%3D+198&submit=++S+D+Q+L+!++


http://killersports.com/nba/query?sdql=tA%28FGA%29+%3E+84.3+and+otA% 28FGA%29+%3E+84.4+and+H+and+tA%28turnove rs%29+%2B+otA%28turnovers%29%3C%3D30.5+&submit=++S+D+Q+L+!++
#2074

Default

Some of them I didn't really like, but here are the results:
Over in Phoenix
Nets -8
Clippers -8 X2
Toronto -3.5
Phoenix -8 (small)

Portland

Memphis X2

Under in AtlantaX2 (4)
Over TT Dallas?
Wizards
Spurs
Over in Okla and SA
Over in LA
Houston?
Over in Detroit

Under in Toronto was a hit 4 times, but queries are pretty similar one to the other with small differences.
Over TT for Clips and Memphis should be a nice option
#2078

Default

Quote Originally Posted by Consigliere View Post
Trends say over for this game but they haven't been hitting much more than 50% so far
Agree, to the point that this week I went through and purged all of the over/under queries I had that only addressed the scenario for one team.

From this point forward I'll only personally play O/U trends that have parameters for both teams in the query, i.e., are addressing both of their situations simultaneously in the same game.
#2079

Default

NBA SDQL 'BEST BET' 2014-15

11-26-14 - 2:35p PST

Play: HOU (-5) SAC -110

SDQL:
HF and p:PTP>=31 and pp:PTP>=31 and p:W and pp:W and playoffs=0 and division!=o:division and season>=2006


SDQL English:
Playing a home fave that has been making a living from beyond the arc, generating nearly a third of their total points from three-point shots the past two straight games (and winning both of them) going against an opponent outside of their division.

Notes:
This one has been shaky lately, and relying on a soft clown team led by the biggest soft clown in the NBA to get it back on track doesn't make me feel much better about it haha...
#2081

Default

NBA Best Bet

11/26/14 7:00 PM EST

Dallas -13 -130 (buy 1 pt.) (vs. New York) 5dimes

H and p:HFL and p:line <= -8 and season >= 2011
ATS: 52-23-2 (3.74, 69.3%) avg line: -7.3
HF and p:HFL and p:line <= -8 and season >= 2011 and line <= -5
ATS: 41-17-2 (3.57, 70.7%) avg line: -9.3

Play the home team that lost their previous game straight up as a 8 point favorite or better. Teams in this situation have shown the tendency to bounce back. Missed the good number again though lol so will buy down to 13 for an extra cushion. The game is in the database as Dallas -12.5 so want to play it as close to that number as possible.
#2084

Default Spitball Query Results 11/26/14

0-1: atl/tor UNDER From b1slickguy O/U: 18-50-1 (-4.38, 26.5)
210>total>199.5 and 60>=WP>=51 and Sum(ou margin@team and season, N=5) >=36 and season>2007 and playoffs=0 and H

1-0: dal/ny OVER from hyahyah O/U:46-19-2 (5.29, 70.8%)
conference != o:conference and p:LF and p:margin < -9 and season > 2010 and site=home and playoffs=0

1-0: phx/den OVER from funfreaker O/U:183-117-3 (4.66, 61.0%)
tA(FGA) > 84.3 and otA(FGA) > 84.4 and H and tA(turnovers) + otA(turnovers)<=30.5

0-1: sa/ind UNDER from ronald -- O/U:20-43-3 (-4.26, 31.7%)
H and ats streak >= 4 and p:line <= -10 and season >= 2005

1-1: sa/ind and okc/ut OVER "From Nash O/U: 103-60-0 (3.35, 63.2%)
p:defensive rebounds + po:offensive rebounds > 52 and H and p:fouls <26 and season > 2011

1-0: phx covers vs den From pip ATS:140-212-7 (-1.75, 39.8%)
p:ou margin>10 and rest <1 and P:L and season>2008

1-0: bkn covers vs phi from nash ATS:290-224-8 (0.44, 56.4%)
A and F and p:A and p:L and total >= 198

1-0: mil covers vs mn zeeman21 ATS: 308-228-9 (0.71, 57.5%)
site=away and line < 0 and 0 < p:margin and p:streak <= -2 and 19951030 <= date

1-0: mil covers vs mn From Jmon ATS: 36-9-1 (3.43, 80.0%)
AF and line >= -9 and p:margin >= 10 and p:division=po:division and op:HL and op:margin <= -10 and 1996 <= season

0-1: lac covers vs det Pip --ATS:93-142-3 (-2.11, 39.6%)
season >= 2005 and HD and p:L and rest=0 and game number > 10 and game number < 60

Total: 7-4
Last edited by pip2; 11-27-14 at 12:35 AM. Reason: Counted clippers wrong