8

I was wondering if it is also possible to search for questions which are unanswered AND also lack any comments? I could not find it here or using Google.

  • Is there a reason to want to do this? The network deliberately view comments as 'expendable' so they are not generally part of searching ... – Joseph Wright Oct 2 '16 at 11:13
  • 1
    @JosephWright If you want to find unanswered questions, which are not resolved in the comments. – Roald Oct 2 '16 at 11:15
  • Not all questions that have comments but no answers are automatically answered by the comments. Some are, true. You can browse all unanswered questions, have a look at the comments (if any) and ping the user who gave the answer or even flag as duplicate or unclear. It is a bit more work, but it is much more helpful in the long run. My opinion at least. – Johannes_B Oct 5 '16 at 18:01
  • @Johannes_B That is true. Although I find that when I look through those questions, I come across quite a few which were answered in the comments and I did not want to make community wiki answers for them all. – Roald Oct 5 '16 at 20:45
  • 2
    @Roald Pinging the user who answered is definitely not writing a CW answer. – cfr Oct 6 '16 at 3:29
12

You can only link the two databases containing posts and comments using the SEDE. The following query lists questions on the main site, sorted by their last activity date (oldest to newest) with these attributes:

  • No comment

  • No answer

  • Not closed

  • Positive score

select top 1000
    p.id as [Post Link],
    p.lastactivitydate as [Last Active]
from posts p
left outer join comments c on c.postid = p.id
where p.posttypeid = 1 -- Questions
and c.id is null
and answercount = 0 
and p.score > 0
and closeddate is null
order by lastactivitydate

You must log in to answer this question.

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