query-1f615072ab4e142539dfeff66fb54b4e
title:Booker Prize nominations that don't specify longlist or shortlist SELECT ?item ?itemLabel ?awardLabel ?time1 WHERE { VALUES ?award{wd:Q160082 wd:Q2052291} ?item p:P1411 ?s. ?s ps:P1411 ?award . ?s pq:P585 ?time1. FILTER (?award = wd:Q160082|| YEAR(?time1) > 2014) MINUS {?s pq:P1552 []} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } } ORDER BY ?itemLabel
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
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#>
#title:Booker Prize nominations that don't specify longlist or shortlist
SELECT ?item ?itemLabel ?awardLabel ?time1 WHERE {
VALUES ?award{wd:Q160082 wd:Q2052291}
?item p:P1411 ?s. ?s ps:P1411 ?award .
?s pq:P585 ?time1. FILTER (?award = wd:Q160082|| YEAR(?time1) > 2014)
MINUS {?s pq:P1552 []}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} ORDER BY ?itemLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?award")
v4("?item"):::projected
v1("?itemLabel"):::projected
v5("?s")
v3("?time1"):::projected
a1((" "))
c8(["bd:serviceParam"]):::iri
c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["(?award = 'wd:Q160082' || year-from-dateTime(?time1) > '2014^^xsd:integer')"]]
f0 --> v4
f0 --> v3
bind1[/VALUES ?award/]
bind1-->v4
bind10(["wd:Q160082"])
bind10 --> bind1
bind11(["wd:Q2052291"])
bind11 --> bind1
v4 --"p:P1411"--> v5
v5 --"p:statement/P1411"--> v4
v5 --"p:qualifier/P585"--> v3
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v5 --"p:qualifier/P1552"--> a1
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end