query-af0d3cde6de9ebed1bacda2f6df601f9

rq turtle/ttl

Ceremonies by number of nominated items

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT ?ceremony ?ceremonyLabel (COUNT(DISTINCT(?item)) AS ?nominated_items) WHERE {
  ?item p:P1411 ?award_statement .
  ?award_statement pq:P805 ?ceremony
SERVICE wikibase:label {
    bd:serviceParam wikibase:language "de" .
  }
} GROUP BY ?ceremony ?ceremonyLabel ORDER BY DESC(?nominated_items)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?award_statement") v4("?ceremony"):::projected v2("?item"):::projected v5("?nominated_items") c6(["de"]):::literal c4(["bd:serviceParam"]):::iri v2 --"p:P1411"--> v3 v3 --"p:qualifier/P805"--> v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c4 --"wikibase:language"--> c6 end bind1[/"count(?item)"/] v2 --o bind1 bind1 --as--o v5