Short Answers with low score

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 a.id as [Post Link], a.body as [Body], len(a.body) as [Length], a.score
FROM Posts a 
JOIN Posts q 
On q.id = a.parentId
WHERE len(a.body) < 200
and a.PostTypeId = 2 --Post is an answer 
and a.Score < 3 --Score below 3
and q.AcceptedAnswerId <> a.id --Not an accepted answer
ORDER BY len(a.body)

Enter Parameters

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