Recently I have bookmarked a classic question (+128 upvotes) that after a couple of weeks has mysteriously disappeared because deleted.
I have to say thanks to my bookmark that allowed me to track it down*, anyway it was just a lucky coincidence.

Do you guys have some way to detect deleted questions with a great number of votes in your awesome backoffice tools**?
With millions of questions to handle, I think it is possible to make some mistakes that could lead to losing sweet and neat answers silently.

* After the proper request, the deleted question was kindly undeleted
** I'm aware of the Locked Status (apparently it was not enough to prevent the question's deletion)


Mods (and 10k users) have list of all recently deleted posts, that we peruse.
Mods of course can undelete, and 10k users can vote to undelete.

Currently we can't immediately see the number of votes on each, but I've created a feature request for that.

  • was your request onored? – systempuntoout Dec 23 '10 at 13:52
  • @systempunttoout Not yet, but it's not [status-declined] either. – C. Ross Feb 22 '11 at 19:44

You can do it yourself via the monthly data dumps. Import two months to compare to the database of your choice and write a query that first filters the older dump for questions with votes >= 100 and joins the results to the new dump with either left join where the right side is null or using a not exists directive.

  • @Joel thanks, is it not possible using Stack Exchange Data Explorer? – systempuntoout Dec 1 '10 at 16:27
  • @systempuntoout No, it is not, because you need copies from two different months loaded into a database at the same time. – Joel Coehoorn Dec 1 '10 at 16:30
  • @Joel Are you saying that because with Data Explorer we can't query deleted answers? – systempuntoout Dec 1 '10 at 16:31
  • 2
    That is correct. Deleted posts are not exported in the monthly data dumps used for the explorer. The only way to detect them is to find posts that were in one dump and not in another, and even then you'll miss many that never made it to a data dump in the first place. – Joel Coehoorn Dec 1 '10 at 16:41
  • @Joel yep, that's why I'm asking it; I think you can do it with a single query against the datastore, isn't it? – systempuntoout Dec 1 '10 at 20:54
  • @system - you can do it with a single query, but only if you've loaded a datastore from two different months to your database. – Joel Coehoorn Dec 1 '10 at 21:56
  • @Joel sorry, I'm talking about the sysadmins or mods, if you have access to the real datastore (not the data dumps) – systempuntoout Dec 1 '10 at 22:10
  • 1
    @system Mods (and 10k users) have list of all recently deleted posts, that we peruse. We can't immediately see the upvotes. I'll request that as a new feature. – C. Ross Dec 2 '10 at 13:40

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .