BusinessIntelligence-12

[davidfauth]

I thought I had this faster but this is 22seconds

match (message:Message)
WHERE message.creationDate > 20111021192109382
and
size((message)<-[:LIKES]-()) > 400
with message order by size((message)<-[:LIKES]-()) > 400 limit 100
match (message:Message)-[:HAS_CREATOR]->(creator:Person)
RETURN
message.id,
message.creationDate,
creator.firstName,
creator.lastName,
size((message)<-[:LIKES]-()) as likeCount
ORDER BY
likeCount DESC,
message.id ASC

[maxdemarzi]

added it.