I was writing an exploratory query to see what the average lifespan of questions which are closed as duplicates are then deleted, when I ran into a snag: it doesn't seem like the
PostHistory table contains any entries of posts which have been deleted.
Here's the exploratory query that I used:
SELECT Id [Post Link] FROM PostsWithDeleted pwd WHERE pwd.Id IN ( SELECT PostId FROM PostHistory ph WHERE ph.PostHistoryTypeId = 10 AND (ph.Comment = '1' OR ph.Comment = '101') ) AND pwd.DeletionDate IS NOT NULL;
I'm well aware that the magic Post Link will break under these circumstances, but it was there due to me fiddling with
IS NULL and
IS NOT NULL in the database.
Is it the case that I can't go any further as a mere mortal? If so, is there a specific reason that I don't have any further access to the post's history from SEDE?