Dreams:effect-index: Difference between revisions

From DREAMS
Jump to navigation Jump to search
(→‎Effects: dansk)
Line 1: Line 1:
== Effects ==
== 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
   ?number_of_patterns
   ?mønstre


   ?effect ?effectLabel
   ?effekt ?effektLabel
   (CONCAT("#effect/", SUBSTR(STR(?effect), 38)) AS ?effectUrl)   
   (CONCAT("#effekt/", SUBSTR(STR(?effekt), 38)) AS ?effektUrl)   


   ?example_pattern ?example_patternLabel
   ?eksempel_mønster ?eksempel_mønsterLabel
   (CONCAT("#pattern/", SUBSTR(STR(?example_pattern), 38)) AS ?example_patternUrl)   
   (CONCAT("#pattern/", SUBSTR(STR(?eksempel_mønster), 38)) AS ?eksempel_mønsterUrl)   
   
   
WITH {
WITH {
   SELECT  
   SELECT  
     (COUNT(?pattern) AS ?number_of_patterns)
     (COUNT(?pattern) AS ?mønstre)
     (SAMPLE(?pattern) AS ?example_pattern)
     (SAMPLE(?pattern) AS ?eksempel_mønster)
     ?effect
     ?effekt
   WHERE {
   WHERE {
     ?pattern dreamst:P2 dreams:Q263 .
     ?pattern dreamst:P2 dreams:Q263 .
     ?pattern dreamst:P33 | dreamst:P34 ?effect .
     ?pattern dreamst:P33 | dreamst:P34 ?effekt .
   }
   }
   GROUP BY ?effect
   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(?number_of_patterns)
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