MATCH (origin:Page {page_id: 1267598})-[:parent]->(parent:Page) RETURN origin.page_id AS page_id, origin.canonical AS canonical, parent.page_id AS parent_id UNION ALL MATCH (origin:Page {page_id: 1267598})-[:parent*]->(ancestor:Page) OPTIONAL MATCH (ancestor)-[:parent]->(parent:Page) RETURN ancestor.page_id AS page_id, ancestor.canonical AS canonical, parent.page_id AS parent_id LIMIT 100
JSON (cypher) nested data structure
Table in CSV format