Posts that could be marked as 'not an answer' to help get the Marshal badge

0

Please login or register to vote for this query.

(click on this box to dismiss)

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 :

Stack Overflow

Q&A for professional and enthusiast programmers

select top 100 p.Id AS [Post Link], p.body
from posts as p
inner join [users] as u on u.id = p.owneruserid
where posttypeid = 2
and (body like '%how can%' or
     body like '%same problem%' or
     body like '%thank%' or
     body like '%please%' or
     body like '%plz%' or
     body like '%pls%')
and u.reputation < 100
and p.score < 1
order by p.id desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results