query-3bfac7325909d935ec6e929f90e6c767
I can group the items containing P8034 by the number of external IDs they have. Similarly, through
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT ?type (COUNT(DISTINCT ?item) AS ?count) WHERE {
?item wdt:P8034 ?id .
?item wdt:P106 ?occ .
BIND(?occ AS ?type)
}
GROUP BY ?type
ORDER BY DESC(?count)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?count")
v3("?id")
v2("?item"):::projected
v4("?occ")
v5("?type"):::projected
v2 --"wdt:P8034"--> v3
v2 --"wdt:P106"--> v4
bind0[/"?occ"/]
v4 --o bind0
bind0 --as--o v5
bind2[/"count(?item)"/]
v2 --o bind2
bind2 --as--o v6