select distinct t.id_card,t.`start`,t.`end` from ((select distinct(person_name), id_card , date_format( curdate(), "%y-%m-%d 00:00:00" ) start , date_format( curdate(), "%y-%m-%d 23:59:59" ) end, '1' ordertype, '-1' pass from t_contractor_people where person_name in ( select distinct ( b.executor ) from t_task_work_order a left join t_task_work_person b on a.sheet_id = b.hot_work_id where a.valid = '1' and a.work_start_time > date_format( curdate(), "%y-%m-%d 00:00:00