1000 Most Recent Community Edits

1

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

Q&A for Drupal developers and administrators

SELECT TOP 1000
  PostId AS [Post Link],
  CreationDate AS 'Date'
FROM
  PostHistory
WHERE 
  UserId = -1 AND -- Select Community User
  (PostHistoryTypeId = 4 OR -- Type: Post Title Edit
  PostHistoryTypeId = 5 OR -- Type: Post Body Edit
  PostHistoryTypeId = 6) -- Type: Post Tags Edit
ORDER BY 
  CreationDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results