Dreams:sdg-index
Jump to navigation
Jump to search
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)