Dreams:effect-index: Difference between revisions
Jump to navigation
Jump to search
(→Effects: dansk) |
|||
Line 1: | Line 1: | ||
== | == Effekter == | ||
{{SPARQL | query= | {{SPARQL | query= | ||
PREFIX target: <https://dreams.wikibase.cloud/entity/Q153> | PREFIX target: <https://dreams.wikibase.cloud/entity/Q153> | ||
Line 8: | Line 8: | ||
SELECT | SELECT | ||
? | ?mønstre | ||
? | ?effekt ?effektLabel | ||
(CONCAT("# | (CONCAT("#effekt/", SUBSTR(STR(?effekt), 38)) AS ?effektUrl) | ||
? | ?eksempel_mønster ?eksempel_mønsterLabel | ||
(CONCAT("#pattern/", SUBSTR(STR(? | (CONCAT("#pattern/", SUBSTR(STR(?eksempel_mønster), 38)) AS ?eksempel_mønsterUrl) | ||
WITH { | WITH { | ||
SELECT | SELECT | ||
(COUNT(?pattern) AS ? | (COUNT(?pattern) AS ?mønstre) | ||
(SAMPLE(?pattern) AS ? | (SAMPLE(?pattern) AS ?eksempel_mønster) | ||
? | ?effekt | ||
WHERE { | WHERE { | ||
?pattern dreamst:P2 dreams:Q263 . | ?pattern dreamst:P2 dreams:Q263 . | ||
?pattern dreamst:P33 | dreamst:P34 ? | ?pattern dreamst:P33 | dreamst:P34 ?effekt . | ||
} | } | ||
GROUP BY ? | GROUP BY ?effekt | ||
} AS %result | } AS %result | ||
WHERE { | WHERE { | ||
Line 31: | Line 31: | ||
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) | ||
}} | }} |
Revision as of 17:05, 9 December 2022
Effekter
PREFIX target: <https://dreams.wikibase.cloud/entity/Q153> 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 ?mønstre ?effekt ?effektLabel (CONCAT("#effekt/", SUBSTR(STR(?effekt), 38)) AS ?effektUrl) ?eksempel_mønster ?eksempel_mønsterLabel (CONCAT("#pattern/", SUBSTR(STR(?eksempel_mønster), 38)) AS ?eksempel_mønsterUrl) WITH { SELECT (COUNT(?pattern) AS ?mønstre) (SAMPLE(?pattern) AS ?eksempel_mønster) ?effekt WHERE { ?pattern dreamst:P2 dreams:Q263 . ?pattern dreamst:P33