For ModBatchCommentDeleter userscript users: Run with preferred parameters, then download the CSV results and insert into /admin/deleter on your site. ----- Part 1: https://data.stackexchange.com/stackoverflow/query/1131935 Part 2: https://data.stackexchange.com/stackoverflow/query/1141986 Part 3: https://data.stackexchange.com/stackoverflow/query/1154010 Part 4: https://data.stackexchange.com/stackoverflow/query/1155090
Q&A about the site for users of Linux, FreeBSD and other Un*x-like operating systems
SELECT TOP ##Limit:int?50000## LOWER(c.Text) AS [Text], 'site://posts/comments/' + CONVERT(nvarchar(20),c.Id) AS [Comment Permalink] FROM Comments c INNER JOIN Posts p ON c.PostId = p.Id INNER JOIN Posts p1 on p.ParentId = p1.Id WHERE p.PostTypeId = 2 AND -- 2 = Answer LEN(Text) >= ##MinCommentLength:int?15## AND LEN(Text) <= ##MaxCommentLength:int?40## AND ( Text LIKE '%learn%' OR Text LIKE '%read%' OR Text LIKE '%study%' OR Text LIKE '%teach%' OR Text LIKE '%docs%' OR Text LIKE '%man%' OR Text LIKE '%girl%' OR Text LIKE '%boy%' OR Text LIKE '%good%' OR Text LIKE '%excellent%' OR Text LIKE '%wonder%' OR Text LIKE '%magic%' OR Text LIKE '%trick%' OR Text LIKE '%cool%' OR Text LIKE '%wow%' OR Text LIKE '%omg%' OR Text LIKE '%rofl%' OR Text LIKE '%lol%' OR Text LIKE '%thx%' OR Text LIKE '%shit%' OR Text LIKE '%cheers%' OR Text LIKE 'ok%' OR Text LIKE 'hah%' OR Text LIKE '%point%' ) AND p1.ClosedDate IS NULL AND c.CreationDate < DATEADD(dd, -##MinCommentAgeDays:int?30##, GETDATE()) ORDER BY c.CreationDate ASC