Tag edits by a specific user between two dates

1

Please login or register to vote for this query.

(click on this box to dismiss)

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

SELECT
  Text AS [Tags],
  PostId AS [Post Link],
  'site://posts/' + CAST(PostId AS varchar)+'/revisions' AS [Revision History],
  CreationDate,
  UserId AS [User Link]
FROM PostHistory  
WHERE (PostHistoryTypeId=6) AND 
  (UserId=##userid?14094##) AND 
  (CreationDate >= '##Date1?2020-01-01##') AND (CreationDate <= '##Date2?2021-01-01##')

Enter Parameters

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