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. Supply your user ID below.

Anime and Manga

Q&A for anime and manga fans

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

DECLARE @userid int = ##user##

SELECT 500 - count(UserID) as EditsRemaining, CreationDate
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 CreationDate

Enter Parameters

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