Main Page: Difference between revisions

From DREAMS
Jump to navigation Jump to search
(→‎Object class quickstatements: Recipient class quickstatements)
 
(16 intermediate revisions by the same user not shown)
Line 39: Line 39:
SELECT ?concept2 ?concept2Label ?concept1 ?concept1Label {
SELECT ?concept2 ?concept2Label ?concept1 ?concept1Label {
   ?concept2 dreamst:P10 ?concept1 .
   ?concept2 dreamst:P10 ?concept1 .
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
}
</pre>
</pre>


[https://dreams.wikibase.cloud/query/#%23defaultView%3AGraph%0APREFIX%20dreams%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20dreamst%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fconcept2%20%3Fconcept2Label%20%3Fconcept1%20%3Fconcept1Label%20%7B%0A%20%20%3Fconcept2%20dreamst%3AP10%20%3Fconcept1%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cda%22.%20%7D%0A%7D Query]
[https://dreams.wikibase.cloud/query/#%23defaultView%3AGraph%0APREFIX%20dreams%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20dreamst%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fconcept2%20%3Fconcept2Label%20%3Fconcept1%20%3Fconcept1Label%20%7B%0A%20%20%3Fconcept2%20dreamst%3AP10%20%3Fconcept1%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D Query]


=== Graph example ===
=== Graph example ===
Line 126: Line 126:
}  
}  
</pre>
</pre>
Effect with "has effect" and effect patterns:
<pre>
#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  ?effect1 ?effect1Label
  ?effect2 ?effect2Label
  # ?effect3 ?effect3Label
WHERE {
  {
    [] dreamst:P33 ?effect1 ;
      dreamst:P34 ?effect2 .
  }
  UNION
  {
    ?effect1 dreamst:P10* / dreamst:P9 ?effect2 .
  }
 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
</pre>
[https://dreams.wikibase.cloud/query/#%23defaultView%3AGraph%0APREFIX%20dreams%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20dreamst%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%0A%20%20%3Feffect1%20%3Feffect1Label%0A%20%20%3Feffect2%20%3Feffect2Label%0A%20%20%23%20%3Feffect3%20%3Feffect3Label%0AWHERE%20%7B%0A%0A%20%20%7B%0A%20%20%20%20%5B%5D%20dreamst%3AP33%20%3Feffect1%20%3B%0A%20%20%20%20%20%20%20dreamst%3AP34%20%3Feffect2%20.%0A%20%20%7D%0A%20%20UNION%20%0A%20%20%7B%0A%20%20%20%20%3Feffect1%20dreamst%3AP10%2a%20%2F%20dreamst%3AP9%20%3Feffect2%20.%0A%20%20%7D%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D%20 Query]


=== Project types ===
=== Project types ===
Line 202: Line 228:


[https://dreams.wikibase.cloud/query/#PREFIX%20dreams%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20dreamst%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%0A%20%20%3Fyear%0A%20%20%3Fpages%0A%20%20%3Freport%20%3FreportLabel%0AWHERE%20%7B%0A%20%20%3Freport%20dreamst%3AP2%20dreams%3AQ4%20%3B%0A%20%20%20%20%20%20%20%20%20%20dreamst%3AP27%20%3Fpages%20%3B%0A%20%20%20%20%20%20%20%20%20%20dreamst%3AP6%20%3Fpublication_datetime%20.%0A%20%20BIND%28STR%28YEAR%28%3Fpublication_datetime%29%29%20AS%20%3Fyear%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20%3Fyear Quotes]
[https://dreams.wikibase.cloud/query/#PREFIX%20dreams%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20dreamst%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%0A%20%20%3Fyear%0A%20%20%3Fpages%0A%20%20%3Freport%20%3FreportLabel%0AWHERE%20%7B%0A%20%20%3Freport%20dreamst%3AP2%20dreams%3AQ4%20%3B%0A%20%20%20%20%20%20%20%20%20%20dreamst%3AP27%20%3Fpages%20%3B%0A%20%20%20%20%20%20%20%20%20%20dreamst%3AP6%20%3Fpublication_datetime%20.%0A%20%20BIND%28STR%28YEAR%28%3Fpublication_datetime%29%29%20AS%20%3Fyear%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20%3Fyear Quotes]
== Quickstatements generation ==
=== Subject text count ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P47 ?text .
    MINUS { ?pattern dreamst:P33 [] }
GROUP BY ?text
ORDER BY DESC(?count)
</pre>
=== Object text count ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P49 ?text .
    MINUS { ?pattern dreamst:P34 [] }
GROUP BY ?text
ORDER BY DESC(?count)
</pre>
=== Recipient text count ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P54 ?text .
    MINUS { ?pattern dreamst:P55 [] }
GROUP BY ?text
ORDER BY DESC(?count)
</pre>
=== Mitigation text count ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P53 ?text .
    MINUS { ?pattern dreamst:P56 [] }
GROUP BY ?text
ORDER BY DESC(?count)
</pre>
=== Subject class quickstatements ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P33" AS ?qs) }
  UNION
  {
    BIND(dreams:Q113 AS ?target)
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P47 ?target_text .
    MINUS { ?pattern dreamst:P33 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  }
}
</pre>
=== Object class quickstatements ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P34" AS ?qs) }
  UNION
  {
    BIND(dreams:Q2450 AS ?target)
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P49 ?target_text .
    MINUS { ?pattern dreamst:P34 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  }
}
</pre>
=== Recipient class quickstatements ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P55" AS ?qs) }
  UNION
  {
    BIND(dreams:Q951 AS ?target)
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P54 ?target_text .
    MINUS { ?pattern dreamst:P55 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  }
}
</pre>
=== Mitigation class quickstatements ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P56" AS ?qs) }
  UNION
  {
    BIND(dreams:Q825 AS ?target)
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P53 ?target_text .
    MINUS { ?pattern dreamst:P56 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  }
}
</pre>


== Cradle queries ==
== Cradle queries ==
=== Reports ===
<pre>
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
Line 213: Line 409:
   ?report dreamst:P2 dreams:Q4 .
   ?report dreamst:P2 dreams:Q4 .
   BIND(SUBSTR(STR(?report), 38) AS ?q)
   BIND(SUBSTR(STR(?report), 38) AS ?q)
  BIND(1 AS ?dummy)
}
GROUP BY ?dummy
</pre>
=== Significance types ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  (GROUP_CONCAT(?q; separator=",") AS ?item)
WHERE {
  {
    SELECT
      ?item ?itemLabel
    WHERE {
      ?item dreamst:P2 dreams:Q177 .
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    }
    ORDER BY ?itemLabel
  }
  BIND(SUBSTR(STR(?item), 38) AS ?q)
   BIND(1 AS ?dummy)
   BIND(1 AS ?dummy)
}
}
GROUP BY ?dummy
GROUP BY ?dummy
</pre>
</pre>

Latest revision as of 20:39, 24 November 2022

Items

Dokuments

Projects

Effect patterns

Query

Ontology

Items

Properties

Queries

Subclass graph

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT ?concept2 ?concept2Label ?concept1 ?concept1Label {
  ?concept2 dreamst:P10 ?concept1 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}

Query

Graph example

#defaultView:Map
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT ?report ?reportLabel ?location ?locationLabel ?geo {
  ?report dreamst:P12 ?location .
  ?location dreamst:P13 ?geo
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}

Sustainable Development Goals

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT ?sdg ?sdgLabel {
  ?sdg dreamst:P2 dreams:Q22 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Impact graph from ontology

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT ?concept2 ?concept2Label ?concept1 ?concept1Label {
  ?concept2 dreamst:P14 ?concept1 .
  { BIND (dreams:Q49 AS ?concept1) }
  UNION
  {
    ?concept1 dreamst:P14+ dreams:Q49 .
    ?concept2 dreamst:P14+ dreams:Q49 .
  }    
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}

Subactivities ontology

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT ?concept1 ?concept1Label ?rgb ?concept2 ?concept2Label  {
    ?concept1 dreamst:P14 ?concept2 .
    { BIND (dreams:Q106 AS ?concept2) }
    UNION
    {
      ?concept1 dreamst:P14+ dreams:Q106 .
    }
    OPTIONAL {
      ?concept1 dreamst:P19 ?project_phase1 . 
      BIND( IF(?project_phase1 = dreams:Q97, "3182BD", "E6550D") AS ?rgb)
    } 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}

Query

Effect graph

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  ?subactivity ?subactivityLabel ?rgb
  ?impact ?impactLabel
{
  BIND( IF(EXISTS { ?subactivity dreamst:P14+ dreams:Q106 }, "3182BD", "E6550D") AS ?rgb)
  # ?impact dreamst:P14+ dreams:Q49 .
  ?subactivity dreamst:P9 ?impact .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
} 

Effect with "has effect" and effect patterns:

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  ?effect1 ?effect1Label
  ?effect2 ?effect2Label
  # ?effect3 ?effect3Label
WHERE {

  {
    [] dreamst:P33 ?effect1 ;
       dreamst:P34 ?effect2 .
  }
  UNION 
  {
    ?effect1 dreamst:P10* / dreamst:P9 ?effect2 .
  }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
} 

Query

Project types

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  ?project1 ?project1Label
  ?project2 ?project2Label
WHERE {
  { ?project1 dreamst:P14+ dreams:Q91 .
    ?project2 dreamst:P14+ dreams:Q91 }
  UNION
  { BIND(dreams:Q91 AS ?project1) }
  ?project2 dreamst:P14 ?project1 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}

Query

Effect patterns subject-object graph

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  ?subject ?subjectLabel
  ?object ?objectLabel
WHERE {
  [] dreamst:P2 dreams:Q263 ;
     dreamst:P33 ?subject ;
     dreamst:P34 ?object .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}

Query

Quotes

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT DISTINCT
  ?pattern
  ?quote
WHERE {
  ?pattern dreamst:P18 ?quote .
}

Quote

Number of pages through time

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT 
  ?year
  ?pages
  ?report ?reportLabel
WHERE {
  ?report dreamst:P2 dreams:Q4 ;
          dreamst:P27 ?pages ;
          dreamst:P6 ?publication_datetime .
  BIND(STR(YEAR(?publication_datetime)) AS ?year)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?year

Quotes

Quickstatements generation

Subject text count

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {

    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P47 ?text .
    MINUS { ?pattern dreamst:P33 [] }
}   
GROUP BY ?text
ORDER BY DESC(?count) 

Object text count

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {

    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P49 ?text .
    MINUS { ?pattern dreamst:P34 [] }
}   
GROUP BY ?text
ORDER BY DESC(?count) 

Recipient text count

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {

    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P54 ?text .
    MINUS { ?pattern dreamst:P55 [] }
}   
GROUP BY ?text
ORDER BY DESC(?count) 

Mitigation text count

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {

    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P53 ?text .
    MINUS { ?pattern dreamst:P56 [] }
}   
GROUP BY ?text
ORDER BY DESC(?count) 

Subject class quickstatements

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P33" AS ?qs) }
  UNION
  {
    BIND(dreams:Q113 AS ?target) 
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P47 ?target_text .
    MINUS { ?pattern dreamst:P33 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  } 
}

Object class quickstatements

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P34" AS ?qs) }
  UNION
  {
    BIND(dreams:Q2450 AS ?target) 
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P49 ?target_text .
    MINUS { ?pattern dreamst:P34 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  } 
}

Recipient class quickstatements

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P55" AS ?qs) }
  UNION
  {
    BIND(dreams:Q951 AS ?target) 
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P54 ?target_text .
    MINUS { ?pattern dreamst:P55 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  } 
}

Mitigation class quickstatements

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P56" AS ?qs) }
  UNION
  {
    BIND(dreams:Q825 AS ?target) 
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P53 ?target_text .
    MINUS { ?pattern dreamst:P56 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  } 
}

Cradle queries

Reports

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  (GROUP_CONCAT(?q; separator=",") AS ?reports)
WHERE {
  ?report dreamst:P2 dreams:Q4 .
  BIND(SUBSTR(STR(?report), 38) AS ?q)
  BIND(1 AS ?dummy)
}
GROUP BY ?dummy

Significance types

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  (GROUP_CONCAT(?q; separator=",") AS ?item)
WHERE {
  {
    SELECT 
      ?item ?itemLabel
    WHERE {
      ?item dreamst:P2 dreams:Q177 .
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    }
    ORDER BY ?itemLabel
  }
  BIND(SUBSTR(STR(?item), 38) AS ?q)
  BIND(1 AS ?dummy)
}
GROUP BY ?dummy