query-c76e4b18e4782777bf2f6237f048b233

rq turtle/ttl

member of sports team (P54), but no occupation (P106)When going through a series of basketball players, I noticed that some items have P54, but no P106. This seems to be fairly frequent:

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT (COUNT(DISTINCT ?item) as ?ct)
{
    ?item wdt:P54 [] .
    FILTER NOT EXISTS { ?item wdt:P106 [] }
}

Query found at

https://www.wikidata.org/wiki/Wikidata_talk:WikiProject_Sports

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?ct") v1("?item"):::projected a2((" ")) a1((" ")) f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P106"--> e0a1 e0v1("?item"):::projected e0a1((" ")):::projected end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> a1 v1 --"wdt:P106"--> a1 v1 --"wdt:P54"--> a2 bind2[/"count(?item)"/] v1 --o bind2 bind2 --as--o v2