0

Please login or register to vote for this query.

(click on this box to dismiss)

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], 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'

fork query

created jul 24 11 camccann