How many posts have I edited (for badges)?

0

Please login or register to vote for this query.

(click on this box to dismiss)

This script counts the number of others' posts on which you have edited either the title or body.

Stack Overflow

Q&A for professional and enthusiast programmers

-- How many posts have I edited (for badges)?
-- This script counts the number of others' posts on which you have edited either the title or body.
Declare @UserId int = ##UserId##
select count(distinct p.Id) as 'Posts Edited'
from PostHistory h, Posts p where
h.UserId=@UserId and p.Id=h.PostId and p.OwnerUserId!=@UserId and
h.PostHistoryTypeId in (4,5,24)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results