0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

--SELECT TOP 50 Id, TagName FROM Tags t ORDER BY t.Count DESC;

SELECT TOP 100 pId as [Post Link], TagID as [Tag Link], t.TagName FROM 

(SELECT p.Id as pId, pt.TagId as TagID 
FROM posts p 
INNER JOIN posttags pt ON pt.PostId=p.Id) ppt

INNER JOIN tags t ON TagId=t.Id;

view current version

edited aug 3 15

created aug 3 15 Deer Hunter