List of archived projects from Jira DB corresponding to a specific issue type

[Bharathi]

I have a Jira server where project archival is done this way - https://confluence.atlassian.com/adminjiraserver/archiving-a-project-938847621.html

I would need to fetch a list of archived projects from SQL DB using queries. The projects should be filtered by a specific issue type. Came across this article https://confluence.atlassian.com/jirakb/list-of-archived-projects-from-database-976763219.html but need to know if the projects can be filtered based on a specific issue type and if yes, how to do that?

Thanks!