Main Page: Difference between revisions

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