odbtools/odbctest/mql/uino/095.concur.mql

/** fork(第一组) **/;

SELECT building.id AS "id", building.name AS "name", building.unique_number AS "unique_number", building.level_directory AS "level_directory", building.superior_space AS "superior_space", building.usable_area AS "usable_area", building.construction_area AS "construction_area", building.above_ground_floors AS "above_ground_floors", building.underground_floors AS "underground_floors", building.business_remark AS "business_remark", building.address AS "address", building.coordinates AS "coordinates", building.fireproof_rating AS "fireproof_rating", building.earthquake_resistance_rating AS "earthquake_resistance_rating", building.pinyin_abbreviation AS "pinyin_abbreviation", building.affiliated_hospital AS "affiliated_hospital", building.affiliated_campus AS "affiliated_campus", building.superior_space_address AS "superior_space_address", building.superior_space_number AS "superior_space_number", building.total_rooms AS "total_rooms", building.owner AS "owner", building.creator AS "creator", building.creation_time AS "creation_time", building.last_modification_time AS "last_modification_time", building.last_modifier AS "last_modifier" FROM /hxyy/building building LIMIT 0, 20000 WITH TIMEOUT = 60m
;

MATCH (building:/hxyy/building)-[: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) RETURN floor.floor_number AS "floor_num" INTO /temp_floor_count_bec7ff96-36a5-45d0-b0f2-e444e1032e3d-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT count(DISTINCT temp.floor_num) AS \"floor_count\" FROM /temp_floor_count_bec7ff96-36a5-45d0-b0f2-e444e1032e3d-0 temp LIMIT 0, 20000"}
;

MATCH (building:/hxyy/building)-[: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) RETURN room.usable_area AS "usable_area" INTO /temp_room_area_3a2b1c WITH TIMEOUT = 60m
;

{"sql":"SELECT sum(temp.usable_area) AS \"total_usable_area\" FROM /temp_room_area_3a2b1c temp LIMIT 0, 20000"}
;

/** fork(第二组) **/;

MATCH (building:/hxyy/building)-[: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)-[:room_personnel_info_to_person_job_number*1..1]->(person:/hxyy/person) RETURN person.job_number AS "job_number", person.name AS "name", person.work_department AS "work_department" WITH TIMEOUT = 60m
;

/** fork(第三组) **/;
MATCH (building:/hxyy/building)-[: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 excess_area > 0) RETURN room.room_number AS "room_number", room.name AS "_hxyy_room_name_0" WITH TIMEOUT = 60m
;

/** fork(第四组) **/;
MATCH (building:/hxyy/building)-[: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 excess_area > 0)-[:room_personnel_info_to_person_job_number|room_safety_responsible_person_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 AS "person_position", room.name AS "_hxyy_room_name_0" WITH TIMEOUT = 60m
;

/** fork(第五组) **/;
MATCH (building:/hxyy/building)-[: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 office_staff_count > 0) RETURN room.usable_area AS "usable_area", room.office_staff_count AS "office_staff_count" INTO /temp_room_data_a0fcf6ac-ba4a-470e-9416-33cc4b6653ce-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT sum(temp.usable_area) AS \"total_usable_area\", sum(temp.office_staff_count) AS \"total_office_staff\", sum(temp.usable_area) / sum(temp.office_staff_count) AS \"per_capita_area\" FROM /temp_room_data_a0fcf6ac-ba4a-470e-9416-33cc4b6653ce-0 temp LIMIT 0, 20000"}
;

/** fork(第六组) **/;
MATCH (building:/hxyy/building)-[: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_function_partition_superior_space_number*1..1]->(function_partition:/hxyy/function_partition) RETURN function_partition.id AS "function_partition_id" INTO /temp_function_partition_count_a6cb412b-f104-4319-9d39-28da7f2e51b5-1 WITH TIMEOUT = 60m
;

{"sql":"SELECT count(temp.function_partition_id) AS \"function_partition_count\" FROM /temp_function_partition_count_a6cb412b-f104-4319-9d39-28da7f2e51b5-1 temp LIMIT 0, 20000"}
;

/** fork(第七组) **/;

MATCH (building:/hxyy/building)-[: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) RETURN room.using_department AS "department", room.name AS "_hxyy_room_name_0" INTO /temp_departments_1847a806-643d-4785-a812-f5764c8893ab-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT DISTINCT temp.department AS \"department\", temp._hxyy_room_name_0 AS \"_hxyy_room_name_0\" FROM /temp_departments_1847a806-643d-4785-a812-f5764c8893ab-0 temp LIMIT 0, 20000"}
;

