It's common practice in your organization to archive projects in the following way:
✑ The name of archived projects will get the prefix ARCH_
Archived projects will be assigned the project category ARCHIVE
Recently many projects were archived.
Which JQL query will tell you if there are any unresolved issues in those projects?