Possible answers in comments

1

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

-- Get posts which might have answers in comments, but not made into full answers just yet


select top 500
  Posts.Id as [Post Link], 
  Posts.Score, 
  ViewCount 
from Posts inner join Users on
  Users.id = Posts.OwnerUserId 
inner join Comments on
  Posts.Id = Comments.PostId
where
  (Comments.Text LIKE '%might be%' OR Comments.Text LIKE '%try%') AND
  Posts.Score > 0 and 
  ViewCount <> 0 and 
  ParentId is null and 
  AcceptedAnswerId is null and
  AnswerCount < 1 and
  ClosedDate is null
order by len(posts.body) asc

Enter Parameters

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