Comments that may be auto-deleted #3

1

Please login or register to vote for this query.

(click on this box to dismiss)

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

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT TOP ##Limit:int?100##
  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?15## AND
  (
    Text LIKE '%imgur%' OR Text LIKE '%.jpg%' OR Text LIKE '%code%' OR 
    Text LIKE '%show%' OR Text LIKE '%tried%' OR Text LIKE '%mcve%' OR 
    Text LIKE '%duckduckgo%' OR Text LIKE '%lmgtfy%' OR 
    Text LIKE '%prof%' OR Text LIKE '%uni%' OR Text LIKE '%course%' OR 
    Text LIKE '%format%' OR Text LIKE '%wrong%' OR Text LIKE '%right%' OR 
    Text LIKE '%correct%' OR Text LIKE 'yes%' OR Text LIKE 'no%' OR 
    Text LIKE '%accept%' OR Text LIKE '%mark%' OR Text LIKE '%error%' OR 
    Text LIKE '%logs%' OR Text LIKE '%forum%' OR Text LIKE '%meta%'
  ) AND
  p1.ClosedDate IS NULL AND
  c.CreationDate < DATEADD(dd, -##MinCommentAgeDays:int?90##, GETDATE())
ORDER BY c.CreationDate ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results