Q&A for scientists using computers to solve scientific problems
SELECT TOP(##num?100##) h.PostId AS [Post Link], COUNT(DISTINCT h.RevisionGUID) AS Count, revisions = 'site://posts/' + CAST(h.PostId AS varchar)+'/revisions', --- timeline = 'site://posts/' + CAST(PostId AS varchar)+'/timeline' p.OwnerUserId AS [User Link], p.OwnerDisplayName, p.Score, p.CreationDate, p.ViewCount, p.Tags, CASE p.PostTypeId WHEN 1 THEN 'Question' WHEN 2 THEN 'Answer' END FROM PostHistory h INNER JOIN Posts p ON h.PostId=p.Id WHERE (h.PostHistoryTypeId IN (##list?1,2,3,4,5,6,7,8,9##)) AND (p.CommunityOwnedDate IS NULL) AND (p.PostTypeId IN (##types?1,2##)) ---types=1: only questions ---types=2: only answers ---types=1,2: both questions and answers GROUP BY h.PostId, p.OwnerUserId, p.OwnerDisplayName, p.Score, p.CreationDate, p.ViewCount, p.Tags, p.PostTypeId ORDER BY COUNT(DISTINCT RevisionGUID) DESC ---1 = Initial Title - initial title (questions only) ---2 = Initial Body - initial post raw body text ---3 = Initial Tags - initial list of tags (questions only) ---4 = Edit Title - modified title (questions only) ---5 = Edit Body - modified post body (raw markdown) ---6 = Edit Tags - modified list of tags (questions only) ---7 = Rollback Title - reverted title (questions only) ---8 = Rollback Body - reverted body (raw markdown) ---9 = Rollback Tags - reverted list of tags (questions only)