0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

-- 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

fork query

created oct 28 11 oboriso