User activity

0

Please login or register to vote for this query.

(click on this box to dismiss)

Movies and TV Meta

Q&A about the site for movie and tv enthusiasts

SELECT
  Users.Id AS [User Link],
  PostsWithDeleted.Id AS [Post Link],
  PostsWithDeleted.CreationDate,
  PostHistory.CreationDate AS 'Became HNQ'
FROM
  PostsWithDeleted
  INNER JOIN Users ON PostsWithDeleted.OwnerUserId=Users.Id
  LEFT JOIN PostHistory ON PostHistory.PostId=PostsWithDeleted.Id AND PostHistory.PostHistoryTypeId=52
WHERE
  Users.AccountId IN (##UserIds##)
ORDER BY PostsWithDeleted.CreationDate DESC

Enter Parameters

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