Seek and Destroy: Questions with probably unnecessary late answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

A query to help look for questions getting pointless necro-answers--lots of existing answers, not closed or locked, and low-score answers added months later. Most of this list probably warrants protecting and/or closing.

Stack Overflow

Q&A for professional and enthusiast programmers

select q.id as [Post Link], q.Tags, q.score as [Question Score], q.answercount as [Total Answers],
  q.creationDate as [Question Asked], max(a.creationdate) as [Last Answer Posted]
from posts a
  inner join posts q on a.parentid = q.id
  inner join users u on a.owneruserid = u.id
  left outer join (
    select * from posthistory ph 
    where ph.posthistorytypeid = 14
  ) locks on locks.postid = q.id
where datediff(month, q.creationdate, a.creationdate) > 6 -- very late answers
  and a.score < 2                                         -- that probably weren't great
  and q.closeddate is null                                -- on still-open questions
  and q.answercount > 25                                  -- with too many answers already
  and u.reputation < 10000                                -- pretend 10k users know better
  and locks.id is null                                    -- ignore locked questions
group by q.id, q.score, q.answercount, q.creationdate, q.Tags
order by q.Tags desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results