'Copy editor' and 'Strunk & White' badges progress

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

Mythology

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)

Enter Parameters

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