Find all posts matching list of tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Esperanto Language

Q&A for teachers and students of the Esperanto language

SELECT ID, TagName
INTO #MyTags
FROM Tags
WHERE 
  --TagName = 'vim'
  --TagName = 'maxima'
  --TagName IN ('c++17', 'c++20')
  TagName IN ('okta')
  
SELECT TOP 200
  concat('https://stackoverflow.com/questions/',Posts.ID) AS [Post Link],
  Posts.Title AS [Title],
  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 sites:
loading Hold tight while we fetch your results