0

Please login or register to vote for this query.

(click on this box to dismiss)

You need 500 edited posts to get 'Copy editor' badge and 80 edits to get 'Strunk & White' badge

Q&A for enthusiasts and scholars of mythology and folklore

DECLARE @user INT = ##UserId:int##

select
    COUNT(*) as [Posts Edited]
FROM PostHistory
LEFT JOIN Posts as Post on PostHistory.PostId=Post.Id
WHERE UserId=@user and Post.OwnerUserId!=@user
AND PostHistoryTypeId in (4,5)

fork query

edited aug 14 12 Brad Mace

created may 28 11 marat.snowbear