Winning Picks, Guaranteed

featuring the Sports Data Query Language
Create New Account
--- or ---
username
password
forgot password?
   Home  |  Trend Mart   ||   NFL  |  NBA  |  WNBA  |  MLB  |  NHL  |  CFL  |  NCAA FB  |  NCAA BB   ||   NBA: Home | Tables | Trends | Query Matrix | SDQL Query  

NBA SDQL Query Access - In Testing Your query timeout is 15 seconds.

Content will appear here


points < 60
SU: 0-26 (-28.92, 0.0%)
ATS: 0-26-0 (-24.71, 0.0%)   avg line: 4.2
O/U: 0-25-1 (-37.54, 0.0%)   avg total: 180.1
FG Pct FT Pct 3s Pct BLKS O-RBND RBND Fouls AST TOvers Q1 Q2 Q3 Q4 Final
Team 21.85 30.0 10.54 63.1 2.58 18.8 4.23 10.92 37.69 19.85 12.27 16.77 14.0 15.0 14.1 13.7 56.8
Opp 32.58 44.5 15.27 74.6 5.31 38.4 6.46 11.00 48.15 18.92 21.58 14.54 21.6 21.7 20.7 21.7 85.7
Date Link Day Season Team Opp Site Final Rest Line Total SUm ATSm OUm DPS DPA SUr ATSr OUr ot
Feb 21, 1996 recap Wed 1995 Seventysixers Heat home 57-66 0&1 6.5 187.0 -9 -2.5 -64.0 -33.2 -30.8 L L U False
Dec 04, 1996 recap Wed 1996 Magic Cavaliers home 57-84 1&0 4.0 164.0 -27 -23.0 -23.0 -23.0 0.0 L L U False
Mar 25, 1997 recap Tue 1996 Cavaliers Spurs away 59-64 2&1 -6.0 167.0 -5 -11.0 -44.0 -27.5 -16.5 L L U False
Feb 27, 1998 recap Fri 1997 Trailblazers Pacers away 59-124 1&1 3.5 183.0 -65 -61.5 0.0 -30.8 30.8 L L P False
Mar 29, 1998 recap Sun 1997 Pacers Spurs home 55-74 1&1 -4.0 179.0 -19 -23.0 -50.0 -36.5 -13.5 L L U False
Feb 16, 1999 recap Tue 1998 Jazz Supersonics away 56-71 0&2 4.0 182.0 -15 -11.0 -55.0 -33.0 -22.0 L L U False
Apr 10, 1999 recap Sat 1998 Bulls Heat home 49-82 2&2 10.0 172.0 -33 -23.0 -41.0 -32.0 -9.0 L L U False
Dec 15, 2000 recap Fri 2000 Knicks Jazz home 58-89 0&1 3.0 174.0 -31 -28.0 -27.0 -27.5 0.5 L L U False
Dec 20, 2000 recap Wed 2000 Heat Pelicans away 56-65 0&3 6.0 174.0 -9 -3.0 -53.0 -28.0 -25.0 L L U False
Jan 22, 2001 recap Mon 2000 Trailblazers Cavaliers away 58-84 1&2 -6.5 190.0 -26 -32.5 -48.0 -40.2 -7.8 L L U False
Jan 27, 2001 recap Sat 2000 Magic Heat home 59-81 1&2 -2.0 183.0 -22 -24.0 -43.0 -33.5 -9.5 L L U False
Dec 18, 2001 recap Tue 2001 Heat Jazz home 56-95 2&2 -1.5 176.0 -39 -40.5 -25.0 -32.8 7.8 L L U False
Nov 16, 2002 recap Sat 2002 Nuggets Pistons away 53-74 0&0 12.5 166.0 -21 -8.5 -39.0 -23.8 -15.2 L L U 0
Jan 24, 2003 recap Fri 2002 Nuggets Celtics away 58-77 1&1 10.0 170.0 -19 -9.0 -35.0 -22.0 -13.0 L L U 0
Feb 21, 2003 recap Fri 2002 Bucks Supersonics away 58-88 1&1 -1.5 187.0 -30 -31.5 -41.0 -36.2 -4.8 L L U 0
Nov 01, 2003 recap Sat 2003 Raptors Timberwolves away 56-73 0&0 8.0 177.0 -17 -9.0 -48.0 -28.5 -19.5 L L U 0
May 03, 2004 recap Mon 2003 Nets Pistons away 56-78 7&3 5.0 172.0 -22 -17.0 -38.0 -27.5 -10.5 L L U 0
Nov 29, 2007 recap Thu 2007 Knicks Celtics away 59-104 2&1 13.0 188.0 -45 -32.0 -25.0 -28.5 3.5 L L U 0
Mar 19, 2008 recap Wed 2007 Heat Raptors away 54-96 0&1 18.5 199.0 -42 -23.5 -49.0 -36.2 -12.8 L L U 0
Oct 28, 2009 recap Wed 2009 Pelicans Celtics away 59-92 &0 10.0 183.0 -33 -23.0 -32.0 -27.5 -4.5 L L U 0
Jan 11, 2011 recap Tue 2010 Cavaliers Lakers away 57-112 1&1 15.0 200.0 -55 -40.0 -31.0 -35.5 4.5 L L U 0
Jan 21, 2011 recap Fri 2010 Hawks Pelicans home 59-100 2&1 -4.0 185.0 -41 -45.0 -26.0 -35.5 9.5 L L U 0
Mar 13, 2011 recap Sun 2010 Bucks Celtics away 56-87 0&1 8.5 180.0 -31 -22.5 -37.0 -29.8 -7.2 L L U 0
Jan 23, 2012 recap Mon 2011 Magic Celtics away 56-87 2&0 -6.0 176.0 -31 -37.0 -33.0 -35.0 2.0 L L U 0
Mar 19, 2012 recap Mon 2011 Magic Bulls home 59-85 0&1 -1.0 184.0 -26 -27.0 -40.0 -33.5 -6.5 L L U 0
Jan 14, 2013 recap Mon 2012 Hawks Bulls away 58-97 1&1 4.5 184.0 -39 -34.5 -29.0 -31.8 2.8 L L U 0

