Advertisement
kieni17

Untitled

May 5th, 2020
295
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.28 KB | None | 0 0
  1. MATCH ( i:Intermediary )-[:INTERMEDIARY_OF]->( e:Entity )<-[:OFFICER_OF]-( o:Officer )-[:OFFICER_OF]->(e2:Entity )<-[:INTERMEDIARY_OF]-(i)
  2. WHERE NOT e.countries = e2.countries
  3. AND ( NOT e.jurisdiction = e.country_codes
  4. OR NOT e2.jurisdiction= e2.country_codes )
  5. RETURN i,e,e2,o
  6. LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement