I was trying to get a query to validate some of the angles which PROF from the other side has put up.
I don't know if there is something to indicate the length of a game in the SDQL, but I did run these, and while the results are VERY good, they aren't close to what he came up with.
line<0 and rest<2 and n:rest<2 and pvertime>0 and p:W
SU: 92-67 (2.1)
ATS: 48-107-4 (-3.7) avg line: -5.8
O/U: 84-72-3 (1.3) avg total: 193.5
line<0 and rest<2 and n:rest<2 and pvertime>0 and p:W and p:site=home
SU: 42-32 (1.7)
ATS: 23-50-1 (-3.9) avg line: -5.7
O/U: 41-30-3 (1.2) avg total: 192.9
for my query, specifying that the last game was home or away doesn't seem to matter much, since changing the last site to away
SU: 50-35 (2.4)
ATS: 25-57-3 (-3.5) avg line: -5.9
O/U: 43-42-0 (1.3) avg total: 194.0
I'll still take a 68+% result going back over multiple years ANY time.
And, it has not had a losing season in the years in the database.
2008 5-12
2007 2-12
2006 8-13
2005 8-18
2004 8-20
2003 6-12
2002 11-20
But, as others are pointing out, this is UTA at home, and the NYK. So, reasons to be concerned.
Can you run some of the queries with the next game as a 10+ point favorite and see what happens to the numbers??