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