query-887e0fdecabd14043857a9fff5f2e8fe

PREFIX wikibase: <http://wikiba.se/ontology#>
SELECT DISTINCT ?item ?statement ?date ?precision_label {
  ?statement ?date_prop ?date_node .
  ?date_node wikibase:timePrecision ?precision ;
   wikibase:timeValue ?date .

  FILTER (YEAR(?date) < -10000) .
  FILTER (?precision >= 9 ) . 

  VALUES (?precision ?precision_label) {
    (0 "milliard d’années")
    (1 "centaine de million d’années")
    (2 "dizaine de millions d’années")
    (3 "million d’années")
    (4 "centaine de millénaires")
    (5 "dizaine de millénaires")
    (6 "millénaire")
    (7 "siècle")
    (8 "décennie")
    (9 "année")
    (10 "mois")
    (11 "jour")
    (12 "heure")
    (13 "minute")
    (14 "seconde")
  } 

  # Exclude Property statements
  ?item ?p ?statement  .
  ?item wikibase:statements ?s .
  FILTER(STRSTARTS(STR(?item), "http://www.wikidata.org/entity/Q")) .


} ORDER BY ?precision YEAR(?date)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?date"):::projected v6("?date_node") v5("?date_prop") v3("?item"):::projected v8("?p") v7("?precision") v7("?precision_label"):::projected v9("?s") v4("?statement"):::projected f0[["starts-with(str(?item),'http://www.wikidata.org/entity/Q')"]] f0 --> v3 f1[["?precision >= '9^^xsd:integer'"]] f1 --> v7 f2[["year-from-dateTime(?date) < '-10000^^xsd:integer'"]] f2 --> v2 v4 -->v5--> v6 v6 --"wikibase:timePrecision"--> v7 v6 --"wikibase:timeValue"--> v2 bind3[/VALUES ?precision ?precision_label/] bind3-->v7 bind3-->v7 bind30(["0^^xsd:integer"]) bind30 --> bind3 bind31(["milliard d’années"]) bind31 --> bind3 bind32(["1^^xsd:integer"]) bind32 --> bind3 bind33(["centaine de million d’années"]) bind33 --> bind3 bind34(["2^^xsd:integer"]) bind34 --> bind3 bind35(["dizaine de millions d’années"]) bind35 --> bind3 bind36(["3^^xsd:integer"]) bind36 --> bind3 bind37(["million d’années"]) bind37 --> bind3 bind38(["4^^xsd:integer"]) bind38 --> bind3 bind39(["centaine de millénaires"]) bind39 --> bind3 bind310(["5^^xsd:integer"]) bind310 --> bind3 bind311(["dizaine de millénaires"]) bind311 --> bind3 bind312(["6^^xsd:integer"]) bind312 --> bind3 bind313(["millénaire"]) bind313 --> bind3 bind314(["7^^xsd:integer"]) bind314 --> bind3 bind315(["siècle"]) bind315 --> bind3 bind316(["8^^xsd:integer"]) bind316 --> bind3 bind317(["décennie"]) bind317 --> bind3 bind318(["9^^xsd:integer"]) bind318 --> bind3 bind319(["année"]) bind319 --> bind3 bind320(["10^^xsd:integer"]) bind320 --> bind3 bind321(["mois"]) bind321 --> bind3 bind322(["11^^xsd:integer"]) bind322 --> bind3 bind323(["jour"]) bind323 --> bind3 bind324(["12^^xsd:integer"]) bind324 --> bind3 bind325(["heure"]) bind325 --> bind3 bind326(["13^^xsd:integer"]) bind326 --> bind3 bind327(["minute"]) bind327 --> bind3 bind328(["14^^xsd:integer"]) bind328 --> bind3 bind329(["seconde"]) bind329 --> bind3 v3 -->v8--> v4 v3 --"wikibase:statements"--> v9