Skip to content

Instantly share code, notes, and snippets.

@danstarns

danstarns/cypher-coactors-coactors.gql

Last active April 10, 2022 16:10
Show Gist options
  • Save danstarns/f6b4328a33e4526fb5eb9f94fbdb4397 to your computer and use it in GitHub Desktop.
Save danstarns/f6b4328a33e4526fb5eb9f94fbdb4397 to your computer and use it in GitHub Desktop.
Download ZIP
cypher-coactors-coactors
Raw
cypher-coactors-coactors.gql
MATCH (tom:Person {name: 'Tom Hanks'})
MATCH (tom)-[:ACTED_IN]->(:Movie)<-[:ACTED_IN]-(:Person)-[:ACTED_IN]->(:Movie)<-[:ACTED_IN]-(coCoActor:Person)
WHERE
tom <> coCoActor AND
NOT (tom)-[:ACTED_IN]->(:Movie)<-[:ACTED_IN]-(coCoActor)
RETURN coCoActor.name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment