Top N tags relative popularity history

3

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the most popular tags in percent of all questions asked in the month

Emacs

Q&A for those using, extending or developing Emacs

/*
WITH TopTags AS (
  SELECT TOP ##TopN:INT?10## Id, TagName
  FROM Tags
  ORDER BY Count DESC
)
SELECT * FROM TopTags;*/
SELECT TOP 100 * FROM PostTags WHERE PostId IN (
  SELECT Id FROM PostsWithDeleted WHERE DeletionDate IS NOT NULL
);

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results