Edits on my posts

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Edits on my posts
select t.Name , h.CreationDate, PostId as [Post Link] 
from PostHistory h
join PostHistoryTypes t on t.Id = PostHistoryTypeId 
where PostId in (select Id from Posts where OwnerUserId = ##UserId##) 
and h.UserId <> ##UserId##
and PostHistoryTypeId in (4,5,6,7,8,9)
order by h.CreationDate desc

Enter Parameters

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