A query to help look for non-answers--comments with the phrase "not an answer" on answers with low score. Flags ahoy! But try not to *completely* overwhelm the poor moderators, 'k?
Q&A for serious players and enthusiasts of chess
select a.id as [Post Link],
a.score as [Answer Score],
c.text as [Comment Text],
a.body as [Answer Text]
from comments c
inner join posts a on c.postid = a.id
where a.posttypeid = 2 -- answers
and a.score < 2 -- with low score
and c.text like '%not an answer%' -- and comments with the phrase 'not an answer'