Find NAAs using Natty Blacklist

0

Please login or register to vote for this query.

(click on this box to dismiss)

Title

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT top 100 
P.Id AS [Post Link], P.Score
FROM Posts P 
WHERE (
   P.PostTypeId = 2 AND
   P.CreationDate < '2015-01-01' AND
   P.Score < 0 AND
   (
lower(P.Body) like '%stackoverflow won''t let me comment%' 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 '%did you finally find a solution%' or 
lower(P.Body) like '%i''ve tried everything with no luck%' or 
lower(P.Body) like '%did you ever find the answer to this question%' or 
lower(P.Body) like '%guide me%' or 
lower(P.Body) like '%i cannot comment%' or 
lower(P.Body) like '%not enough reputation points%' 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