query-ea1df8fc8b8c065518044f866f268fe3

rq turtle/ttl

This query returns the count of subtypes for which the supertype "award" is missing. As you see, my action (1538 science awards) is only 4th in the list: eg there are 2472 literary awards without supertype. There are also 469 "title of honor" without supertype, and I bet that some analogous to OBE are in that number.

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select (count(*) as ?c) ?typeLabel {
  ?x wdt:P31 ?type.
  ?type wdt:P279+ wd:Q618779.
  filter not exists {?x wdt:P31 wd:Q618779}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?typeLabel order by desc(?c)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?c") v3("?type") v2("?x") c2(["wd:Q618779"]):::iri c5(["bd:serviceParam"]):::iri c7(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P31"--> e0c2 e0v1("?x"):::projected e0c2(["wd:Q618779"]):::iri end f0--EXISTS--> f0e0 f0 --> v2 f0 --> c1 f0 --> c2 v2 --"wdt:P31"--> c2 v2 --"wdt:P31"--> v3 v3 --"wdt:P279"--> c2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end bind2[/"count(*)"/] bind2 --as--o v4