Recent posthistory of a specific type

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT TOP(##num?1000##)
  Id,
  PostId AS [Post Link],
  'site://posts/' + CAST(PostId AS varchar)+'/revisions' AS [Revision History],
  PostHistoryTypeId,
  CASE PostHistoryTypeId 
   WHEN 1 THEN 'Initial Title'
   WHEN 2 THEN 'Initial Body'
   WHEN 3 THEN 'Initial Tags'
   WHEN 4 THEN 'Edit Title'
   WHEN 5 THEN 'Edit Body'
   WHEN 6 THEN 'Edit Tags'   
   WHEN 7 THEN 'Rollback Title'
   WHEN 8 THEN 'Rollback Body'
   WHEN 9 THEN 'Rollback Tags'
   WHEN 10 THEN 'Post Closed'
   WHEN 11 THEN 'Post Reopened'
   WHEN 12 THEN 'Post Deleted'
   WHEN 13 THEN 'Post Undeleted'
   WHEN 14 THEN 'Post Locked'
   WHEN 15 THEN 'Post Unlocked'
   WHEN 16 THEN 'Community Owned'
   WHEN 17 THEN 'Post Migrated'
   WHEN 18 THEN 'Question Merged'
   WHEN 19 THEN 'Question Protected'
   WHEN 20 THEN 'Question Unprotected'
  END, 
  CreationDate,
  UserId AS [User Link], UserDisplayName,
  Comment, Text
FROM PostHistory
WHERE PostHistoryTypeId=##type?4## 
ORDER BY Id DESC

Enter Parameters

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