Given a person, Return the top 20 forums the friends and friends-of-friends of that person joined after a given date.
T-Cypher query:
RIGHT_SLICE 2010-01-01T08:00:00Z ON R
MATCH (p1:Person)-[K:CONTINUOUS(knows*1..2)]->(p2:Person)<-[:hasMember]-(f:Forum)
RETURN f LIMIT 20
Cypher query:
MATCH (p1:`Person`)-[k:`knows`]->(p2:`Person`)<-[r0:`hasMember`]-(f:`Forum`)
WHERE (k.tEnd >= 1262332800000 AND r0.tEnd >= 1262332800000)
RETURN f LIMIT 20
UNION
MATCH (p1:`Person`)-[r0:`knows`]->(n0)-[r1:`knows`]->(p2:`Person`)<-[r2:`hasMember`]-(f:`Forum`)
WHERE (r0.tEnd >= 1262332800000 AND r1.tEnd >= 1262332800000 AND r2.tEnd >= 1262332800000 AND (myFunctions.min([r0.tEnd, r1.tEnd]) – myFunctions.max([r0.tStart, r1.tStart])) > 0)
RETURN f LIMIT 20