SELECT t.TagName AS TagName, u.Id AS UserId FROM Posts p ...

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

-- All posts by tag
SELECT
  t.TagName AS TagName,
  u.Id AS UserId
FROM Posts p
  INNER JOIN PostTags pt ON p.Id = pt.PostId
  INNER JOIN Tags t ON pt.TagId = t.Id
  INNER JOIN Users u ON u.Id = p.OwnerUserId
  WHERE
  u.Id IN (SELECT Id FROM Users u) 
  AND t.TagName IN ('freebsd')

Enter Parameters

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