query-34aec1ec49770bc1bb94fccda9c47678
Dates with applied filters
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 bd: <http://www.bigdata.com/rdf#>
#title:Mappa dei luoghi di nascita degli autori italiani morti nel 1952
#defaultView:Map{ "markercluster": true}
SELECT DISTINCT ?autore ?autoreLabel ?autoreDescription ?datanascita ?datamorte ?luogonascita ?luogonascitaLabel ?coord
WHERE {
?autore wdt:P27 ?p ; wdt:P570 ?datamorte ; ?id [] . VALUES ?p { wd:Q172579 wd:Q38 } . VALUES ?id { wdt:P214 wdt:P396 } .
FILTER ("1951-12-31"^^xsd:date < ?datamorte && ?datamorte < "1953-01-01"^^xsd:dat)
OPTIONAL { ?autore wdt:P569 ?datanascita } .
OPTIONAL { ?autore wdt:P19 ?luogonascita . ?luogonascita wdt:P625 ?coord } .
SERVICE wikibase:label { bd:serviceParam wikibase:language "it,en". }
}
Query found at
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/Queries
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/sandbox
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?autore"):::projected
v7("?coord"):::projected
v1("?datamorte"):::projected
v5("?datanascita"):::projected
v5("?id")
v6("?luogonascita"):::projected
v5("?p")
a1((" "))
c9(["bd:serviceParam"]):::iri
c11(["it,en"]):::literal
f0[["'1951-12-31^^xsd:date' < ?datamorte?datamorte < s1953-01-01^^<http://www.w3.org/2001/XMLSchema#dat>'"]]
f0 --> v1
v2 --"wdt:P27"--> v5
v2 --"wdt:P570"--> v1
v2 -->v5--> a1
bind1[/VALUES ?p/]
bind1-->v5
bind10(["wd:Q172579"])
bind10 --> bind1
bind11(["wd:Q38"])
bind11 --> bind1
bind2[/VALUES ?id/]
bind2-->v5
bind20(["wdt:P214"])
bind20 --> bind2
bind21(["wdt:P396"])
bind21 --> bind2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P569".-> v5
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P19".-> v6
v6 --"wdt:P625"--> v7
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end