Questions kept alive by comments for given tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

select
  Posts.Id as PostId,
  Posts.Score as PostScore,
  Posts.ViewCount as PostViews,
  Posts.CreationDate as PostDate,
  Posts.CommentCount as PostComments
from Posts
where Posts.PostTypeId = 1
  and Posts.Score = 1
  and Posts.AnswerCount = 0
  and Posts.CommentCount > ##commentCount:int##
  and Posts.Tags LIKE '%<' + ##tag:string## + '>%'

Enter Parameters

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