Janitor: posts that contain 'kali' but are not tagged kali

1

Please login or register to vote for this query.

(click on this box to dismiss)

Unix and Linux

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

select Id AS [Post Link], * from Posts 
where Tags NOT LIKE '%kali-linux%' and
(Body LIKE '%kali%' COLLATE SQL_Latin1_General_Cp1_CI_AS OR Title LIKE '%kali%' COLLATE SQL_Latin1_General_Cp1_CI_AS)
and ClosedDate IS NULL
ORDER BY CreationDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results