Copy Editor Progress

0

Please login or register to vote for this query.

(click on this box to dismiss)

This query returns the number of edits you still need to get the Copy Editor badge. Edit in your user ID below.

Materials Modeling Meta

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

Enter Parameters

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