0

Please login or register to vote for this query.

(click on this box to dismiss)

For determining how many edits to go before a person hits Strunk & White or Copy Editor Edit the ID number to get your value

Q&A for pro webmasters

-- How Many Edits Have I Made?
-- For determining how many edits to go before a person hits Strunk & White or Copy Editor
-- Edit the ID number to get your value

DECLARE @UserId int = ##UserId##

SELECT COUNT(*) AS [Edits],
CASE WHEN COUNT(*) >= 200 THEN 'done' ELSE CAST(200 - (COUNT(*)) AS varchar) END AS [Until Strunk & White],
CASE WHEN COUNT(*) >= 600 THEN 'done' ELSE CAST(600 - (COUNT(*)) AS varchar) END AS [Until Copy Editor]
FROM Posts
WHERE PostTypeId = 1
AND   LastEditorUserId = @UserId
AND   OwnerUserId != @UserId

fork query

created jul 13 10 Michael Mrozek