'Copy editor' and 'Strunk & White' badges progress (Revamped)

3

Please login or register to vote for this query.

(click on this box to dismiss)

Previous queries haven't taken into consideration all the requirements laid out in http://meta.stackexchange.com/questions/67397/list-of-all-badges-with-full-descriptions#188732.

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

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

select
    COUNT(*) [Edits]
FROM PostHistory
LEFT JOIN Posts as Post on PostHistory.PostId=Post.Id
WHERE UserId=@user and Post.OwnerUserId <> @user
AND PostHistoryTypeId in (4, 5)
AND PostTypeId IN (1, 2)
AND LEN(ISNULL(Post.ClosedDate, '')) > 0

Enter Parameters

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