This query returns the number of edits you still need to get the Copy Editor badge. Edit in your user ID below.
Q&A for materials modelers and data scientists
-- Copy Editor Progress -- This query returns the number of edits you still need to get the Copy Editor badge. Edit in your user ID below. DECLARE @userid int = 1465 SELECT 500 - count(UserID) as EditsRemaining, UserID FROM PostHistory ph WHERE PostHistoryTypeId IN (4,5) AND PostId NOT IN ( SELECT p.Id FROM Posts p WHERE p.OwnerUserId = ph.UserId ) AND UserID = @userid GROUP BY UserID