0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select PostId AS [Post Link], Count(PostId)
from PostHistory
left join Posts
  on PostHistory.PostId = Posts.Id
where
  (Posts.PostTypeId = 1 OR Posts.PostTypeId = 2)
  -- questions and answers only
  
  AND PostHistory.PostHistoryTypeId in (1, 2, 3, 4, 5, 6, 7, 8, 9, 24)
  -- these numbers are from the PostHistoryTypes table.
  -- they cover: initial version, edits, rollbacks, and suggested edits

  AND OwnerUserId = 1204

group by PostId
order by Count(PostId) desc

fork query

edited oct 7 14 doppelgreener

created oct 7 14 anonymous