select count(*) as cnt,security_station_id from rd_security_station_person_summary where security_station_id in #{item} group by security_station_id SELECT st.supervise_depart_id, st.supervise_domain_id, st.id, st.`NAME`, st.station_type, p.employee_id FROM rd_security_station_summary st left JOIN rd_security_station_person_summary p ON st.id = p.security_station_id =CURRENT_DATE and st.site_state in ('已完善', '生效') ]]> and p.employee_id in #{item} UPDATE dispatch.rd_employee_summary a JOIN dispatch.rd_security_station_person_summary b ON a.id = b.employee_id JOIN dispatch.rd_security_station_summary c ON c.id = b.security_station_id AND c.site_state in ('已完善', '生效') = CURRENT_TIMESTAMP SET a.supervise_depart_id = c.supervise_depart_id,a.supervise_domain_id='fromStationPerson',a.security_station_id=c.id,a.security_station_name=c.`NAME` ]]> where b.employee_id in #{item}