S p o r t s D a t a B a s e . c o m
a sports data query language (SDQL ©) consultancy

Permission is given to quote trends found on SportsDataBase.com provided that a reference and a link to SportsDataBase.com is provided. E.g.: Trend found on SportsDataBase.com


Winning Picks, Guaranteed

NBA SDQL Access

Enter your SDQL in the text box below and click the query button when finished.

team=Hornets and season=2009
SU: 37-45 (-2.5)
ATS: 35-44-3 (-0.6) avg line: 1.9
O/U: 42-39-1 (2.1) avg total: 200.8
Q1Q2Q3Q4Final
Team:   24.6     24.8     25.2     24.8     100.2
Opp:   26.5     26.6     24.3     24.6     102.7
Field GoalsThreesFree ThrowsBlocksO RbndsRbndsFoulsAssistsTrnOvrs
Team:38.8-83.4 (46.6%)7.0-19.2 (36.2%)15.8-20.3 (77.0%)3.610.440.219.622.312.8
Opp:39.6-82.1 (48.5%)6.6-18.5 (35.2%)16.9-22.5 (75.1%)4.510.642.219.523.513.8
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20091028 Hornets Spurs away 96-113 -&- 50-52 +9 +186' -17 -8.0 22.5 7.2 15.2 L L O
20091030 Hornets Kings home 97-92 1&1 45-37 -11' +200 5 -6.5 -11.0 -8.8 -2.2 W L U
20091101 Hornets Celtics away 87-97 1&1 41-53 +10' +184' -10 0.5 -0.5 0.0 -0.5 L W U
20091102 Hornets Knicks away 111-117 0&1 48-46 -3 +205 -6 -9.0 23.0 7.0 16.0 L L O
20091104 Hornets Mavericks home 114-107 1&0 50-45 -4 +189' 7 3.0 31.5 17.2 14.2 W W O 1
20091106 Hornets Raptors home 90-107 1&1 48-50 -4' +207 -17 -21.5 -10.0 -15.8 5.8 L L U
20091108 Hornets Lakers away 88-104 1&1 36-46 +6 +201' -16 -10.0 -9.5 -9.8 0.2 L L U
20091109 Hornets Clippers away 112-84 0&1 50-43 -1 +194' 28 27.0 1.5 14.2 -12.8 W W O
20091111 Hornets Suns away 104-124 1&1 44-55 +6' +215' -20 -13.5 12.5 -0.5 13.0 L L O
20091113 Hornets Trailblazers home 78-86 1&1 36-37 +3 +188 -8 -5.0 -24.0 -14.5 -9.5 L L U
20091114 Hornets Hawks away 98-121 0&0 43-54 +12 +200' -23 -11.0 18.5 3.8 14.8 L L O
20091117 Hornets Clippers home 110-102 2&1 45-47 -1' +192 8 6.5 20.0 13.2 6.8 W W O
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20091119 Hornets Suns home 110-103 1&1 40-45 +7 +216' 7 14.0 -3.5 5.2 -8.8 W W U
20091121 Hornets Hawks home 96-88 1&0 43-37 +5 +203' 8 13.0 -19.5 -3.2 -16.2 W W U
20091122 Hornets Heat away 101-102 0&1 39-52 +9' +194 -1 8.5 9.0 8.8 0.2 L W O
20091125 Hornets Bucks home 102-99 2&1 36-39 -3 +201' 3 0.0 -0.5 -0.2 -0.2 W P U 1
20091129 Hornets Kings away 96-112 3&1 46-53 +3 +210 -16 -13.0 -2.0 -7.5 5.5 L L U
20091201 Hornets Lakers away 99-110 1&1 47-52 +14' +202 -11 3.5 7.0 5.2 1.8 L W O
20091204 Hornets Timberwolves home 98-89 2&1 50-42 -9' +200 9 -0.5 -13.0 -6.8 -6.2 W L U
20091208 Hornets Kings home 96-94 3&1 50-50 -8' +209' 2 -6.5 -19.5 -13.0 -6.5 W L U
20091209 Hornets Timberwolves away 97-96 0&0 46-52 -3 +196' 1 -2.0 -3.5 -2.8 -0.8 W L U
20091211 Hornets Knicks home 96-113 1&3 40-55 -6' +208 -17 -23.5 1.0 -11.2 12.2 L L O
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20091214 Hornets Mavericks away 90-94 2&1 43-55 +8' +198 -4 4.5 -14.0 -4.8 -9.2 L W U
20091216 Hornets Pistons home 95-87 1&0 49-45 -5 +189' 8 3.0 -7.5 -2.2 -5.2 W W U
20091218 Hornets Nuggets home 98-92 1&1 48-46 0 +202' 6 6.0 -12.5 -3.2 -9.2 W W U
20091220 Hornets Raptors away 92-98 1&1 38-47 +2 +204' -6 -4.0 -14.5 -9.2 -5.2 L L U
20091223 Hornets Warriors home 108-102 2&0 41-47 -10 +214 6 -4.0 -4.0 -4.0 0.0 W L U
20091226 Hornets Bulls away 85-96 2&3 41-46 +2 +190 -11 -9.0 -9.0 -9.0 0.0 L L U
20091229 Hornets Rockets away 100-108 2&1 50-48 +5' +193' -8 -2.5 14.5 6.0 8.5 L L O
20091230 Hornets Heat home 95-91 0&2 43-41 -1' +191' 4 2.5 -5.5 -1.5 -4.0 W W U
20100102 Hornets Rockets home 99-95 2&1 44-48 -2' +194 4 1.5 0.0 0.8 -0.8 W W P
20100104 Hornets Jazz away 91-87 1&1 43-37 +8 +196' 4 12.0 -18.5 -3.2 -15.2 W W U
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20100106 Hornets Thunder away 97-92 1&1 49-44 +4' +192 5 9.5 -3.0 3.2 -6.2 W W U
20100108 Hornets Nets home 103-99 1&1 46-44 -10 +191 4 -6.0 11.0 2.5 8.5 W L O
20100110 Hornets Wizards away 115-110 1&1 52-57 -1 +198 5 4.0 27.0 15.5 11.5 W W O
20100111 Hornets Seventysixers away 92-96 0&1 40-41 +2 +199 -4 -2.0 -11.0 -6.5 -4.5 L L U
20100113 Hornets Clippers home 108-94 1&0 51-40 -7' +192' 14 6.5 9.5 8.0 1.5 W W O
20100115 Hornets Pistons away 104-110 1&2 48-45 -2 +192 -6 -8.0 22.0 7.0 15.0 L L O 1
20100116 Hornets Pacers away 101-96 0&0 42-43 +2 +208' 5 7.0 -11.5 -2.2 -9.2 W W U
20100118 Hornets Spurs home 90-97 1&1 45-42 0 +189 -7 -7.0 -2.0 -4.5 2.5 L L U
20100120 Hornets Grizzlies home 113-111 1&1 55-52 -3' +203' 2 -1.5 20.5 9.5 11.0 W L O
20100122 Hornets Timberwolves away 96-94 1&1 43-47 -3' +201 2 -1.5 -11.0 -6.2 -4.8 W L U
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20100123 Hornets Nuggets away 110-116 0&1 45-44 +11 +207 -6 5.0 19.0 12.0 7.0 L W O 1
20100125 Hornets Trailblazers away 98-97 1&1 51-47 +2' +189 1 3.5 6.0 4.8 1.2 W W O
20100127 Hornets Warriors away 123-110 1&0 52-50 -2 +215 13 11.0 18.0 14.5 3.5 W W O
20100129 Hornets Bulls home 106-108 1&1 39-45 -4' +197 -2 -6.5 17.0 5.2 11.8 L L O 1
20100130 Hornets Grizzlies away 109-102 0&0 47-43 +6 +204 7 13.0 7.0 10.0 -3.0 W W O 1
20100201 Hornets Suns home 100-109 1&0 45-51 -1 +210 -9 -10.0 -1.0 -5.5 4.5 L L U
20100203 Hornets Thunder home 99-103 1&0 45-57 +2 +192' -4 -2.0 9.5 3.8 5.8 L L O
20100205 Hornets Seventysixers home 94-101 1&1 46-48 -2 +194' -7 -9.0 0.5 -4.2 4.8 L L O
20100206 Hornets Bobcats away 104-99 0&2 50-48 +8' +191 5 13.5 12.0 12.8 -0.8 W W O
20100208 Hornets Magic away 117-123 1&0 51-54 +9 +194' -6 3.0 45.5 24.2 21.2 L W O
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20100210 Hornets Celtics home 93-85 1&2 45-47 +4' +191 8 12.5 -13.0 -0.2 -12.8 W W U
20100217 Hornets Jazz home 90-98 6&0 38-54 +4 +201' -8 -4.0 -13.5 -8.8 -4.8 L L U
20100219 Hornets Pacers home 107-101 1&1 46-43 -4 +205' 6 2.0 2.5 2.2 0.2 W W O
20100221 Hornets Rockets home 102-94 1&0 43-43 -2 +201 8 6.0 -5.0 0.5 -5.5 W W U
20100223 Hornets Cavaliers away 95-105 1&1 50-48 +11' +199 -10 1.5 1.0 1.2 -0.2 L W O
20100224 Hornets Bucks away 95-115 0&1 42-52 +6 +194 -20 -14.0 16.0 1.0 15.0 L L O
20100226 Hornets Magic home 100-93 1&1 48-49 +4' +201 7 11.5 -8.0 1.8 -9.8 W W U
20100228 Hornets Mavericks away 100-108 1&1 44-51 +8 +199' -8 0.0 8.5 4.2 4.2 L P O
20100301 Hornets Spurs home 92-106 0&0 45-50 +2' +195 -14 -11.5 3.0 -4.2 7.2 L L O
20100303 Hornets Grizzlies home 100-104 1&1 50-49 -2 +203 -4 -6.0 1.0 -2.5 3.5 L L O
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20100305 Hornets Spurs away 91-102 1&3 49-53 +8 +197' -11 -3.0 -4.5 -3.8 -0.8 L L U
20100308 Hornets Warriors home 135-131 2&1 58-58 -6 +215 4 -2.0 51.0 24.5 26.5 W L O
20100310 Hornets Thunder away 83-98 1&2 43-46 +7' +202 -15 -7.5 -21.0 -14.2 -6.8 L L U
20100312 Hornets Nuggets home 95-102 1&1 41-46 +5 +210 -7 -2.0 -13.0 -7.5 -5.5 L L U
20100314 Hornets Suns away 106-120 1&1 46-57 +10 +215 -14 -4.0 11.0 3.5 7.5 L L O
20100315 Hornets Clippers away 108-100 0&1 56-43 +2' +204 8 10.5 4.0 7.2 -3.2 W W O
20100317 Hornets Warriors away 121-131 1&1 51-54 +3' +228 -10 -6.5 24.0 8.8 15.2 L L O
20100318 Hornets Nuggets away 80-93 0&1 42-40 +14 +217 -13 1.0 -44.0 -21.5 -22.5 L W U
20100320 Hornets Jazz away 86-106 1&0 43-55 +10 +212 -20 -10.0 -20.0 -15.0 -5.0 L L U
20100322 Hornets Mavericks home 115-99 1&1 54-51 +4' +203 16 20.5 11.0 15.8 -4.8 W W O
DateTeamOppSiteFinalRestFG%LineTotalSUmATSmOUmDPSDPASUrATSrOUrot
20100324 Hornets Cavaliers home 92-105 1&2 44-57 +6 +201' -13 -7.0 -4.5 -5.8 1.2 L L U
20100327 Hornets Trailblazers home 101-112 2&1 58-57 +3' +194 -11 -7.5 19.0 5.8 13.2 L L O
20100329 Hornets Lakers home 108-100 1&1 49-41 +5' +201' 8 13.5 6.5 10.0 -3.5 W W O
20100331 Hornets Wizards home 91-96 1&0 48-55 -9' +197' -5 -14.5 -10.5 -12.5 2.0 L L U
20100402 Hornets Grizzlies away 96-107 1&1 44-44 +3' +205' -11 -7.5 -2.5 -5.0 2.5 L L U
20100403 Hornets Nets away 87-115 0&2 39-58 -2' +201' -28 -30.5 0.5 -15.0 15.5 L L O
20100407 Hornets Bobcats home 103-104 3&0 48-48 +1 +191' -1 0.0 15.5 7.8 7.8 L P O
20100409 Hornets Jazz home 103-114 1&1 49-55 +7' +210' -11 -3.5 6.5 1.5 5.0 L L O
20100411 Hornets Timberwolves home 114-86 1&1 52-39 -5' +212' 28 22.5 -12.5 5.0 -17.5 W W U
20100414 Hornets Rockets away 123-115 2&1 63-54 +7 +216 8 15.0 22.0 18.5 3.5 W W O

