0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

SELECT TOP 5 Tags.TagName, COUNT(distinct PostTags.PostId) FROM PostLinks
LEFT JOIN PostTags on PostLinks.PostId = PostTags.PostId
JOIN Tags on PostTags.TagId = Tags.Id
WHERE LinkTypeId = 3
group by Tags.TagName

view current version

edited dec 3

created dec 3 jon.doe46463