1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select
  count(*) as TotalEdits
from Posts
join PostTypes on Posts.PostTypeId = PostTypes.Id
join PostHistory on Posts.id = PostHistory.PostId
join PostHistoryTypes on PostHistory.PostHistoryTypeId = PostHistoryTypes.Id
where
  PostHistory.UserId = ##UserId##
  and Posts.OwnerUserId != PostHistory.UserId
  and PostTypes.Name in ('Question', 'Answer')
  and PostHistoryTypes.Name in ('Edit Title', 'Edit Body', 'Edit Tags')

fork query

edited aug 7 13

created aug 7 13 Andrew Marshall