Tags without excerpt, ordered by usage

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 t.TagName, COUNT(*) AS 'Number of posts'
  FROM Tags AS t
  INNER JOIN PostTags AS pt ON pt.TagId = t.Id
  WHERE t.ExcerptPostId IS NULL
  GROUP BY t.TagName
  ORDER BY COUNT(*) DESC

Enter Parameters

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