Dreams:sdg-index

SDGs

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

SELECT 
  ?count
  ?goal ?goalLabel 
  (CONCAT("#sdg/", SUBSTR(STR(?goal), 38)) AS ?goalUrl)
  ?goalDescription
WITH {
  SELECT
    (COUNT(?item) AS ?count)
    ?goal
  WHERE {
    { ?goal dreamst:P2 dreams:Q22 . }
    UNION
    { ?goal dreamst:P2 dreams:Q5594 . }

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