As a mod on RPG.SE, I'd like to be able to find questions with extant delete votes, either in the site search or in the Review section if the Review section didn't remove questions with delete votes whenever one person reviewed them. (I wish it worked like that with close votes too actually, if a question with one close vote gets reviewed and gets a second close vote, then it's gone from the review queue - that helped how? Our users are pretty on top of the review queues but for multivote actions that then deprives mods and other users of further review action).

We don't have SO numbers of users, so it's very unusual for a question to get enough delete votes to really delete it (especially given that you have to be on motivated post-close cleanup duty to get around to it). Usually on our site if a question has 2 or more delete votes it's unquestionably trash. I'd like to be able to go look at questions with outstanding delete votes to see if they need mod-deleting.

  • go to Programmers.SE chat (Whiteboard room), ask MichaelT - he posted SEDE script there to look for questions having delete votes (I tried it once, works like a charm... except that most of the questions it found had my vote already:) – gnat Apr 25 '14 at 13:31

This is the query that gnat mentioned in the comments. A nice feature of it is that you can specify how many results you want returned.

It was originally written by Shadow Wizard and MichaelT updated it so you could filter by number of votes needed.

  • 2
    +1, this will be really helpful for Code Golf and other beta sites! – Doorknob Apr 25 '14 at 14:29
  • 2
    This is very helpful - IMO it should be actual mod functionality though! I appreciate SEDE scripts but that's a stopgap for a better integrated implementation. – mxyzplk - Justice for Monica Apr 25 '14 at 19:28

There's this query to find questions with a single delete vote left:


Just comment out the - COUNT(v.VoteTypeId)=1 part to get them by delete votes left to be removed.

You must log in to answer this question.

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