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:
The query:
50 < Kobe Bryant : points
and
site = away
The explain:
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.
The query:
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
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
N :
next match up
on :
opponent's next game
P :
previous match up
S :
starter's previous match up start
n :
team's next game
s :
starter's previous start
op :
opponent's previous game
Examples:
The query:
100 < t:rushing yards
and
to:rushing yards < 100
The explain:
Use this SDQL to see how teams do when rushing for more than 100 yards while holding their opponent to few than 100 yards
The query:
40 < p:points
and
40 < p2:points
and
40 < p3:points
and
40 < p4:points
Use this SDQL to see how teams do after scoring more than 40 points their last four games
2*P:points in the paint < Po:points in the paint
and
P:season = season
return games in which the team was outscored in the paint by a factor of 2 in their previous match up
The query:
0.25*p:points<=p:fast break points
and
po:points
The explain:
return 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, 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:
The query:
HF
×
and
p:HFL
×
and
pp:HFL
×
The explain:
returns home favorites after they just lost as home
favorites their last two games
P:O
×
and
PP:O
×
and
PPP:O
×
and
PPPP:O
×
and
PPPPP:O
×
and
PPPPPP:O
×
The explain:
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 All-Star Break · AWP - Away Winning Percentage · BASB - Before All-Star Break · BL - Biggest Lead · BPRA - Bull Pen Runs Allowed · BS - Bad Start (4 or fewer innings and 5 or more earned runs) · DAY - Day (start time<1800) · DDP - Defensive Double Plays · DIV - Divisional Game · FGS - First Game of a Series · HPR - Hits Per Run · HPU - Home Plate Umpire · HR - Home Runs · HWP - Home Winning Percentage · IL - Innings Led · IT - Innings Tied · LGS - Last Game of a Series · LOB - Left on Base · MRI - Multiple Run Innings · NDIV - Not a Divisional Game · NGT - Night (start time>=1800) · NQS - Non Quality Start · ODP - Offensive Double Plays (hit into double plays) · PBRS - Percent Base Runners Scored · PO - During the Playoffs · PU - Pitchers Used · QS - Quality Start (at least 6 innings and 3 or fewer earned runs) · REG - During the Regular Season · RG3 - Rubber Game 3 (3rd game of a 3 game series and they split the first 2) · RMAX - The maximum runs the team scored in any one inning · SERA - Starter Earned Run Average in the Referenced Game · SF - Scored First: How many runs a team scored before their opponent scored · SG - Series Game · SGS - Series Games · SHA - Starter Hits Allowed · SHF - Starter Hitters Faced · SHRA - Starter Home Runs Allowed · SII - Scored In Innings · SIP - Starter Innings Pitched · SO - Strikeouts · SOPW - Strikeouts Per Walk · SPB - Strike Per Ball · SPPH - Starter Pitch Per Hitter · SPT - Starter Pitches Thrown · SRA - Starter Runs Allowed · SSO - Starter Strike Outs · SSPB - Starter Strike Per Ball · STDHPR - Season To Date Hits Per Run · STDSERA - Starter Season To Date ERA · STDSOPW - Season To Date Stike Outs Per Walk · STDSPB - Season To Date Stikes Per Ball · STDSSOPW - Starter Season To Date Stike Outs Per Walk · STDSSPB - Starter Season To Date Stikes Per Ball · STDSWHIP - Starter Season To Date WHIP · STL - Starter Throws Left · STR - Starter Throws Right · SWA - Starter Walks Allowed · SWHIP - Starter Walks Plus Hits Per Inning Pitched · TLOB - Team Left On Base · TT - Times Tied · WOW - Walk Off Win · WP - Winning Percentage · XBH - eXtra Base Hits (doubles + triples)
MLB Trend Builder
For a more detailed review of how to use the Trend Builder, go HERE
