p: appears to be failing

[John Currey]

Hi,

This demonstrates the data is present, but p: is not reporting the previous occurrence.

https://s3.sportsdatabase.com/MLB/query.html?sdql=team%2Cdate%2Cp%3Adate%2Co%3Ateam%2Cpo%3Ateam%2Csite%2Cp%3Asite%2Cruns%2Cp%3Aruns%40team%3DGiants+and+season%3D2022&submit=++S+D+Q+L+%21++

Thanks.

[Joe Meyer]

John and SDQL API Friends,

To troubleshoot it is better to use date, which is required, rather than season, which may be missing or erroneous,

Please have a look at the results of this SDQL:

team,date,double header,site,season,runs,p:runs@team=Giants and GimmeTheDog.date>20220301

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/5cf61bb0-b4bd-4f1d-a699-ccfffa8837a9n%40googlegroups.com.

[John Currey]

Thanks Joe. It appears date, t:team, o:team, and double header are the same, and there are duplicate records. However, I've fallen in this hole previously, and I'd bet I have trailing spaces on my team names. If your best programmer is inclined to not allow me to shoot myself if the foot in the future, that would be great. I'll do my best to make sure my trailing spaces are cleaned up before submitting my data.