16,603
edits
Main Page: Difference between revisions
Jump to navigation
Jump to search
→Object text count
| Line 259: | Line 259: | ||
?pattern dreamst:P49 ?text . | ?pattern dreamst:P49 ?text . | ||
MINUS { ?pattern dreamst:P34 [] } | 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 | GROUP BY ?text | ||