获取精神障碍人员活动轨迹数据 SQL 语句

SELECT c51 AS key_person_category_name, c223 AS device_code, c148 AS device_name, c228 AS mentally_ill_last_snap_face_url, c229 AS mentally_ill_last_snap_bkg_url, c44 AS mentally_ill_person_type, c47 AS mentally_ill_human_id, c48 AS mentally_ill_gender_name, c45 AS mentally_ill_name, c208 AS mentally_ill_contact_phone, c49 AS mentally_ill_cert_num, key_person_face_time AS mentally_ill_face_time, c141 AS suspected_out_alone_flag, guardian_face_time AS guardian_face_time, c133 AS guardian_name, c134 AS guardian_human_id, c135 AS guardian_gender_name, c192 AS guardian_relation_name, c138 AS guardian_cert_num, c130 AS guardian_person_type, c139 AS guardian_contact_phone, c200 AS reg_community_code, c201 AS reg_community_name, c193 AS calc_date FROM (SELECT c51, c223, c148, c228, c229, c44, c47, c48, c45, c208, c49, key_person_face_time, c141, guardian_face_time, c133, c134, c135, c192, c138, c130, c139, c200, c201, c193 FROM (SELECT c200, c201, c208, c47, c45, c49, c44, c48, c51, c223, c228, c229, c148, FROM_UNIXTIME(CAST(c226 / 1000 AS BIGINT)) AS key_person_face_time, c192, c130, c133, c134, c135, c138, c139, FROM_UNIXTIME(CAST(c241 / 1000 AS BIGINT)) AS guardian_face_time, CASE WHEN c138 IS NULL THEN '肇事肇祸无监护人信息' WHEN guardian_face_time IS NULL THEN '肇事肇祸疑似单独外出' ELSE '人员活动正常' END AS c141, CURRENT_DATE() AS c193 FROM (SELECT t1.c200, t1.c201, t1.c208, t1.c47, t1.c45, t1.c49, t1.c44, t1.c48, t1.c51, t1.c223, t1.c228, t1.c229, t1.c148, t1.c226, t2.c192, t2.c130, t2.c133, t2.c134, t2.c135, t2.c138, t2.c139, t3.c241 FROM node_initModelNodeCodeValue_41 t1 LEFT JOIN node_initModelNodeCodeValue_37 t2 ON t1.c49=t2.c35 LEFT JOIN node_initModelNodeCodeValue_33 t3 ON t2.c134=t3.c239 AND t1.c223=t3.c238 AND ABS(t1.c226-t3.c241)<=300000) tempt) tempt) tempt;