Query Fundamentals

For more detailed information on SDQL including manuals and videos go HERE

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:

If no player is given then results for the team are checked. E.g.

Multiple conditions can be imposed using a comma delimited format.

You can comma-group on both sides of the inequality as per:

Game Reference

Examples:

return games in which the team was outscored in the paint by a factor of 2 in their previous match up

Short Cuts

H, A, W, L, F, D, O, U, C, X   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:

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

· AASB - after the all star break
· AST - assists
· ATR - assist to turnover ratio
· ATSL - against the spread loss
· ATSW - against the spread win
· AWP - Away Winning Percentage
· BAP - Baskets Assisted percentage
· BASB - before the all star break
· BL - biggest lead
· DAY - day game (start time<1700)
· 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
· LC - lead changes
· LSP - Leading Scorers Points
· M1 - margin after the first
· M2 - margin at the half
· M3 - margin after the third
· NGT - night game (start time>=1700)
· ORB - Offensive Rebounds
· OT - overtime
· P1 - points in the first
· P2 - points in the second
· P3 - points in the third
· P4 - points in the fourth
· PFT - percentage of points from free throws
· PIP - points in the paint
· PM - plus / minus (player level parameter)
· PTP - percentage of points from three pointers
· RB - Rebounds
· REG - regular season
· S1 - points in the first
· S2 - total points after the second
· S3 - total points after the third
· SG - series game
· TO - turnovers
· TOM - turnover margin
· TPA - three pointers attempted
· TPM - three pointers made
· TPP - three point percentage
· TT - Times Tied
· WP - team winning percentage

NCAAB Trend Builder