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 P.Id AS [Post Link], P.Score
FROM Posts P 
WHERE (
   P.PostTypeId = 2 AND
   P.CreationDate > '##date##' AND
   P.Score <= 0 AND
   len(P.Body) <= 300 AND ( 
lower(P.Body) like '%can u please share%' or
lower(P.Body) like '%can anyone give me an answer%' or 
lower(P.Body) like '%please help me in resolving%' or 
lower(P.Body) like '%stackoverflow won''t let me comment%' or 
lower(P.Body) like '%i want to solve this problem%' or 
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 '%i''ve tried everything with no luck%' or
lower(P.Body) like '%have you been able to find a solution yet%' or 
lower(P.Body) like '%have you found%solution%' or 

lower(P.Body) like '%looking forward to your answer.%' or 
lower(P.Body) like '%this is actually a question%' or
lower(P.Body) like '%has anybody seen the same errors%' or 
lower(P.Body) like '%i haven''t got enough reputation points%' or 
lower(P.Body) like '%can you suggest%' or 
lower(P.Body) like '%can you guide me%' or 
lower(P.Body) like '%this may sound like a stupid question%' or 
lower(P.Body) like '%kindly assist%')
)
ORDER BY P.Score ASC, P.CreationDate DESC

Enter Parameters

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