Find all posts matching list of tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT ID, TagName
INTO #MyTags
FROM Tags
WHERE 
  --TagName = 'vim'
  --TagName = 'maxima'
  --TagName IN ('c++17', 'c++20')
  TagName IN ('okta')
  
SELECT TOP 200
  Posts.ID AS [Post Link],
  Posts.Tags AS [Tags],
  Posts.CreationDate AS [CreationDate],
  Posts.ViewCount AS [ViewCount]
FROM Posts
  join PostTags ON PostTags.PostID = Posts.ID
  join Tags ON Tags.ID = PostTags.TagID
WHERE TagID in (SELECT ID FROM #MyTags)
ORDER BY Posts.CreationDate DESC

Enter Parameters

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