p: and n: issue

[John Currey]

Hi,

On this, notice the previous series game is correct, yet, strangely when it gets to the next series, p:series game mysteriously fails. 

• date,team,o:team,series game,p:series game@team=Devils and PO and season=2022

https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Cteam%2Cseries+game%2Cp%3Aseries+game%40team%3DDevils+and+playoffs%3D1+and+season%3D2022&submit=++S+D+Q+L+%21++

Same on the next series game:

• date,team,series game,n:series game@team=Devils and playoffs=1 and season=2022

https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Cteam%2Cseries+game%2Cn%3Aseries+game%40team%3DDevils+and+playoffs%3D1+and+season%3D2022&submit=++S+D+Q+L+%21++

Also, this one is very strange. The None values are incorrect:

• date,team,o:team,series game,po:team,p6o:team@team=Devils and playoffs=1 and season=2022

https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Cteam%2Co%3Ateam%2Cseries+game%2Cpo%3Ateam%2Cp6o%3Ateam%40team%3DDevils+and+playoffs%3D1+and+season%3D2022&submit=++S+D+Q+L+%21++

Thanks

[Joe Meyer]

John and SDQL API Friends,

It looks like there are two games entered for the Devils on 20230503 and one of them does not have the ‘season’ parameter set.

To see this erroneous game you can use the SDQL:

date,team,series game,p:series game,playoffs,p:team,season@team=Devils and date>20230417

Best regards,

Joe Meyer

Sports Database LLC

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/156ca7dd-1c07-495a-a37e-ba96afdf7064n%40googlegroups.com.

[John Currey]

Shoot, I hate it when it's my fault! Sorry, thanks!