Possible answers in comments


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], 
from Posts inner join Users on
  Users.id = Posts.OwnerUserId 
inner join Comments on
  Posts.Id = Comments.PostId
  (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

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