DECLARE @UserId varchar(60) = '##UserId##' SELECT t.TagN...

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

DECLARE @UserId varchar(60) = '##UserId##'

SELECT t.TagName
FROM Tags t
INNER JOIN Posts p ON p.Id = t.ExcerptPostId
INNER JOIN PostTags pt ON pt.TagId = t.Id
INNER JOIN Posts q ON q.Id = pt.PostId
INNER JOIN Posts a ON a.ParentId = q.Id AND a.OwnerUserId = @UserId
WHERE t.ExcerptPostId IS NULL OR p.Body = ''
ORDER BY t.Count DESC;

Enter Parameters

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