Seek and Destroy: Comments with the phrase "not an answer"

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?

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

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'
  order by len(a.body)

Enter Parameters

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