query-8ec74380a78efa54806dbb046ad8c4f7
Osoby s NKC, které se narodily poté, co zemřely
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
select ?item ?datnar ?datumr where {
?item wdt:P691 [] .
?item p:P569 [ps:P569 ?datnar ; psv:P569/wikibase:timePrecision ?p1 ; wikibase:rank ?r1 ]
filter(?p1 > 8 && ?r1 != wikibase:DeprecatedRank) .
?item p:P570 [ps:P570 ?datumr ; psv:P570/wikibase:timePrecision ?p2 ; wikibase:rank ?r2 ]
filter(?p2 > 8 && ?r2 != wikibase:DeprecatedRank && (?datumr - ?datnar < 0) ) .
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?datnar"):::projected
v3("?datumr"):::projected
v7("?item"):::projected
v5("?p1")
v1("?p2")
v6("?r1")
v2("?r2")
a1((" "))
a2((" "))
a3((" "))
a4((" "))
a5((" "))
f0[["?p2 > '8^^xsd:integer'?r2 != 'wikibase:DeprecatedRank'?datumr - ?datnar < '0^^xsd:integer'"]]
f0 --> v1
f0 --> v2
f0 --> v3
f0 --> v4
f1[["?p1 > '8^^xsd:integer'?r1 != 'wikibase:DeprecatedRank'"]]
f1 --> v5
f1 --> v6
v7 --"p:direct/P691"--> a1
a2 --"p:statement/P569"--> v4
a2 --"p:statement/value/P569"--> a3
a3 --"wikibase:timePrecision"--> v5
a2 --"wikibase:rank"--> v6
v7 --"p:P569"--> a2
a4 --"p:statement/P570"--> v3
a4 --"p:statement/value/P570"--> a5
a5 --"wikibase:timePrecision"--> v1
a4 --"wikibase:rank"--> v2
v7 --"p:P570"--> a4