query-c3e4ff06d1a12cf451dc85936ad895fe
Winners of categories film was nominated for
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?award (GROUP_CONCAT(DISTINCT(?nominee)) AS ?nominees) ?winner_film (GROUP_CONCAT(DISTINCT(?winner)) AS ?winners) WHERE {
wd:Q658041 p:P1411 ?award_statement .
?award_statement v:P1411 ?award .
?award wdt:P31 wd:Q19020 .
?award_statement pq:P805 ?ceremony .
?award_statement pq:P2453 ?nominee .
?winner_film p:P166 ?winner_statement .
?winner_statement v:P166 ?award .
?winner_statement pq:P805 ?ceremony .
?winner_statement pq:P1346 ?winner
}
GROUP BY ?award_statement ?award ?winner_film
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?award"):::projected
v1("?award_statement")
v3("?ceremony")
v4("?nominee"):::projected
v8("?nominees")
v7("?winner"):::projected
v5("?winner_film"):::projected
v6("?winner_statement")
v9("?winners")
c5(["wd:Q19020"]):::iri
c1(["wd:Q658041"]):::iri
c1 --"p:P1411"--> v1
v1 --"p:statement/P1411"--> v2
v2 --"p:direct/P31"--> c5
v1 --"p:qualifier/P805"--> v3
v1 --"p:qualifier/P2453"--> v4
v5 --"p:P166"--> v6
v6 --"p:statement/P166"--> v2
v6 --"p:qualifier/P805"--> v3
v6 --"p:qualifier/P1346"--> v7
bind2[/"?nominee"/]
v4 --o bind2
bind2 --as--o v8
bind3[/"?winner"/]
v7 --o bind3
bind3 --as--o v9