SELECT pt.PostId AS [Post Link], pt.TagId, t.TagName FROM...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  pt.PostId AS [Post Link],
  pt.TagId,
  t.TagName
FROM Tags t
JOIN PostTags pt ON (t.Id = pt.TagId)
JOIN Posts p ON (p.Id = pt.PostId AND p.PostTypeId = 2)
WHERE t.TagName IN ('j-r-r-tolkien', 'tolkiens-legendarium', 'the-silmarillion', 'the-lord-of-the-rings')

Enter Parameters

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