Find all posts matching list of tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

IT Security

Q&A for information security professionals

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.Score AS [Score]
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.Score DESC

Enter Parameters

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