Questions kept alive by your comments

2

Please login or register to vote for this query.

(click on this box to dismiss)

These questions would be automatically deleted by the RemoveAbandonedQuestions job, if they didn't have at least two comments. Some of these comments were written by you (or by the user whose user ID you've entered below, if not your own). If the feature request at http://meta.stackoverflow.com/q/333477 passes, these questions will be deleted. Would you like to convert any of your comments into answers before that happens?

Stack Overflow

Q&A for professional and enthusiast programmers

select
  Posts.Id as [Post Link],
  Posts.Score as [Score],
  Posts.CommentCount as [Comments],
  Posts.CreationDate as [Asked],
  Comments.CreationDate as [Commented],
  Comments.Score as [Upvotes],
  Comments.Text as [Comment]
from Comments
  join Posts on Posts.Id = Comments.PostId
where Comments.UserId = ##UserId##
  and Posts.PostTypeId = 1
  and Posts.CreationDate < DateAdd(Day, -365, GetUTCDate())
  and Posts.Score < 1
  and (Posts.Score < 0 or Posts.OwnerUserId is null)
  and Posts.AnswerCount = 0
  -- TODO: add check for "is not locked" here
  and Posts.ViewCount <= 1.5 * DateDiff(Day, Posts.CreationDate, GetUTCDate())
  and Posts.CommentCount > 1
order by Posts.Id, Comments.Id

Enter Parameters

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