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
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