query-7a95cc13e2da00f11d6ed89ea2f4f3f8
Položky s datem narození z Národních autorit, druhé je inverzní (6. 8. vs. 8. 6. )
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?item ?itemLabel ?datum_narozeni_nkcr ?datum_narozeni_druhe where {
{ select * where {
?item p:P569 ?statement1, ?statement2 .
?statement1 ps:P569 ?datum_narozeni_nkcr ; prov:wasDerivedFrom/pr:P248 wd:Q13550863 ; psv:P569/wikibase:timePrecision ?precision1 .
?statement2 ps:P569 ?datum_narozeni_druhe; psv:P569/wikibase:timePrecision ?precision2.
FILTER( ?statement1 != ?statement2 ) .
FILTER (?precision1 = 11 && ?precision2 = 11 )
FILTER(day(?datum_narozeni_nkcr)=month(?datum_narozeni_druhe) && month(?datum_narozeni_nkcr)=day(?datum_narozeni_druhe) && day(?datum_narozeni_nkcr) != month(?datum_narozeni_nkcr))
} } SERVICE wikibase:label { bd:serviceParam wikibase:language "cs,en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?datum_narozeni_druhe"):::projected
v1("?datum_narozeni_nkcr"):::projected
v7("?item"):::projected
v3("?precision1")
v4("?precision2")
v5("?statement1")
v6("?statement2")
a1((" "))
a2((" "))
a3((" "))
c10(["bd:serviceParam"]):::iri
c6(["wd:Q13550863"]):::iri
c12(["cs,en"]):::literal
f0[["day-from-dateTime(?datum_narozeni_nkcr) = month-from-dateTime(?datum_narozeni_druhe)month-from-dateTime(?datum_narozeni_nkcr) = day-from-dateTime(?datum_narozeni_druhe)day-from-dateTime(?datum_narozeni_nkcr) != month-from-dateTime(?datum_narozeni_nkcr)"]]
f0 --> v1
f0 --> v2
f1[["?precision1 = '11^^xsd:integer'?precision2 = '11^^xsd:integer'"]]
f1 --> v3
f1 --> v4
f2[["?statement1 != ?statement2"]]
f2 --> v5
f2 --> v6
v7 --"p:P569"--> v5
v7 --"p:P569"--> v6
v5 --"p:statement/P569"--> v1
v5 --"prov:wasDerivedFrom"--> a1
a1 --"p:reference/P248"--> c6
v5 --"p:statement/value/P569"--> a2
a2 --"wikibase:timePrecision"--> v3
v6 --"p:statement/P569"--> v2
v6 --"p:statement/value/P569"--> a3
a3 --"wikibase:timePrecision"--> v4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c10 --"wikibase:language"--> c12
end