Dreams:sdg-index

From DREAMS
Revision as of 13:02, 9 December 2022 by Fnielsen (talk | contribs) (→‎SDGs)
Jump to navigation Jump to search

Verndersmål

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

SELECT 
  ?antal
  ?mål ?målLabel 
  (CONCAT("#sdg/", SUBSTR(STR(?mål), 38)) AS ?målUrl)
  ?målDescription
WITH {
  SELECT
    (COUNT(?item) AS ?antal)
    ?mål
  WHERE {
    { ?mål dreamst:P2 dreams:Q22 . }
    UNION
    { ?mål dreamst:P2 dreams:Q5594 . }

    OPTIONAL { ?item dreamst:P42 ?mål . }
  }
  GROUP BY ?mål
} AS %result
WHERE {
  INCLUDE %result
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". }
}
ORDER BY DESC(?antal)