Find NAAs older than a given date using Natty Blacklist

1

Please login or register to vote for this query.

(click on this box to dismiss)

Title

Moderators

Q&A for community managers, administrators, and moderators

SELECT top 100 
P.Id AS [Post Link], P.Score
FROM Posts P 
WHERE (
   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

Enter Parameters

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