4

Please login or register to vote for this query.

(click on this box to dismiss)

targeting answers that have gained a comment saying something like 'this isn't an answer' or 'this should be deleted'. Helps for the Marshal badge.

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

-- Posts that could be marked as 'not an answer' to help get the Marshal badge
-- targeting answers from users with not a lot of rep. I hate the use of `body like`, so please feel free to edit this. It was just quick n dirty! The Marshal badge is:   "Achieved a flag weight of 749 by reviewing and flagging appropriately :

select top 100 c.postId AS [Post Link], c.text
from comments as c  inner join posts as p on p.id = c.postid
where (text like '%not an answer%' or
     text like '%deleted%' )
and c.score >= 1
and p.posttypeid = 2
order by c.postid
  

fork query

created sep 3 11 p.campbell