16,603
edits
Dreams:pattern-index: Difference between revisions
→Reports
No edit summary |
|||
| Line 88: | Line 88: | ||
}} | }} | ||
== | == Rapporter == | ||
{{SPARQL | query= | {{SPARQL | query= | ||
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | ||
| Line 96: | Line 96: | ||
SELECT | SELECT | ||
? | ?Mønstre | ||
? | ?rapport | ||
? | ?rapportLabel | ||
(CONCAT("#report/", SUBSTR(STR(? | (CONCAT("#report/", SUBSTR(STR(?rapport), 38)) AS ?rapportUrl) | ||
WITH { | WITH { | ||
SELECT | SELECT | ||
(COUNT(?pattern) AS ? | (COUNT(?pattern) AS ?mønstre) | ||
? | ?rapport | ||
WHERE { | WHERE { | ||
?pattern dreamst:P2 dreams:Q263 ; | ?pattern dreamst:P2 dreams:Q263 ; | ||
dreamst:P20 ? | dreamst:P20 ?rapport . | ||
} | } | ||
GROUP BY ? | GROUP BY ?rapport | ||
} AS %result | } AS %result | ||
WHERE { | WHERE { | ||
| Line 116: | Line 116: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } | ||
} | } | ||
ORDER BY DESC(? | ORDER BY DESC(?mønstre) | ||
}} | }} | ||