Potentially Not An Answer answers to review.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 100
  answer.Id as [Post Link],
  answer.Score,
  answer.Body,
  LEN(answer.Body) as Length
FROM
  Posts answer
  INNER JOIN
    Posts question
  ON
    answer.ParentId = question.Id
WHERE
  question.PostTypeId = 1     -- question is a question
AND
  question.ClosedDate IS NULL -- Not closed!
AND
  answer.PostTypeId = 2       -- answer is an answer
  
AND LEN(answer.Body) < 500
AND NOT answer.Score >= 9

AND answer.Body LIKE '%<a href="http%' -- Has a link!
AND answer.Body LIKE '%##Keyword##%'

-- Is a plain text post.
AND NOT answer.Body LIKE '%<blockquote>%'
AND NOT answer.Body LIKE '%<code>%'
AND NOT answer.Body LIKE '%<li>%'
ORDER BY answer.Score - LEN(answer.Body) / 10

Enter Parameters

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