Find places that people also like who favorite this place:
- Determine who has favorited place x.
- What else have they favorited that is not place x.
Query.
MATCH (place)<-[:favorite]-(person)-[:favorite]->(stuff) WHERE place.name = 'CoffeeShop1' RETURN stuff.name, count(*) ORDER BY count(*) DESC , stuff.name
The list of places that are favorited by people that favorited the start place.
Find places that are tagged with the same tags:
- Determine the tags for place x.
- What else is tagged the same as x that is not x.
Query.
MATCH (place)-[:tagged]->(tag)<-[:tagged]-(otherPlace) WHERE place.name = 'CoffeeShop1' RETURN otherPlace.name, collect(tag.name) ORDER BY length(collect(tag.name)) DESC , otherPlace.name
This query returns other places than CoffeeShop1 which share the same tags; they are ranked by the number of tags.
Result
| otherPlace.name | collect(tag.name) |
|---|---|
| 3 rows | |
|
|
|
|
|
|