select * from security_flow.tlk_certificate where ITEM_signatured_processed_status=3 ;

update security_flow.tlk_certificate set ITEM_signatured_processed_status=0
                                     where item_documentid in (select t.idnum from bg_screening_users t where t.authenticated_status=3)
                                       and ITEM_signatured_processed_status=3 and ITEM_last_signatured_processed_result not like '%身份证头像%';