Get all tags with their counts and descriptions


Please login or register to vote for this query.

(click on this box to dismiss)

Academia Meta

Q&A about the site for academics and those enrolled in higher education

SELECT YEAR(p.CreationDate), t.TagName, COUNT(pt.PostId) FROM Posts as p
LEFT JOIN PostTags as pt ON p.Id = pt.PostId
LEFT JOIN Tags AS t ON pt.TagId = t.Id
WHERE t.TagName = 'javascript' OR t.TagName = 'typescript' AND AcceptedAnswerId IS NOT NULL AND p.ViewCount > 10
GROUP BY YEAR(p.CreationDate), t.TagName
ORDER BY YEAR(p.CreationDate) ASC

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results