22

How can I find posts which have been inactive for 6 months, as per the requirement for the Archaeologist badge? Is there some kind of search query or something?

18

There are various SEDE queries that could help you find posts eligible for Archaeologist, you can start with this one: Which posts are eligible for Archaeologist edits?

Keep in mind that:

  1. SEDE data aren't exactly fresh, check the front page to see when they were last updated for each site,
  2. Editing en masse to get a badge is generally frowned up, especially if your edits are minor.
  • 2
    To clarify what @Yannis was saying in #2, Ankur, every edit you make bumps the post back up to the top of the active page, so if you make a lot of minor edits, someone will notice. So be sure your edits substantially improve the post. Be sure to fix all of the problems with the post if you're going to edit one. Good luck! :) – jmort253 Oct 6 '12 at 20:15
  • 5
    Interesting, running the query you suggest yields this: The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information. – fontno May 15 '13 at 2:49
  • 1
    Yes, best to add a TOP clause to limit the number of results. e.g. SELECT TOP 1000 P.Id AS – Nico Van Belle Jun 15 '17 at 13:29
8

What I do is sort questions by activity and go to a random high-numbered page: if it had had activity within 6 monthes, if would be on a smaller-numbered page.

You must log in to answer this question.

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