16,603
edits
(→Object class quickstatements: Recipient class quickstatements) |
|||
(9 intermediate revisions by the same user not shown) | |||
Line 234: | Line 234: | ||
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | ||
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> | PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> | ||
SELECT | SELECT | ||
Line 249: | Line 247: | ||
</pre> | </pre> | ||
=== Object class === | === 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> | <pre> | ||
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | ||
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> | PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> | ||
SELECT | SELECT | ||
Line 271: | Line 343: | ||
?pattern dreamst:P49 ?target_text . | ?pattern dreamst:P49 ?target_text . | ||
MINUS { ?pattern dreamst:P34 [] } | 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) | BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs) | ||
} | } |