0

Please login or register to vote for this query.

(click on this box to dismiss)

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 those using, extending or developing Emacs

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 provide an answer%'  -- and comments with the phrase 'not an answer'

fork query

edited feb 28 16 anonymous

created jul 24 11 camccann