Cliff Questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Closed questions that are on the cliff of having Community delete them as part of cleanup. See http://meta.stackoverflow.com/questions/78048/enable-automatic-deletion-of-old-unanswered-zero-score-questions-after-a-year/92006#92006 for more information about the cliff.

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

select
  q.id as [Post Link],
  q.closedDate,
  q.score as "Q Score",
  answers.scores as "A Scores",
  case ph.Comment
    when 1 then 'Dup'
    when 2 then 'Off Topic'
    when 3 then 'Subjective'
    when 4 then 'NARQ'
    when 7 then 'TL'
    --- These are P.SE close reasons
    when 101 then 'Dup v2'
    when 102 then 'Recommend'
    when 103 then 'Unclear'
    when 104 then 'Too broad'
    when 105 then 'Opinion'
    else ph.Comment
  end as "Close Reason",
  q.viewCount as "Views",
  answers.blen as "Answer length"
from
  Posts q
  join (
    select
      a.parentId as pid,
      sum(a.score) as scores,
      sum(len(a.body)) as blen
    from
      Posts a
    where
      a.PostTypeId = 2
      and a.score > 0
    group by
      a.parentId
    having
      sum(a.score) <= ##PositiveAnswerScore:int?2##
      and sum(len(a.body)) <= ##AnswerLen:int?1000##
  ) answers on (q.id = answers.pid)
  join PostHistory ph on (ph.postid = q.id)
where
  q.closedDate is not null
  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?2##
  and q.score + answers.scores <= ##SumScore:int?2##
  and ph.Comment not in (1, 101) --- No dups
  and q.AcceptedAnswerId is null

Enter Parameters

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