Cliff questions (v2)


Please login or register to vote for this query.

(click on this box to dismiss)

Cliff questions are questions on the cliff of being deleted by the automatic cleanup. See for more information on this cleanup. Often, it will take just one or two downvotes to push it over the cliff into deletion. Frankly, there's a lot of crap just sitting on the edge that isn't helping anyone, but got an upvote somewhere along the way.

Academia Meta

Q&A about the site for academics and those enrolled in higher education

with T as (
select as [Post Link],
  q.score as "qScore",
  answers.scores as "aScores",
  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"
  Posts q
  join (
      a.parentId as pid,
      sum(a.score) as scores,
      sum(len(a.body)) as blen
      Posts a
      a.PostTypeId = 2
      and a.score > 0
    group by
      sum(a.score) <= ##PositiveAnswerScore:int?2##
      and sum(len(a.body)) <= ##AnswerLen:int?1000##
  ) answers on ( =
  join PostHistory ph on (ph.postid =
  q.closedDate is not null
  and q.PostTypeId = 1
  and not exists (
    select 1
      PostHistory ph
      ph.PostId =
      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
  Select TOP(100) * from T
  order by T.qScore + T.aScores

Enter Parameters

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