0

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

fork query

edited may 8 19

created may 8 19 Glorfindel