Questions removed from HNQ list


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for people studying math at any level and professionals in related fields

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

Enter Parameters

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