/** fork(第八组) **/;

MATCH (building:/hxyy/building)-[: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) RETURN room.usable_area AS "usable_area" INTO /temp_room_area_12345_0a299315-2d33-4ece-9dee-bf0fec597b1f-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT sum(temp.usable_area) AS \"total_usable_area\" FROM /temp_room_area_12345_0a299315-2d33-4ece-9dee-bf0fec597b1f-0 temp LIMIT 0, 20000"}
;

/** fork(第九组) **/;

SELECT building.construction_area AS "construction_area", building.name AS "_hxyy_building_name_0" FROM /hxyy/building building LIMIT 0, 20000 WITH TIMEOUT = 60m
;

/** fork(第十组) **/;

MATCH (building:/hxyy/building)-[: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 space_purpose like '*卫生间*') RETURN room.id AS "room_id" INTO /temp_room_count_37533ef6-188e-4d6a-bba7-8db0fe0f264e-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT count(temp.room_id) AS \"room_count\" FROM /temp_room_count_37533ef6-188e-4d6a-bba7-8db0fe0f264e-0 temp LIMIT 0, 20000"}
;

/** fork(第十一组) **/;
MATCH (building:/hxyy/building)-[: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 space_purpose like '*卫生间*') RETURN room.id AS "room_id" INTO /temp_room_count_cf80c513-d986-40df-8d10-1bce42bc661a-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT count(temp.room_id) AS \"room_count\" FROM /temp_room_count_cf80c513-d986-40df-8d10-1bce42bc661a-0 temp LIMIT 0, 20000"}
;

/** fork(第十二组) **/;
MATCH (building:/hxyy/building)-[: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) RETURN room.id AS "room_id" INTO /temp_rooms_77c96527-11cd-4f43-ab02-b59dd2a3e816-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT count(temp.room_id) AS \"room_count\" FROM /temp_rooms_77c96527-11cd-4f43-ab02-b59dd2a3e816-0 temp LIMIT 0, 20000"}
;

/** fork(第十三组) **/;
MATCH (building:/hxyy/building)-[: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) RETURN room.room_number AS "room_number", room.using_department AS "using_department", room.name AS "_hxyy_room_name_0" WITH TIMEOUT = 60m
;

/** fork(第十四组) **/;
MATCH (building:/hxyy/building)-[: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) RETURN room.using_department AS "department" INTO /temp_room_departments_ac1d4967-a4bb-4608-a3ab-caffb9862b31-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT temp.department AS \"department\", count(temp.department) AS \"room_count\" FROM /temp_room_departments_ac1d4967-a4bb-4608-a3ab-caffb9862b31-0 temp GROUP BY temp.\"department\" LIMIT 0, 20000"}
;

/** fork(第十五组) **/;
MATCH (building:/hxyy/building)-[: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) RETURN room.id AS "room_id", room.name AS "_hxyy_room_name_0" WITH TIMEOUT = 60m
;

/** fork(第十六组) **/;
SELECT building.id AS "id", building.name AS "name" FROM /hxyy/building building LIMIT 0, 20000 WITH TIMEOUT = 60m
;

/** fork(第十七组) **/;
MATCH (campus:/hxyy/campus)-[:campus_unique_number_to_building_superior_space_number*1..1]->(building:/hxyy/building) RETURN campus.name AS "campus_name" WITH TIMEOUT = 60m
;

/** fork(第十八组) **/;
MATCH (building:/hxyy/building)-[: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 usable_area > 100 AND space_purpose like '*机房*') RETURN room.room_number AS "room_number", room.usable_area AS "usable_area", room.space_purpose AS "space_purpose", room.name AS "_hxyy_room_name_0" WITH TIMEOUT = 60m
;

/** fork(第十九组) **/;
MATCH (building:/hxyy/building)-[: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 space_purpose like '*卫生间*') RETURN room.id AS "room_id" INTO /temp_room_count_960c19e8-77e5-4f7e-b9c6-550f2d50c1f1-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT count(temp.room_id) AS \"room_count\" FROM /temp_room_count_960c19e8-77e5-4f7e-b9c6-550f2d50c1f1-0 temp LIMIT 0, 20000"}
;

/** fork(第二十组) **/;
MATCH (building:/hxyy/building)-[: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 space_purpose like '*卫生间*') RETURN room.id AS "room_id" INTO /temp_room_count_eb555b54-0709-49dd-acc8-a4cba3d84e55-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT count(temp.room_id) AS \"room_count\" FROM /temp_room_count_eb555b54-0709-49dd-acc8-a4cba3d84e55-0 temp LIMIT 0, 20000"}
;

