NBA Teams on Back to Back Query

[Trey Hoos]

I'm trying to find a way to examine trends with NBA teams on a back to back.

I'd like to know their ML and ATS records.

Ideally I'd like to also query this if they are back to back as a road team in both games, a home team in both games, a home team in game 1 and a road team in game 2, and as an road team in game 1 and home team in game 2.

[David Padilla]

team=Lakers and rest=0 just insert a different team or see a group list

team and rest=0 and season=2024

--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/sportsdatabase/e0a55acd-6341-4fad-acac-8b84c2247f61n%40googlegroups.com.

[Trey Hoos]

Does this make sense for seeing W/L straight up and ATS for teams on 0 days rest and playing on the road for both games?

R(team), S(points>o:points), S(points<o:points),S(points+line>o:points),S(points+line<o:points)@team and season>=2023 and rest=0 and away site streak=1|

[johnrya...@gmail.com]

bey Trey,

NBA B2b against the same opponent (which I presume is what you are looking for) sometimes happen on back-to-back days but not all. In fact, there have been 192 games played with 1 day of rest, 39 played with no days of rest, 3 games with 2 days of rest, and 1 game with 3 days of rest. 

The Pelicans and Kings played last night and they were on zero days fo rest.  
po:team=o:team and H and REG and p:H
https://www.gimmethedog.com/NBA?q=po%3Ateam%3Do%3Ateam%20and%20H%20and%20REG%20and%20p%3AH

OR

If you want teams playing on back-to-back nights regardless if it is the same foe or not:
Teams playing on B2B nights, coming off an upset rtoad win, priced between a 3.5 and 9.5 point favorite,. and facing a foe playing on no rest:
REG and rest=0 and H and -9.5<=line<=-3.5 and p:AWD and o:rest=0
https://www.gimmethedog.com/NBA?q=REG%20and%20rest%3D0%20and%20H%20and%20-9.5%3C%3Dline%3C%3D-3.5%20and%20p%3AAWD%20and%20o%3Arest%3D0

[Trey Hoos]

I tried using that link and I keep getting an invalid query 99 error...any thoughts?

[johnrya...@gmail.com]

Hey Trey, try copying and pasting the code I provided and make sure you are logged in.  I know they work.

[Trey Hoos]

I'm a dummy...wasn't logged in 😅

thanks!