SELECT pt.TagId, t.TagName, COUNT(*) FROM PostTags AS pt,...

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.TagId, t.TagName, COUNT(*) FROM PostTags AS pt, Tags AS t
WHERE pt.PostId IN (SELECT PostId FROM PostTags WHERE TagId IN (4087))
AND pt.TagId = t.Id AND pt.TagId != 4087
GROUP BY pt.TagId, t.TagName
ORDER BY COUNT(*) DESC

Enter Parameters

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