/** fork(第二十一组) **/;

SELECT building.unique_number AS "unique_number", building.name AS "_hxyy_building_name_0" FROM /hxyy/building building LIMIT 0, 20000 WITH TIMEOUT = 60m
;

/** fork(第二十二组) **/;

MATCH (building:/hxyy/building)-[: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 usable_area > 100 AND space_purpose like '*机房*') RETURN room.room_number AS "room_number", room.usable_area AS "usable_area", room.space_purpose AS "space_purpose", room.name AS "_hxyy_room_name_0" WITH TIMEOUT = 60m
;

/** fork(第二十三组) **/;

MATCH (building:/hxyy/building)-[: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) RETURN room.doorplate_info AS "doorplate_info", room.room_number AS "room_number", room.using_department AS "using_department", room.name AS "_hxyy_room_name_0" WITH TIMEOUT = 60m
;

/** fork(第二十四组) **/;
MATCH (building:/hxyy/building)-[: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_function_partition_superior_space_number*1..1]->(function_partition:/hxyy/function_partition) RETURN function_partition.usable_area AS "usable_area" INTO /temp_function_partition_areas_58357335-ef73-42cb-ace6-b84f9568a9d4-1 WITH TIMEOUT = 60m
;

{"sql":"SELECT sum(temp.usable_area) AS \"total_usable_area\" FROM /temp_function_partition_areas_58357335-ef73-42cb-ace6-b84f9568a9d4-1 temp LIMIT 0, 20000"}
;

/** fork(第二十五组) **/;
MATCH (building:/hxyy/building)-[: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) RETURN room.usable_area AS "usable_area" INTO /temp_room_area_9a8b7c6d-5e4f-3g2h-1i0j-9k8l7m6n5o4p_8a3b1cbf-b912-4a08-a030-1c23a400381f-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT sum(temp.usable_area) AS \"total_area\" FROM /temp_room_area_9a8b7c6d-5e4f-3g2h-1i0j-9k8l7m6n5o4p_8a3b1cbf-b912-4a08-a030-1c23a400381f-0 temp LIMIT 0, 20000"}
;

/** fork(第二十六组) **/;
MATCH (building:/hxyy/building)-[: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 office_staff_count > 0) RETURN room.usable_area AS "usable_area", room.office_staff_count AS "office_staff_count" INTO /temp_room_area_375db1d8-9123-4f43-a274-5884bcaea82d_1be3a550-dcbc-4cd5-a84e-f9b9b57b46ba-0 WITH TIMEOUT = 60m
;

{"sql":"SELECT sum(temp.usable_area) AS \"total_usable_area\", sum(temp.office_staff_count) AS \"total_office_staff\", sum(temp.usable_area) / sum(temp.office_staff_count) AS \"per_capita_area\" FROM /temp_room_area_375db1d8-9123-4f43-a274-5884bcaea82d_1be3a550-dcbc-4cd5-a84e-f9b9b57b46ba-0 temp LIMIT 0, 20000"}
;

/** fork(第二十七组) **/;

MATCH (building:/hxyy/building)-[: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 usable_area > 100 AND space_purpose like '*机房*') RETURN room.room_number AS "room_number", room.usable_area AS "usable_area", room.space_purpose AS "space_purpose", room.name AS "_hxyy_room_name_0" WITH TIMEOUT = 60m
;

/** fork(第二十八组) **/;
MATCH (building:/hxyy/building)-[: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 office_staff_count > 0) RETURN room.usable_area AS "usable_area", room.office_staff_count AS "office_staff_count" INTO /temp_room_area_1_1b3c3426-a214-436b-825b-a72c93af0b16-1 WITH TIMEOUT = 60m
;

{"sql":"SELECT sum(temp.usable_area) AS \"total_usable_area\", sum(temp.office_staff_count) AS \"total_office_staff\", sum(temp.usable_area) / sum(temp.office_staff_count) AS \"per_capita_area\" FROM /temp_room_area_1_1b3c3426-a214-436b-825b-a72c93af0b16-1 temp LIMIT 0, 20000"}
;

/** fork(第二十九组) **/;
MATCH (building:/hxyy/building)-[: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 usable_area > 100 AND space_purpose like '*机房*') RETURN room.room_number AS "room_number", room.usable_area AS "usable_area", room.space_purpose AS "space_purpose", room.name AS "_hxyy_room_name_0" WITH TIMEOUT = 60m
;