1

Please login or register to vote for this query.

(click on this box to dismiss)

Intended to find short answers with links for people to improve, downvote or delete. Additional fields (closed date, and answer count) help identify questions that attract these short answers that should be modified or closed. Find answers with marginal votes (between the min and max) that have a length less than some size and contain a link. Filter out questions that have been locked (many historical lock questions provide false positives).

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

select
  a.Score, LEN(a.Body) as length,
  q.closedDate,
  q.AnswerCount as AnswerCount,
  a.Id as [Post Link],
  a.body
from
  Posts a,
  Posts q
where
  a.PostTypeId = 2
  and a.Score <=  ##AnswerScoreMax:int##
  and a.Score >= ##AnswerScoreMin:int##
  and LEN(a.Body) < ##AnswerLength##
  and UPPER(a.body) like '%HTTP://%'
  and a.ParentId = q.id
  and not exists (
    select 1
    from
      PostHistory ph
    where
      ph.PostId = q.id
      and ph.PostHistoryTypeId = 14
  )
order by length ASC, a.Score ASC

view current version

edited mar 20 13

created mar 12 13 MichaelT