query-180b5e4a5d63cb7007a01544407c6f14
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?p (CONCAT(STR(?value), '/10') AS ?date) WHERE {
VALUES ?p {} .
?p p:P577 ?statement1, ?statement2 .
FILTER( ?statement1 != ?statement2 ) .
?statement1 psv:P577 [ wikibase:timePrecision 10; wikibase:timeValue ?value ] .
?statement2 psv:P577 [ wikibase:timePrecision 11; wikibase:timeValue ?value2 ] .
FILTER( SUBSTR(STR(?value), 1, 7) = SUBSTR(STR(?value2), 1, 7)) .
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?date")
v5("?p"):::projected
v3("?statement1")
v4("?statement2")
v1("?value"):::projected
v2("?value2")
a1((" "))
a2((" "))
c8(["11^^xsd:integer"]):::literal
c5(["10^^xsd:integer"]):::literal
f0[["substring(str(?value),'1^^xsd:integer','7^^xsd:integer') = substring(str(?value2),'1^^xsd:integer','7^^xsd:integer')"]]
f0 --> v1
f0 --> v2
f1[["?statement1 != ?statement2"]]
f1 --> v3
f1 --> v4
bind2[/VALUES ?p/]
bind2-->v5
v5 --"p:P577"--> v3
v5 --"p:P577"--> v4
a1 --"wikibase:timePrecision"--> c5
a1 --"wikibase:timeValue"--> v1
v3 --"p:statement/value/P577"--> a1
a2 --"wikibase:timePrecision"--> c8
a2 --"wikibase:timeValue"--> v2
v4 --"p:statement/value/P577"--> a2
bind3[/"concat(str(?value),'/10')"/]
v1 --o bind3
bind3 --as--o v6