UPDATE contracts c JOIN company_authorized_agents caa ON caa.id = c.signing_representative_id AND caa.company_id = c.company_id SET c.signing_representative_id = caa.company_staff_id WHERE caa.company_staff_id IS NOT NULL AND NOT EXISTS (SELECT 1 FROM company_authorized_agents x WHERE x.company_staff_id = c.signing_representative_id AND x.company_id = c.company_id);
