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.

Moderators

Q&A for community managers, administrators, and moderators

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