Possible answers in comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

-- 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 and
  Tags LIKE '%<##Tag##>%'
order by len(posts.body) asc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results