16,603
edits
Main Page: Difference between revisions
→Subject text count
| Line 238: | Line 238: | ||
SELECT | SELECT | ||
(COUNT(?pattern) AS ?count) ? | (COUNT(?pattern) AS ?count) ?text | ||
WHERE { | WHERE { | ||
?pattern dreamst:P2 dreams:Q263 . | ?pattern dreamst:P2 dreams:Q263 . | ||
?pattern dreamst:P47 ? | ?pattern dreamst:P47 ?text . | ||
MINUS { ?pattern dreamst:P33 [] } | MINUS { ?pattern dreamst:P33 [] } | ||
} | } | ||
GROUP BY ? | GROUP BY ?text | ||
ORDER BY DESC(?count) | ORDER BY DESC(?count) | ||
</pre> | </pre> | ||