Questions kept alive by your comments


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 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

  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:int##
  and Posts.PostTypeId = 1
  and Posts.CreationDate <= DateAdd(Day, -##MinAge:int?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 (##IgnoreViews:int?0## > 0 or 2 * Posts.ViewCount <= 3 * DateDiff(Day, Posts.CreationDate, GetUTCDate()))
  and Posts.CommentCount > 1
order by Posts.Id, Comments.Id

-- UserId: User ID "List only question with comments by this user."
-- MinAge: Minimum Q age (days) "Only list questions at least this many days old. The roomba only deleted questions older than 365 days."
-- IgnoreViews: Ignore view count (0/1) "If set to 1, list questions even if they're currently ineligible for deletion due to getting more than 2/3 views per day."

Enter Parameters

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