Questions removed from HNQ list

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

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

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