Roomba period for single-use tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Quantum Computing Meta

Q&A about the site for engineers, scientists, programmers, and computing professionals interested in quantum computing

WITH #SingleUseTags2 AS (SELECT TagName, PostId, Tags
  FROM Tags AS t
  INNER JOIN PostTags AS pt
    ON pt.TagId = t.Id
  INNER JOIN Posts AS p
    ON pt.PostId = p.Id
  LEFT OUTER JOIN TagSynonyms
    ON TagName = SourceTagName
  WHERE [Count] = 1
    AND ExcerptPostId IS NULL
    AND WikiPostId IS NULL
    AND SourceTagName IS NULL)
SELECT TagName, DATEADD(MONTH,
  IIF(PATINDEX('%.Meta', DB_NAME()) = 0, 6, 12), -- cf. https://meta.stackexchange.com/a/341923/295232
  ca.CreationDate) AS 'Will be deleted after',
  PostId AS [Post Link], Tags
  FROM #SingleUseTags2 AS sut
  CROSS APPLY (
    SELECT MIN(CreationDate) AS CreationDate
      FROM PostHistory
      WHERE PostHistoryTypeId IN (3, 6)
        AND PostId = sut.PostId
        AND Text LIKE '%[|<]' + TagName + '[|>]%'
  ) ca
  ORDER BY 2

Enter Parameters

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