-- MATCH -- (building:/hxyy/building WHERE name = '行政办公楼') -- -[:building_unique_number_to_building_partition_superior_space_number*1..1]-> -- (building_partition:/hxyy/building_partition) -- -[:building_partition_unique_number_to_floor_superior_space_number*1..1]-> -- (floor:/hxyy/floor) -- -[:floor_unique_number_to_floor_partition_superior_space_number*1..1]-> -- (floor_partition:/hxyy/floor_partition) -- -[:floor_partition_unique_number_to_room_superior_space_number*1..1]-> -- (room:/hxyy/room WHERE allocated_area > 0 AND excess_area > 0) -- -[:room_personnel_info_to_person_job_number*1..1]-> -- (person:/hxyy/person) -- /** -- output() -- **/; MATCH (building:/hxyy/building WHERE name = '行政办公楼') -[:building_unique_number_to_building_partition_superior_space_number*1..1]-> (building_partition:/hxyy/building_partition) -[:building_partition_unique_number_to_floor_superior_space_number*1..1]-> (floor:/hxyy/floor) -[:floor_unique_number_to_floor_partition_superior_space_number*1..1]-> (floor_partition:/hxyy/floor_partition) -[:floor_partition_unique_number_to_room_superior_space_number*1..1]-> (room:/hxyy/room WHERE allocated_area > 0 AND excess_area > 0) -[:room_personnel_info_to_person_job_number*1..1]-> (person:/hxyy/person) RETURN room.room_number AS "room_number", person.name AS "person_name", person.party_and_government_post_level AS "party_and_government_post_level" WITH TIMEOUT = 6m /** output() **/ ;