Game Parameters: after all star break, assists, ats margin, ats streak, attendance, biggest lead, blocks, conference, date, day, defensive rebounds, division, dpa, dps, fast break points, field goals attempted, field goals made, fouls, free throws attempted, free throws made, game number, lead changes, line, losses, margin, margin after the first, margin after the third, margin at the half, matchup losses, matchup wins, minutes, month, offensive rebounds, officials, opponent, opponents, ou margin, ou streak, overtime, playoffs, points, points in the paint, position, quarter scores, rebounds, rest, round, season, seed, series game, series games, series losses, series wins, site, site streak, start time, steals, streak, team, team rebounds, three pointers attempted, three pointers made, time of game, time zone, times tied, total, turnovers, wins


How to Query:

The syntax for access to the NBA team data is: game reference:parameter. To see the date, team, and opponent where the team scored +120 points after scoring +120 runs in the previous game use the SDQL: date,team,o:team@points>120 and p:points>120

The syntax for access to the NBA player data: [team:]player name:game reference:parameter. To see the date, team, opponent and number of points by Kobe Bryant in the game after he scored more than 30 use the SDQL: date,team,o:team,Kobe Bryant:points@Kobe Bryant:p:points>30

Query Fundamentals:

  A query consists of one or more clauses joined by and or or.

Examples:

  

The query:
50 < Kobe Bryant:points and site=away
returns home games where Kobe Bryant scored more than 50 points on the road.

If no player is given then results for the team are checked. E.g.
120<Bulls:points and site=home
returns games in which the Bulls scored more than 120 points at home.
points<60
returns games when the team scored fewer than 60 points.

If no conditional is imposed then the results are grouped by the reference.
points
returns games grouped by all occurrences of points.

Multiple conditions can be imposed using a comma delimited format.
points < 90,100,110
gives results grouped by points < 90, points < 100, and points < 110.

You can comma-group on both sides of the inequality as per:
70,80,90,100 < points < 90,100,110

Game Reference:

  p => team's previous game
op => opp's previous game
P => previous match up
n => team's next game
on => opp's next game
N => next match up

Examples:

   The query:
P:points < 80 and PP:points < 80
returns games where team scored fewer than 80 point the past two head-to-head match ups

The query:
2*P:points in the paint < Po:points in the paint
returns games in which the team was outscored in the paint by a factor of 2 in their previous match up.

Adding a condition on season restricts this query to same season match ups:
2*P:points in the paint < Po:points in the paint and P:season=season
returns games in which the team was outscored in the paint by a factor of 2 in their previous same season match up.

Examples:

   The query:
0.25*p:points<=p:fast break points and po:points<p:points
returns games with a team off a win in which they scored at least 25% of their points from fast breaks.

Short Cuts:

H, A, W, L, F, D, O, U, C are short cuts for home, away, win, loss, favorite, dog, over the total,under the total, and conference. As with the parameter prefixes, these can be strung together without limit.

Examples:

The query:
HF and p:HFL and pp:HFL
returns home favorites after they just lost as home favorites their last two games.

The query:
P:O and P2:O and P3:O and P4:O and P5:O and P6:O
returns games where teams have gone over the total their last six matchups.

In addition to the above single letter short cuts the following abbreviations are available:

AASB - after the all star break
ATSL - against the spread loss
ATSW - against the spread win
AST - assists
ATR - assist to turnover ratio
AWP - Away Winning Percentage
BAP - Baskets Assisted percentage
BASB - before the all star break
DDS - Double Digit Scorers
DRB - Defensive Rebounds
FBP - fast break points
FGA - field goals attempted
FGM - field goals made
FGP - field goal percentage
FTA - free throws attempted
FTM - free throws made
FTP - free throw percentage
HWP - Home Winning Percentage
LSP - Leading Scorers Points
M1 - margin after the first
M2 - margin at the half
M3 - margin after the third
ORB - Offensive Rebounds
P1 - points in the first
P2 - points in the second
P3 - points in the third
P4 - points in the fourth
PIP - points in the paint
PM - plus / minus (player level parameter)
PFT - percentage of points from free throws
PTP - percentage of points from three pointers
RB - Rebounds
S1 - points in the first
S2 - total points after the second
S3 - total points after the third
TO - turnovers
TPA - three pointers attempted
TPM - three pointers made
TPP - three point percentage
TT - Times Tied
WP - team winning percentage


support@KillerSports.com   

The information available here is believed, but not guaranteed, to be accurate, is for recreational purposes only, and is not intended to violate any state, local, or federal laws.