22

Please login or register to vote for this query.

(click on this box to dismiss)

Shows a user's total edits so far, how many edits until the "Strunk and White" (now 80 at SO) badge, and how many edits until the "Copy Editor" badge (now 500 at SO).

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

-- How many edits until Copy Editor (proper)?
-- Shows a user's total edits so far, how many edits until the "Strunk and White" (now 80 at SO)
-- badge, and how many edits until the "Copy Editor" badge (now 500 at SO).
-- 2011-12-18 Fix: multiple edits on the same post count once only.
-- only edits to title and body count, editing tags alone does not.
-- Source of info:
-- http://meta.stackoverflow.com/questions/67397/list-of-all-badges-with-full-descriptions

DECLARE @USER int = ##UserId##;

SELECT COUNT(DISTINCT ph.PostId) AS 'Number of Edits', -- every post counts once only
       80  - COUNT(DISTINCT ph.PostId) AS 'Edits until "Strunk and White"',
       500 - COUNT(DISTINCT ph.PostId) AS 'Edits until "Copy Editor"'
FROM   PostHistory ph
JOIN   Posts p ON p.Id = ph.PostId AND p.OwnerUserId <> @User
WHERE  ph.UserId = @User
AND    ph.PostHistoryTypeId BETWEEN 4 AND 5 -- only edits to title & body count

fork query

created dec 18 11 Erwin Brandstetter