1. #1
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 4,000
    Betpoints: 8667

    SDQL Question Please

    Hello. Very new to this method and may I please ask: "What is the code to display a team's most recent games?"

    I know this code : "team and season = 2019 and site = away", but I don't know how to add only for last 2 games.

    I checked the manual, but couldn't find it.

    Was looking to see the teams stats, on the road, for only their last 2 games.

    Thanks very much.

    Roscoe

  2. #2
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7160

    team and season = 2019 and (site = away or p:site=away) this will give you the code if one of their last 2 games was an away game
    team and season = 2019 and (site = away and p:site=away) and this will combine both games as away games
    good luck

  3. #3
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 4,000
    Betpoints: 8667

    Quote Originally Posted by nash13 View Post
    team and season = 2019 and (site = away or p:site=away) this will give you the code if one of their last 2 games was an away game
    team and season = 2019 and (site = away and p:site=away) and this will combine both games as away games
    good luck
    Thank you, Nash. Appreciate the help.

  4. #4
    Getch13
    Getch13's Avatar SBR PRO
    Join Date: 07-13-18
    Posts: 6,256
    Betpoints: 67915

    NBA 1st.QT. by teams; A(P1) as '1Q PTS', A(o:P1) as 'Opp 1Q PTS', A(M1) as '1Q Margin'@team and site and season=2019

    NBA 1st Half by teams: A(P1+P2) as '1H PTS', A(o:P1+o:P2) as 'Opp 1H PTS', A(M2) as '1H Margin'@team and site and season=2019

  5. #5
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 4,000
    Betpoints: 8667

    Thank you Nash and Getch for your help. I'm getting close.

    I entered this team and season = 2019 and (site = away and p:site=away)

    and got the following output.

    It displays line stats for the last 1 away game for the Denver Nuggets and the Memphis Grizzlies.

    It displays the last 2 away games for the Suns and Thunder (which is what I was looking for)

    But then it displays the last 3 and more away games for the rest of the league.

    Can I narrow the code to display only the last 2 away games for all the teams?

    games ATS
    W - L- P (marg, %win)
    Avg Line OU
    W - L- P (marg, %over)
    Avg Total SU
    W - L (marg, %win)
    SDQL
    1 0-0-1 (0.00, 0.0%) -4.0 0-1-0 (-22.00, 0.0%) 200.0 1-0 (4.00, 100.0%) Nuggets
    1 1-0-0 (3.50, 100.0%) 1.5 1-0-0 (14.50, 100.0%) 221.5 1-0 (2.00, 100.0%) Grizzlies
    2 1-1-0 (2.50, 50.0%) 4.0 1-1-0 (1.50, 50.0%) 218.0 1-1 (-1.50, 50.0%) Suns
    2 1-1-0 (-4.25, 50.0%) 6.8 2-0-0 (22.00, 100.0%) 215.0 0-2 (-11.00, 0.0%) Thunder
    3 3-0-0 (18.33, 100.0%) -0.3 1-2-0 (-3.17, 33.3%) 227.8 3-0 (18.67, 100.0%) Timberwolves
    3 3-0-0 (9.17, 100.0%) 9.8 0-3-0 (-5.83, 0.0%) 217.8 1-2 (-0.67, 33.3%) Knicks
    3 2-1-0 (4.33, 66.7%) -2.7 2-1-0 (-4.67, 66.7%) 217.0 2-1 (7.00, 66.7%) Pacers
    3 0-3-0 (-9.17, 0.0%) 0.5 1-2-0 (-8.00, 33.3%) 218.3 0-3 (-9.67, 0.0%) Pistons
    3 0-3-0 (-6.17, 0.0%) 8.2 3-0-0 (18.50, 100.0%) 231.8 0-3 (-14.33, 0.0%) Pelicans
    3 1-2-0 (1.00, 33.3%) 0.7 1-2-0 (-4.00, 33.3%) 219.0 1-2 (0.33, 33.3%) Mavericks
    4 3-1-0 (3.62, 75.0%) 2.4 2-2-0 (-2.12, 50.0%) 219.4 2-2 (1.25, 50.0%) Bulls
    4 0-4-0 (-11.62, 0.0%) -6.4 3-1-0 (10.50, 75.0%) 228.2 1-3 (-5.25, 25.0%) Clippers
    4 1-3-0 (-3.25, 25.0%) 5.0 2-2-0 (-10.25, 50.0%) 218.0 1-3 (-8.25, 25.0%) Heat
    4 2-2-0 (-3.25, 50.0%) 8.2 2-2-0 (-1.00, 50.0%) 215.5 1-3 (-11.50, 25.0%) Cavaliers
    5 4-1-0 (9.40, 80.0%) 4.8 2-3-0 (-13.10, 40.0%) 218.5 3-2 (4.60, 60.0%) Raptors
    5 3-2-0 (0.90, 60.0%) 4.5 3-2-0 (0.80, 60.0%) 207.2 1-4 (-3.60, 20.0%) Magic
    5 2-2-1 (-8.10, 50.0%) -2.9 1-4-0 (-4.00, 20.0%) 234.8 2-3 (-5.20, 40.0%) Rockets
    5 3-2-0 (0.80, 60.0%) -0.2 3-2-0 (9.70, 60.0%) 222.5 2-3 (1.00, 40.0%) Spurs
    5 1-4-0 (-8.50, 20.0%) 1.5 2-3-0 (-1.20, 40.0%) 212.4 1-4 (-10.00, 20.0%) Jazz
    5 2-3-0 (0.30, 40.0%) -5.3 1-4-0 (-4.60, 20.0%) 222.2 5-0 (5.60, 100.0%) Lakers
    5 5-0-0 (6.20, 100.0%) 4.6 2-3-0 (-1.20, 40.0%) 218.4 2-3 (1.60, 40.0%) Kings
    6 3-3-0 (-0.75, 50.0%) -1.2 1-4-1 (0.00, 20.0%) 215.5 2-4 (0.50, 33.3%) Seventysixers
    6 2-4-0 (3.25, 33.3%) -6.4 3-3-0 (7.25, 50.0%) 224.1 5-1 (9.67, 83.3%) Bucks
    6 3-2-1 (-2.42, 60.0%) 4.6 3-2-1 (2.50, 60.0%) 222.5 2-4 (-7.00, 33.3%) Nets
    6 2-4-0 (-10.17, 33.3%) 11.5 5-1-0 (14.08, 83.3%) 225.6 1-5 (-21.67, 16.7%) Hawks
    7 5-2-0 (7.14, 71.4%) 8.9 5-2-0 (11.86, 71.4%) 231.3 3-4 (-1.71, 42.9%) Wizards
    7 3-4-0 (-6.14, 42.9%) 7.6 4-3-0 (-8.29, 57.1%) 224.3 2-5 (-13.71, 28.6%) Hornets
    7 6-1-0 (7.57, 85.7%) -0.4 2-5-0 (-9.00, 28.6%) 215.3 4-3 (8.00, 57.1%) Celtics
    8 6-2-0 (1.62, 75.0%) 9.5 5-3-0 (0.62, 62.5%) 220.5 2-6 (-7.88, 25.0%) Warriors
    9 5-4-0 (-0.28, 55.6%) 3.1 4-5-0 (-1.67, 44.4%) 226.3 3-6 (-3.33, 33.3%) Trailblazers
    Showing 1 to 30 of 30 entries

  6. #6
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7160

    it summarizes them as instances on a seasonal basis.
    the number 9 on the trailblazers tells you that they played 9 times a game back2back on the road so far.
    i will look into the code later when i am back home

  7. #7
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 4,000
    Betpoints: 8667

    Quote Originally Posted by nash13 View Post
    it summarizes them as instances on a seasonal basis.
    the number 9 on the trailblazers tells you that they played 9 times a game back2back on the road so far.
    i will look into the code later when i am back home
    Thank you.

  8. #8
    Getch13
    Getch13's Avatar SBR PRO
    Join Date: 07-13-18
    Posts: 6,256
    Betpoints: 67915

    Roscoe this group may help you as well.

    https://groups.google.com/forum/#!forum/sportsdatabase

  9. #9
    Roscoe_Word
    Roscoe_Word's Avatar Become A Pro!
    Join Date: 02-28-12
    Posts: 4,000
    Betpoints: 8667

    Quote Originally Posted by Getch13 View Post
    Roscoe this group may help you as well.

    https://groups.google.com/forum/#!forum/sportsdatabase
    Thanks, Getch.

Top