Dreams:taxon-index

Revision as of 14:05, 15 March 2023 by Fnielsen (talk | contribs) (→‎Taksoner)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Taksoner

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT 
  ?mønstre
  ?rapporter
  ?takson ?taksonLabel
  (CONCAT("#taxon/", SUBSTR(STR(?takson), 38)) AS ?taksonUrl)
WITH {
  SELECT
    (COUNT(DISTINCT ?mønster) AS ?mønstre)
    (COUNT(DISTINCT ?rapport) AS ?rapporter)
    ?takson
  WHERE {
    ?takson dreamst:P2 dreams:Q215 .
    OPTIONAL { ?rapport dreamst:P28 ?takson . }
    OPTIONAL { ?mønster dreamst:P55 ?takson . }
  }
  GROUP BY ?takson
} AS %result
WHERE {
  INCLUDE %result
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". }
}
ORDER BY DESC(?mønstre) DESC(?rapporter)