1

Please login or register to vote for this query.

(click on this box to dismiss)

Returns the user Id of the first user to cast a close vote on recently closed questions, ordered by closure timestamp.

Q&A for active researchers, academics and students of physics

SELECT TOP 200
  PostHistory.PostId AS [Post Link],
--  PostHistory.CreationDate,
--  PostHistory.UserId,
--  PostHistory.Comment,
  CHARINDEX('Orig',PostHistory.Text),
  PostHistory.Text
FROM PostHistory
WHERE PostHistoryTypeId = 10
ORDER BY PostHistory.CreationDate DESC

view current version

edited jul 18 16

created jul 18 16 E.P.