-- MATCH (grpcont:/aia/grpcont WHERE grpcontno = 'G09***956C')-[:grpcont_risk*1..1]->(risk:/aia/risk), -- (grpcont)-[:grpcont_plan*1..1]->(plan:/aia/plan), -- (plan:/aia/plan)-[:plan_risk*1..1]->(risk:/aia/risk) -- /** -- output() -- **/ -- ; MATCH (grpcont:/aia/grpcont WHERE grpcontno = 'G09***956C')-[:grpcont_risk*1..1]->(risk:/aia/risk), (grpcont)-[:grpcont_plan*1..1]->(plan:/aia/plan), (plan:/aia/plan)-[:plan_risk*1..1]->(risk:/aia/risk) RETURN grpcont.id, plan.id, risk.id -- grpcont.grpcontno AS "grpcontno", grpcont.grppropno AS "grppropno", grpcont.grpname AS "grpname", -- grpcont.grpcity AS "grpcity", risk.riskcode AS "riskcode", risk.riskname AS "riskname", -- risk.risktype AS "risktype", risk.terminationdate AS "terminationdate", grpcont.polprem AS "polprem", -- grpcont.anpvalue AS "anpvalue", grpcont.anpvaluenovat AS "anpvaluenovat", plan.plancode AS "plancode", -- plan.plandesc AS "plandesc", plan.plansumprem AS "plansumprem" WITH TIMEOUT = 600m /** output() **/ ;