League wide W/L record of games where the team didn't have their starter

[Saje]

Trying to see W/L record of games where the team didn't have their starter. 

Individual team records are simple. 

KIllerSports:
Ja Morant:minutes=0 and team=Mavericks and season=2021 

(MEM was impressive without him in 2021)

Wondering if can use this same concept for league wide. 

I tried this to no avail, it must be something simple I'm sure.

GimmeTheDog:

S(W),S(L),Player:list:minutes[:5]=0 @team and season=2021

S(W),S(L),date,team,o:team,Player:list:minutes[:5]@season>=2023 and len([*filter(lambda x:x=0, Player:list:minutes[:5])])<=1

[Joe Meyer]

SDQL Friends,

To see how NBA teams have done this season when their starting 5 was not the same as in their previous game, use the SDQL: 

S(W),S(L),R(team)@Player:list:name[:5]!=p:Player:list:name[:5] and team and  season=2023|

https://sportsdatabase.com/NBA/query.html?sdql=S%28W%29%2CS%28L%29%2CR%28team%29%40Player%3Alist%3Aname%5B%3A5%5D%3Dp%3APlayer%3Alist%3Aname%5B%3A5%5D+and+team+and++season%3D2023%7C&submit=++S+D+Q+L+%21++

Best regards,

Joe Meyer

SDQL.com

Eyeball Communications.com

 

--
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 on the web visit https://groups.google.com/d/msgid/sportsdatabase/3f207875-82bd-4ba8-85a6-457511912c73n%40googlegroups.com.

[Saje]

Is it possible to key in on games when All Star type starters miss (Ex.Joel Embiid), rather than when any run of the mill starters miss (Ex. Tobias Harris).

I was thinking usage percantage could possibly be utilized, could filter games where only starters of usage percentage>24% miss the game.(Jimmy Butler has a 24.5% usage percentage so using him as a baseline)

Example: Joel Embiid has a 39% Usage percentage compared to Tobias 20%. So the sdql will only show games that an all star type player (Embiid) with a usage percantage>24% missed.