query-76f858254a1f5442a27d33d48fdfaa32

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?start ?start_prc ?end ?end_prc
WHERE
{
  VALUES ?start_prc { 9 10 11 } # Start precision is year, month or day
  ?item p:P580/psv:P580 [wikibase:timePrecision ?start_prc; wikibase:timeValue ?start].
  VALUES ?end_prc { 9 10 11 } # End precision is year, month or day
  ?item p:P582/psv:P582 [wikibase:timePrecision ?end_prc; wikibase:timeValue ?end].
  MINUS { ?item p:P585 []. }
  FILTER (YEAR(?start) = YEAR(?end))
}
LIMIT 1000

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?end"):::projected v5("?end_prc"):::projected v4("?item"):::projected v1("?start"):::projected v3("?start_prc"):::projected a5((" ")) a2((" ")) a1((" ")) a4((" ")) a3((" ")) f0[["year-from-dateTime(?start) = year-from-dateTime(?end)"]] f0 --> v1 f0 --> v2 bind1[/VALUES ?start_prc/] bind1-->v3 bind10(["9^^xsd:integer"]) bind10 --> bind1 bind11(["10^^xsd:integer"]) bind11 --> bind1 bind12(["11^^xsd:integer"]) bind12 --> bind1 a1 --"wikibase:timePrecision"--> v3 a1 --"wikibase:timeValue"--> v1 v4 --"p:P580"--> a2 a2 --"p:statement/value/P580"--> a1 bind2[/VALUES ?end_prc/] bind2-->v5 bind20(["9^^xsd:integer"]) bind20 --> bind2 bind21(["10^^xsd:integer"]) bind21 --> bind2 bind22(["11^^xsd:integer"]) bind22 --> bind2 a3 --"wikibase:timePrecision"--> v5 a3 --"wikibase:timeValue"--> v2 v4 --"p:P582"--> a4 a4 --"p:statement/value/P582"--> a3 subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; v4 --"p:P585"--> a5 end