I don't have a Revival badge yet, and thinking that I'm missing out on something SE wants to encourage, I decided to try for one. However, I found that it is not easy even to find a candidate for Revival, let alone a question that needs a better answer. So could someone write a query that filters out all questions except those which are >30 days old and with no answers that have 2 score or more?

Edit: I am an ELU user, if that makes a difference.

Edit: I asked this on SO, and got a response, resulting in this query.


Here's the query you asked for:


The query allows filtering by question score and by tag(s). Note that the tag separating characters vary from SE site DB to SE site DB (¿bug?).

It "currently" shows 231 eligible questions (with score >= -5).

Keep in mind that the SEDE lags about a month from live data, but that probably only matters for the "freshest" questions.

  • I can't get it to work without entering tags, which I don't want to do. Am I missing something? – Daniel Sep 2 '11 at 19:16
  • Just enter a single space instead of the tags, I tested it, and it works fine that way. Alternatively, enter a single underscore (_). Here is a direct link to the query with minScore = 0, and all tags allowed. – Awesome Poodles Sep 2 '11 at 19:33
  • Also, the query I was given on SO gives 559 results. Why does yours give only 230? – Daniel Sep 2 '11 at 19:36
  • The query you were given for this SO question returns questions that already have accepted answers! I'm not sure if you can get the revival badge at all on such questions, but it seems a lot less likely -- since the Q has already been "resolved". – Awesome Poodles Sep 2 '11 at 19:44
  • OK, I see. I think you can get the badge on such questions; still, it is more likely to get it if you're not answering something that has already accepted an answer. Thanks! – Daniel Sep 2 '11 at 19:46

Here's your "query": https://stackoverflow.com/unanswered/tagged/?tab=newest

Just scroll to the bottom and pick page 1000. If that's not far enough back, try 1100, 1500, &c.

Whoops, I missed that the badge requires no answers with >1 score, rather than >=1 score. The unanswered page will still work, but you'll miss out on some questions that do qualify. I will try to remember to write a query later. Be advised that any query will also be imperfect, since the data dumps are static and old.

  • I edited my question - I am an ELU user, and ELU is a very close site. (E.g. no one has Tumbleweed, Tenacious, or Unsung Hero) So it's hard to find questions that need revival. – Daniel Sep 1 '11 at 18:55
  • 1
    Well, that's even easier, then. There are only two questions that have no answers with >1 score, and both were asked less than 30 days ago. – Pops Sep 1 '11 at 18:57
  • No: I meant the answers did not have >1 score. I'm talking about the Revival badge here. – Daniel Sep 1 '11 at 18:59
  • That part, I did get. That's what the unanswered page does. From its description: "questions with no upvoted answers" (emphasis original). Note that I gave you a link with a date sort, not a votes sort. – Pops Sep 1 '11 at 19:07
  • But not >1 means not 2 or more. I didn't say no upvoted answers. I said no answers that have 2 or more votes. – Daniel Sep 1 '11 at 19:10
  • I already addressed that in my most recent edit by saying "you'll miss out on some questions that do qualify." Any question that has no upvoted answers necessarily has no answers with score of two or more, though. – Pops Sep 1 '11 at 19:12
  • But applied to ELU, your (unanswered tab) method causes me to miss out on all qualifying questions. That's why I asked for a query. – Daniel Sep 1 '11 at 19:18
  • Yes, I already acknowledged that. I don't know what else there is to say. – Pops Sep 1 '11 at 19:21
  • So should I wait until you can write one? – Daniel Sep 1 '11 at 19:27
  • Well, someone needs to write one. It doesn't have to be me. This is not just a valid Meta question, it's also a programming (well, SQL) question. You could ask on Stack Overflow. – Pops Sep 1 '11 at 19:33

You must log in to answer this question.

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