query-b8fa4425587bb909db7bf180a1b24909

rq turtle/ttl

title: items that end before starting SELECT ?a WHERE { ?a wdt:P580 ?start. ?a wdt:P582 ?end. FILTER (?end < ?start) # wikidata bug: BCE dates are not ordered correctly FILTER ("0001-01-01" ^^ xsd:dateTime < ?end) }

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
#title: items that end before starting
SELECT ?a WHERE {
  ?a wdt:P580 ?start.
  ?a wdt:P582 ?end.
  FILTER (?end < ?start)
  # wikidata bug: BCE dates are not ordered correctly
  FILTER ("0001-01-01" ^^ xsd:dateTime < ?end)
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?a"):::projected v1("?end") v2("?start") f0[["'0001-01-01^^xsd:dateTime' < ?end"]] f0 --> v1 f1[["?end < ?start"]] f1 --> v1 f1 --> v2 v3 --"wdt:P580"--> v2 v3 --"wdt:P582"--> v1