mutual_following.adoc

User Suggestion with mutual count

Following up on This Question

CREATE (A {userid:1000, name: 'A'})
CREATE (B {userid:2000, name: 'B'})
CREATE (C {userid:3000, name: 'C'})
CREATE (D {userid:4000, name: 'D'})
CREATE (E {userid:5000, name: 'E'})
CREATE A -[:friends]-> B
CREATE A -[:friends]-> C
CREATE B -[:friends]-> A
CREATE B -[:friends]-> C
CREATE B -[:friends]-> D
CREATE C -[:friends]-> D

START me=node(*)
MATCH pMutualFriends=me-[:friends]-mf-[?:friends]-user
WHERE me.userid?=1000 AND ID(mf)> ID(user) AND id(user)<> id(me)
RETURN me.name?, user.name?, COUNT(pMutualFriends) AS MutualCount
ORDER BY MutualCount DESC