A static query is like taking a snapshot of the database at the time the query is created. Only the records selected when the query is first created will be included when the query is used in the program. The same constituents are still in the static query so you can easily find them again if the need arises. Sometimes the static query may later contain a different grouping, or 0 records.
Static queries create a new table in the database that contains the records in the query. If the query is refreshed and saved, this table is overwritten with the new records that meet the criteria.
If the query is refreshed and resaved when it contains 0 records, the underlying table is emptied, and those records can't be restored unless they meet the criteria again.
Steps to Duplicate
With the static query already created, click Export in the left navigation bar
Click New Export
Choose Excel as the export format
Click Create Now
Click on the Include button
Choose Selected Records
Find the name of the static query
Click Open on the far right
Mark the button to export both constituents separately
Mark the checkboxes to include constituents who are inactive, deceased, and no valid address