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

1

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

-- 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 50 p.Id AS [Post Link], p.body, p.creationdate
from 
[users] as u
inner join posts as p 
    on u.id = p.owneruserid and u.reputation < 100
    and posttypeid = 2
    and p.score < 1
    and datediff(dd,p.creationdate, getdate())<30
where 
    (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%')

Enter Parameters

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