Fixes for BI Q18
MATCH
(person:Person)<-[:HAS_CREATOR]-(message:Message)-[:REPLY_OF*0..]->(post:Post)
WHERE message.content IS NOT NULL
- AND message.length <= $lengthThreshold
+ AND message.length < $lengthThreshold
AND message.creationDate > $date
AND post.language IN $languages
-WITH person, count(message) AS messageCount
-RETURN messageCount, count(person) AS personCount
-ORDER BY messageCount DESC
+WITH
+ person,
+ count(message) AS messageCount
+RETURN
+ messageCount,
+ count(person) AS personCount
+ORDER BY
+ personCount DESC,
+ messageCount DESC
LIMIT 100
