5

How can I see the list of questions that were manually removed (= removed by a mod) from the list of hot network questions on a given SE website?

0

2 Answers 2

6

You can do so using this SEDE query.

This should give you a list of all moderator-removed hot network questions only, along with other details (date and time of removal, number of hours on the HNQ list, etc.).

Here is an example query with a list of questions from English Language & Usage that were manually removed by moderators in the past 360 days:

enter image description here

3
  • Though of course mods can remove questions without using the removal tool, by simply closing (or deleting!) the question.
    – Laurel
    Jul 2 at 18:55
  • 1
    @Laurel: Unfortunately, there's no record of a question being removed from the HNQ list (because of it being closed) in the timeline of the question... It's only recorded when a question is removed using the removal tool.
    – Justin
    Jul 2 at 19:05
  • 1
    I'll have a look whether I can update my HNQ scraper data, which keeps track of how long questions actually remain in the list.
    – Glorfindel Mod
    Jul 3 at 4:19
2

Another SEDE query to list questions that were manually removed (= removed by a mod) from the list of hot network questions on a given SE website, by Glorfindel:

SELECT h53.PostId AS [Post Link],
  h52.CreationDate AS [Became hot],
  h53.CreationDate AS [Removed],
  h53.UserId AS [User Link],
  'site://posts/' + CAST(h53.PostId AS NVARCHAR) + '/revisions|Revisions'
  FROM PostHistory AS h53
  LEFT OUTER JOIN PostHistory AS h52
    ON h52.PostId = h53.PostId
   AND h52.PostHistoryTypeId = 52 -- became HNQ
  WHERE h53.PostHistoryTypeId = 53 -- removed from HNQ
  ORDER BY h53.CreationDate DESC

This fork by an anonymous user adds to the list all other HNQs:

SELECT h52.PostId AS [Post Link],
  h52.CreationDate AS [Became hot],
  h53.CreationDate AS [Removed],
  h53.UserId AS [User Link],
  'site://posts/' + CAST(h52.PostId AS NVARCHAR) + '/revisions|Revisions'
  FROM PostHistory AS h52
  LEFT OUTER JOIN PostHistory AS h53
    ON h52.PostId = h53.PostId
   AND h53.PostHistoryTypeId = 53 -- removed from HNQ
 WHERE h52.PostHistoryTypeId = 52 -- became HNQ
  ORDER BY h52.CreationDate DESC

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .