query-e06669175869fcb89fd6095284c0c724
date of death (P570), date of birth (P569), spouse (P26): Properties 11:06, 8 August 2016 (UTC) Jura--- Maybe it helps you get started. What could help is to compare the dates before checking precision.
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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item WHERE
{
?item wdt:P26 ?item2 .
?item wdt:P569 ?d1 .
?item2 wdt:P570 ?d2 .
FILTER (?d1 > ?d2)
?item p:P569/psv:P569 [ wikibase:timeValue ?birth1 ; wikibase:timePrecision "11"^^xsd:integer ] .
?item2 p:P570/psv:P570 [ wikibase:timeValue ?death2 ; wikibase:timePrecision "11"^^xsd:integer ] .
FILTER (?birth1 > ?death2)
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?birth1")
v3("?d1")
v4("?d2")
v2("?death2")
v5("?item"):::projected
v6("?item2")
a2((" "))
a1((" "))
a4((" "))
a3((" "))
c6(["11^^xsd:integer"]):::literal
f0[["?birth1 > ?death2"]]
f0 --> v1
f0 --> v2
f1[["?d1 > ?d2"]]
f1 --> v3
f1 --> v4
v5 --"p:direct/P26"--> v6
v5 --"p:direct/P569"--> v3
v6 --"p:direct/P570"--> v4
a1 --"wikibase:timeValue"--> v1
a1 --"wikibase:timePrecision"--> c6
v5 --"p:P569"--> a2
a2 --"p:statement/value/P569"--> a1
a3 --"wikibase:timeValue"--> v2
a3 --"wikibase:timePrecision"--> c6
v6 --"p:P570"--> a4
a4 --"p:statement/value/P570"--> a3