Marginal short answers with links


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

Stack Overflow на русском

Вопросы и ответы для программистов

  a.Score, LEN(a.Body) as length,
  CASE WHEN q.closedDate is null
    THEN ''
    ELSE 'Closed'
  END as Closed,
  CASE WHEN q.CommunityOwnedDate is null
    THEN ''
    ELSE 'CW'
  END as CommWiki,
  q.AnswerCount as AnswerCount,
  a.Id as [Post Link],
  Posts a,
  Posts q
  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 =
  and q.closedDate is null
  and not exists (
    select 1
      PostHistory ph
      ph.PostId =
      and ph.PostHistoryTypeId = 14
order by length ASC, a.Score ASC

Enter Parameters

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