Show comments on closed questions suggesting SO or Security

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cryptography

Q&A for software developers, mathematicians and others interested in cryptography

SELECT
  'site://questions/' + Cast(p.Id AS VarChar(9)) +
  '#comment' + Cast(c.Id AS VarChar(9)) + '_' + Cast(p.Id AS VarChar(9)) +
  '|' + c.Text
FROM Posts p
INNER JOIN Comments c ON c.PostId = p.Id
WHERE p.ClosedDate IS NOT NULL
  AND NOT EXISTS (SELECT Id FROM PostHistory h
                  WHERE h.PostId = p.Id
                    AND h.PostHistoryTypeId = 35) -- exclude migrated questions
  AND (c.Text LIKE '%[Ss]tack[Oo]verflow%' OR
       c.Text LIKE '%[Ss]tack [Oo]verflow%' OR
       c.Text LIKE '%[Ss]ecurity [Ss]tack%' OR
       c.Text LIKE '%[Ss]ecurity.[Ss][Ee]%')
ORDER BY p.Id ASC, c.Id ASC

Enter Parameters

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