List questions without a set of required tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the questions which do not have any of the specified tags. Enter the tags with a space in between.

Stack Overflow

Q&A for professional and enthusiast programmers

WITH RequiredTags AS (
  SELECT t.Id
  FROM Tags t
  WHERE ' ##Tags## ' LIKE '% ' + t.TagName + ' %'
)

SELECT
  p.Id AS [Post Link],
  p.Tags AS [Tags],
  p.CreationDate AS [Date],
  p.Score AS [Score],
  Iif(p.ClosedDate IS NULL, NULL, 'c') AS [Closed]
FROM Posts p
WHERE p.PostTypeId = 1
  AND NOT (EXISTS (SELECT pt.TagId FROM PostTags pt
                   INNER JOIN RequiredTags rt ON pt.TagId = rt.Id
                   WHERE pt.PostId = p.Id))
ORDER BY p.Id ASC

Enter Parameters

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