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 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

Enter Parameters

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