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

2

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

Emacs

Q&A for those using, extending or developing Emacs

-- Enter Query Title
-- Enter Query Description

DECLARE @UserId int = ##UserId##;

SELECT COUNT(*) [Number of edited posts] FROM (
  SELECT DISTINCT p.Id [Post Link] FROM PostHistory ph
  JOIN Posts p ON p.Id = ph.PostId
  WHERE ph.UserId = @UserId
) [pl]

Enter Parameters

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