16,603
edits
(→Quotes) |
(→Object class quickstatements: Recipient class quickstatements) |
||
(20 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 | 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% | [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 148: | Line 174: | ||
[https://dreams.wikibase.cloud/query/index.html#%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%3Fproject1%20%3Fproject1Label%0A%20%20%3Fproject2%20%3Fproject2Label%0AWHERE%20%7B%0A%20%20%7B%20%3Fproject1%20dreamst%3AP14%2B%20dreams%3AQ91%20.%0A%20%20%20%20%3Fproject2%20dreamst%3AP14%2B%20dreams%3AQ91%20%7D%0A%20%20UNION%0A%20%20%7B%20BIND%28dreams%3AQ91%20AS%20%3Fproject1%29%20%7D%0A%20%20%3Fproject2%20dreamst%3AP14%20%3Fproject1%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D%0A Query] | [https://dreams.wikibase.cloud/query/index.html#%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%3Fproject1%20%3Fproject1Label%0A%20%20%3Fproject2%20%3Fproject2Label%0AWHERE%20%7B%0A%20%20%7B%20%3Fproject1%20dreamst%3AP14%2B%20dreams%3AQ91%20.%0A%20%20%20%20%3Fproject2%20dreamst%3AP14%2B%20dreams%3AQ91%20%7D%0A%20%20UNION%0A%20%20%7B%20BIND%28dreams%3AQ91%20AS%20%3Fproject1%29%20%7D%0A%20%20%3Fproject2%20dreamst%3AP14%20%3Fproject1%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D%0A Query] | ||
== Effect patterns subject-object graph == | === Effect patterns subject-object graph === | ||
<pre> | <pre> | ||
#defaultView:Graph | #defaultView:Graph | ||
Line 167: | Line 193: | ||
[https://dreams.wikibase.cloud/query/index.html#%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%3Fsubject%20%3FsubjectLabel%0A%20%20%3Fobject%20%3FobjectLabel%0AWHERE%20%7B%0A%20%20%5B%5D%20dreamst%3AP2%20dreams%3AQ263%20%3B%0A%20%20%20%20%20dreamst%3AP33%20%3Fsubject%20%3B%0A%20%20%20%20%20dreamst%3AP34%20%3Fobject%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D%0A Query] | [https://dreams.wikibase.cloud/query/index.html#%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%3Fsubject%20%3FsubjectLabel%0A%20%20%3Fobject%20%3FobjectLabel%0AWHERE%20%7B%0A%20%20%5B%5D%20dreamst%3AP2%20dreams%3AQ263%20%3B%0A%20%20%20%20%20dreamst%3AP33%20%3Fsubject%20%3B%0A%20%20%20%20%20dreamst%3AP34%20%3Fobject%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D%0A Query] | ||
== Quotes == | === Quotes === | ||
<pre> | <pre> | ||
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | ||
Line 182: | Line 208: | ||
[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%2Fdirecthttps://dreams.wikibase.cloud/w/index.php?title=Main_Page&action=edit§ion=17%2F%3E%0A%0ASELECT%20DISTINCT%0A%20%20%3Fpattern%0A%20%20%3Fquote%0AWHERE%20%7B%0A%20%20%3Fpattern%20dreamst%3AP18%20%3Fquote%20.%0A%7D Quote] | [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%2Fdirecthttps://dreams.wikibase.cloud/w/index.php?title=Main_Page&action=edit§ion=17%2F%3E%0A%0ASELECT%20DISTINCT%0A%20%20%3Fpattern%0A%20%20%3Fquote%0AWHERE%20%7B%0A%20%20%3Fpattern%20dreamst%3AP18%20%3Fquote%20.%0A%7D Quote] | ||
== Number of pages through time == | === Number of pages through time === | ||
<pre> | <pre> | ||
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | ||
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 == | |||
=== Reports === | |||
<pre> | |||
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 | |||
</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) | |||
} | |||
GROUP BY ?dummy | |||
</pre> |