Find NAAs older than a given date using Natty Blacklist


Please login or register to vote for this query.

(click on this box to dismiss)



Q&A for community managers, administrators, and moderators

SELECT P.Id AS [Post Link], P.Score
FROM Posts P 
   P.PostTypeId = 2 AND
   P.Score <= 0 AND
   len(P.Body) < 300 AND
   P.CreationDate < '##date##' AND (
   lower(P.Body) like '%sorry for posting this as an answer%' or 
   lower(P.Body) like '%don''t have enough reputation to post a comment%' or 
   lower(P.Body) like '%how did you solve it%' or 
   lower(P.Body) like '%can you share%' or 
   lower(P.Body) like '%do you have any idea%' or 
   lower(P.Body) like '%kindly assist%')
ORDER BY P.Score ASC, P.CreationDate DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results