I have a lot of projects that were archived on an older version of Harvest, I know that is not possible to restore them. We are on a current version of Harvest. Do you have a query to remove these projects directly from the database?   

Release:
Component: CCC-BI

You can use the hmvproj command with the "DELETEONLY" option that will delete a project.