query-61c3fa3d22ff9705dd7cdd6f6239340f
Llista premis Oscar d'un any concret
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?premia ?premi ?premiLabel ?data ?obra ?obraLabel WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?item wdt:P166 ?premia.
?premia wdt:P31 wd:Q19020.
OPTIONAL { ?item p:P166 [ps:P166 ?premi; pq:P585 ?data; pq:P1686 ?obra] . }
filter (?premi = ?premia) #filtra instàncies d'altres premis del mateix any
filter (?data >= "2019-01-01T00:00:00Z"^^xsd:dateTime && ?data < "2020-01-01T00:00:00Z"^^xsd:dateTime)
}
LIMIT 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?data"):::projected
v4("?item"):::projected
v5("?obra"):::projected
v2("?premi"):::projected
v3("?premia"):::projected
a1((" "))
c9(["wd:Q19020"]):::iri
c4(["bd:serviceParam"]):::iri
c6(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["?data >= '2019-01-01T00:00:00Z^^xsd:dateTime'?data < '2020-01-01T00:00:00Z^^xsd:dateTime'"]]
f0 --> v1
f1[["?premi = ?premia"]]
f1 --> v2
f1 --> v3
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c4 --"wikibase:language"--> c6
end
v4 --"p:direct/P166"--> v3
v3 --"p:direct/P31"--> c9
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
a1 -."p:statement/P166".-> v2
a1 --"p:qualifier/P585"--> v1
a1 --"p:qualifier/P1686"--> v5
v4 --"p:P166"--> a1
end