Main Page: Difference between revisions

Jump to navigation Jump to search
→‎Object class quickstatements: Recipient class quickstatements
(→‎Object class quickstatements: Recipient class quickstatements)
 
(13 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 228: 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 ==

Navigation menu