应用ID:__oSi0GbbYmn1RtxZ4FVB
视图ID:__XUx4E0QmsopnmW7Ep3F
脚本:
SELECT count(1) AS sum FROM companyinfocollect.employees b INNER JOIN ( SELECT  t1.employee_id, t1.name, t1.creator_created_time, DATE_FORMAT(t1.creator_created_time, '%Y-%m-%d') AS item_xlcpdate FROM obpm2.tenant_xlcp t1 INNER JOIN ( SELECT employee_id, MAX(creator_created_time) as max_time FROM obpm2.tenant_xlcp GROUP BY employee_id ) t2 ON t1.employee_id = t2.employee_id AND t1.creator_created_time = t2.max_time ) a ON a.employee_id = b.employee_id WHERE b.leave_date IS NULL AND b.occupation_type = 1 AND a.creator_created_time < DATE_SUB(CURDATE(), INTERVAL 6 MONTH)  AND b.item_domain_id = #{id}