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