Dreams:sdg-index
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)