List of deleted questions tagged sandbox: data.stackexchange.com/meta.stackexchange/query/883845/… (At the moment, the newest question among the results of the query if from 2021.)

@MartinSleziak I assume Tags is a derived value and only stored in the Posts table for performance reasons. Therefor, what you see on the site is in the database. As you see the current tags on a deleted post you will see the current tags in the PostWithDeleted.Tags field. One way to verify if a post was edited after its deletion is to compare deletiondate and lasteditdate

But I'm curious to see if my above reasoning holds when faced with reality.

I have added LastEditDate to the query - but it seems that this one is not shown in PostsWithDeleted: data.stackexchange.com/meta.stackexchange/query/1604264/…

In any case, the tags are shown now in the updated version - i.e., they include the changes made after the deletion:

Tags,Id,Post Link,CreationDate,DeletionDate,LastEditDate,LastActivityDate,Revision History
"<support><sandbox>","379267","379267","2022-06-04 07:47:30","2022-06-04 07:49:56","","","site://posts/379267/revisions"
"<support><sandbox><pdf><metadata>","379278","379278","2022-06-04 16:11:44","2022-06-04 16:44:49","","","site://posts/379278/revisions"
"<support><sandbox>","379466","379466","2022-06-11 05:05:19","2022-06-11 07:21:41","","","site://posts/379466/revisions"

@rene As far as I can tell, LastActivityDate and LastEditDate are not shown for the deleted post.

@MartinSleziak ah, right. that is a bummer.

But regardless of that, as you can see above, the tags in SEDE show the existing version. (I.e., they were updated in accordance with edits made after the deletion.)

It is interesting to know that PostsWithDeletedshows the real status - not simply the tags as they were at the time of deletion.

yep.