| | |
|---|
| | | </select> |
|---|
| | | <select id="pageDangerMember" |
|---|
| | | resultType="com.panzhihua.common.model.vos.community.acid.ComActAcidDangerMemberVO"> |
|---|
| | | SELECT t1.id, t1.`name`, t1.`status`, t1.record_id, t1.phone, t2.color_mark, t2.acid_test, MAX(t3.create_time) AS checkTime,t.create_time |
|---|
| | | SELECT t1.id, t1.`name`, t1.`status`, t1.record_id, t1.phone, t2.color_mark, t2.acid_test, MAX(t3.create_time) AS checkTime,t1.create_time |
|---|
| | | FROM com_act_acid_danger_member t1 |
|---|
| | | LEFT JOIN com_act_acid_record t2 ON t1.record_id = t2.id |
|---|
| | | LEFT JOIN com_act_acid_check_record t3 ON t1.id = t3.member_id |
|---|
