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.Score <= 0 AND
   len(P.Body) < 200 AND
   P.CreationDate < '##date##' AND (
lower(P.Body) like '%could someone explain%' 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 '%did you get your solution%' or 
lower(P.Body) like '%how did you solve it%' or 
lower(P.Body) like '%did you finally find a solution%' or 
lower(P.Body) like '%i''ve tried everything with no luck%' or 
lower(P.Body) like '%guide me%' 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 '%were you able to figure out%' or 
lower(P.Body) like '%give me a hand%' or 
lower(P.Body) like '%you saved my life%' or 
lower(P.Body) like '%i also have this question%' or 
lower(P.Body) like '%wont let me comment%' or 
lower(P.Body) like '%won''t let me comment%' or 
lower(P.Body) like '%plz help%' or 
lower(P.Body) like '%i am facing the same problem%' or 
lower(P.Body) like '%i am also facing the same issue%' or 
lower(P.Body) like '%please help%' or 
lower(P.Body) like '%please suggest me%' or 
lower(P.Body) like '%enter image%' or 
lower(P.Body) like '%any tips%' or 
lower(P.Body) like '%i have the same question%' or 
lower(P.Body) like '%halp plz%' or 
lower(P.Body) like '%could anyone help?%' or 
lower(P.Body) like '%i am facing issue%' or 
lower(P.Body) like '%please advise%' or 
lower(P.Body) like '%did you get the solution%' or 
lower(P.Body) like '%did you figure out this problem%' or 
lower(P.Body) like '%did you solve the problem%' or 
lower(P.Body) like '%can you please share%' or 
lower(P.Body) like '%help would be appreciated%' or 
lower(P.Body) like '%what to do if%' or 
lower(P.Body) like '%i cant get it right%' or 
lower(P.Body) like '%i can''t get it right%' or 
lower(P.Body) like '%i can not get it right%' or 
lower(P.Body) like '%i have to do%' or 
lower(P.Body) like '%i have one doubt%' or 
lower(P.Body) like '%what am i doing wrong?%' or 
lower(P.Body) like '%i need a solution%' or 
lower(P.Body) like '%can someone help%' or 
lower(P.Body) like '%this should be a comment%' or 
lower(P.Body) like '%help is very appreciated%' or 
lower(P.Body) like '%help is appreciated%' or 
lower(P.Body) like '%help will be appreciated%' or 
lower(P.Body) like '%can some let me know%' or 
lower(P.Body) like '%can someone let me know%' or  
lower(P.Body) like '%it didn''t work for me%' or 
lower(P.Body) like '%problem solved yet?%' or 
lower(P.Body) like '%can u please share%' or
lower(P.Body) like '%save%my day%' or 
lower(P.Body) like '%i have the following error%' or 
lower(P.Body) like '%kindly advice me%' or 
lower(P.Body) like '%looking forward to your answer.%' or 
lower(P.Body) like '%i emailed their support%' or 
lower(P.Body) like '%can you one tell me%' or 
lower(P.Body) like '%can you tell me%' or 
lower(P.Body) like '%stupid question%' or 
lower(P.Body) like '%i have the same problem%' or 
lower(P.Body) like '%this is actually a question%' or 
lower(P.Body) like '%we have the same problem%' or 
lower(P.Body) like '%i''m having the same problem%' 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 '%i have the exact same problem%' or 
lower(P.Body) like '%can you guide me%' 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