Query Fundamentals:

  A query consists of one or more clauses joined by and or or.
The full format for reference to the SportsDataBase is team name:player name:game reference:parameter.

Examples:

  

The query:
25 < Suns:Leandro Barbosa:p:minutes and site=home
returns home games where the Suns' Barbosa played more than 25 minutes in the Suns' previous game.

If no player is given then results for the team are checked. E.g.
Bulls:p:points < 100 and 0 < line
returns games in which the Bulls are dogs after the scoring fewer than 100 points.

If no team is given then results for any team are checked.
p:points < 100
returns games after teams scored fewer than 100 points.

If no game reference is given then results for the current game are checked.
points < 100
returns games in which teams scored fewer than 100 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 also use 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.

Parameters:

  Prest, 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, line, losses, margin, margin after the first, margin after the third, margin at the half, minutes, month, name, next game, next match up, offensive rebounds, officials, opponents, ou margin, ou streak, overtime, playoffs, points, points in the paint, position, previous game, previous match up, quarter scores, rebounds, rest, round, season, seed, series game, series games, series losses, series wins, site, site streak, stats, steals, streak, team, team rebounds, three pointers attempted, three pointers made, time of game, time zone, total, turnovers, wins

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 prefixex, these can be strung together without limit.

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

M1 - margin after the first
M2 - margin at the half
M3 - margin after the third
P1 - points in the first
P2 - points in the second
P3 - points in the third
P4 - points in the fourth
S1 - points in the first
S2 - total points after the second
S3 - total points after the third
FGA - field goals attempted
FGM - field goals made
FTA - free throws attempted
FTM - free throws made
TPA - three pointers attempted
TPM - three pointers made
FGP - field goal percentage
TPP - three point percentage
FTP - free throw percentage
PFT - percentage of points from free throws
PTP - percentage of points from three pointers
WP - team winning percentage
TO - turnovers
AST - assists

e-mail links:   Content@SportsDataBase.com    Support@SportsDataBase.com   
Content for this is generated using the Sports Data Query Language (SDQL).
Google Groups
Subscribe to SportsDataBase
Email:
Visit this group