Winning Picks, Guaranteed

featuring the Sports Data Query Language

Create New Account --- or --- username password forgot password?

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

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