Questions where comments prevent deletion

0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackexchange.com/questions/78048/ If the question is more than 365 days old, and ... has a score of 0 or a score of 1 with a deleted owner has no answers is not locked has a viewcount <= the age of the question in days times 1.5 has 1 or 0 comments ... it will be automatically deleted.

Stack Overflow

Q&A for professional and enthusiast programmers

with T as (
select
  q.id as [Post Link],
  q.score,
  q.commentCount,
  q.closedDate,
  q.viewCount
from
  Posts q
  join PostHistory ph on (ph.postid = q.id)
where
  q.creationDate >=
    CONVERT (datetime, ##StartDate:string?2013.01.01## , 102)
  and q.creationDate <=
    CONVERT (datetime, ##EndDate:string?2013.01.31## , 102)
  and q.PostTypeId = 1
  and not exists (
    select 1
    from
      PostHistory ph
    where
      ph.PostId = q.id
      and ph.PostHistoryTypeId = 14
  )
  and ph.PostHistoryTypeId = 10
  and q.score <= ##QScore:int?1##
  and (q.answerCount = 0 or q.answerCount is null)
  )
  
  Select TOP(##RowsReturned:int?100##) * from T
  order by T.score, T.commentCount

Enter Parameters

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