query-7a95cc13e2da00f11d6ed89ea2f4f3f8

rq turtle/ttl

Položky s datem narození z Národních autorit, druhé je inverzní (6. 8. vs. 8. 6. )

Use at

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