0

Please login or register to vote for this query.

(click on this box to dismiss)

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

with FoundComments as (select
  Posts.Id as PostId,
  Posts.Score as PostScore,
  Posts.ViewCount as PostViews,
  Posts.CreationDate as PostDate,
  Posts.CommentCount as PostComments
from Comments
  join Posts on Posts.Id = Comments.PostId
where Posts.PostTypeId = 1
  and Posts.Score = 1
  and (Posts.Score = 0 or Posts.OwnerUserId is null)
  and Posts.AnswerCount = 0
  and Posts.CommentCount > ##commentCount:int##
  and Posts.Tags LIKE '%<' + ##tag:string## + '>%'
)
select
  PostId as [Post Link],
  PostScore as [Score],
  PostViews as [Views],
  PostComments as [Comments]
from FoundComments as F

fork query

edited nov 26 anonymous

created sep 1 16 Ilmari Karonen