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 > '2019-01-01' 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 '%not enough reputation points%' or 
lower(P.Body) like '%can you guide me%' 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