16,603
edits
No edit summary |
|||
Line 24: | Line 24: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } | ||
} | } | ||
}} | |||
== Reports == | |||
{{SPARQL | query= | |||
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | |||
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> | |||
PREFIX dreamsp: <https://dreams.wikibase.cloud/prop/> | |||
PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/> | |||
SELECT | |||
?number_of_patterns | |||
?report | |||
?reportLabel | |||
(CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl) | |||
WITH { | |||
SELECT | |||
(COUNT(?pattern) AS ?number_of_patterns) | |||
?report | |||
WHERE { | |||
?pattern dreamst:P2 dreams:Q263 ; | |||
dreamst:P20 ?report . | |||
} | |||
GROUP BY ?report | |||
} AS %result | |||
WHERE { | |||
INCLUDE %result | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } | |||
} | |||
ORDER BY DESC(?number_of_patterns) | |||
}} | }} |