title: neo4j trying to do UNION but I still see stuff that's outside of the range
body: <p>``Hi! I have a database of people who watch and like movies. Total of 5 people in which the friend relationshio goes like this: a>b>c>d>e. Im trying to get all the movies that they watched and liked from person a up to person d. I got it to work with this query but there were a lot of duplicates:</p>
  
  <pre><code>MATCH(p:Person{name:'Joe'})-[:Friend*1..3]-&gt;(f) 
  MATCH(m:Movie)&lt;-[:Watched]-(f) 
  MATCH(ml:Movie)&lt;-[:Liked]-(f) 
  MATCH (mg:Movie)&lt;-[:Watched]-(p) 
  MATCH (mgl:Movie)&lt;-[:Liked]-(p) 
  RETURN m,ml,mg,mgl
  </code></pre>
  
  <p>I tried to narrow it down with UNION but I still see a movie which only person e saw and liked:</p>
  
  <pre><code>MATCH(p:Person{name:'Joe'})-[:Friend*..3]-&gt;(f)
  MATCH(m:Movie)&lt;-[:Watched]-(f)
  RETURN m
  UNION 
  MATCH(m:Movie)&lt;-[:Liked]-(f)
  RETURN m
  UNION
  MATCH (m:Movie)&lt;-[:Watched]-(p) 
  RETURN m 
  UNION 
  MATCH (m:Movie)&lt;-[:Liked]-(p) 
  RETURN m
  </code></pre>
  
  <p>How can I remove them?</p>