select a.id as [Post Link], a.score as [Answer Score], a....

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

select a.id as [Post Link], 
  a.score as [Answer Score], a.body as [Answer Text],
  c.text as [Comment 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'

Enter Parameters

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