query-e26df4b153ec155cc522868fd1458264

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?time ?count
WHERE
{

{
  SELECT ?time (COUNT(?time) AS ?count)
  WHERE
  {
    ?item p:P585 /  psv:P585 ?fullvalue.
    ?fullvalue wikibase:timePrecision 11 . # Precision is date
    ?fullvalue wikibase:timeValue ?time.
    MINUS { ?item (wdt:P31/wdt:P279*) wd:Q6888. } # exclude transit astronomiques
  }
  GROUP BY ?time
  HAVING (?count > 1)
}  ?item p:P585 / psv:P585 ?fullvalue.
  ?fullvalue wikibase:timePrecision 11 . # Precision is date
  ?fullvalue wikibase:timeValue ?time.
  MINUS { ?item (wdt:P31/wdt:P279*) wd:Q6888. } # exclude transit astronomiques
}

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?count"):::projected v3("?fullvalue") v2("?item"):::projected v4("?time"):::projected a1((" ")) a2((" ")) a3((" ")) a4((" ")) c5(["11^^xsd:integer"]):::literal c9(["wd:Q6888"]):::iri f0[["?count > '1^^xsd:integer'"]] f0 --> v5 v2 --"p:P585"--> a1 a1 --"p:statement/value/P585"--> v3 v3 --"wikibase:timePrecision"--> c5 v3 --"wikibase:timeValue"--> v4 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v2 --"p:direct/P31"--> a2 a2 --"p:direct/P279"--> c9 end bind3[/"count(?time)"/] v4 --o bind3 bind3 --as--o v5 v2 --"p:P585"--> a3 a3 --"p:statement/value/P585"--> v3 v3 --"wikibase:timePrecision"--> c5 v3 --"wikibase:timeValue"--> v4 subgraph minus4["MINUS"] style minus4 stroke-width:6px,fill:pink,stroke:red; v2 --"p:direct/P31"--> a4 a4 --"p:direct/P279"--> c9 end