There are some events that get logged in the PostHistory database that, as far as I can tell, always happen together:
- a post gets merged:
PostMergeSource
,PostMergeDestination
- a post is created:
InitialBody
,InitialTitle
,InitialTags
- similar for rollbacks:
RollbackBody
,RollbackTitle
,RollbackTags
So why, when running a query over Worldbuilding's database, do I get these results?
Site History Type Name Instances
-------------------------------------------------
worldbuilding Initial Body 25658
worldbuilding Initial Title 4391
worldbuilding Initial Tags 4391
worldbuilding Rollback Body 49
worldbuilding Rollback Title 23
worldbuilding Rollback Tags 14
worldbuilding Post Merge Destination 7
worldbuilding Post Merge Source 1
It would seem to make sense for the numbers for each partner event to be the same, yet they're not. Why is this? Am I misinterpreting the events?
Data from the data dump imported into a MySQL database programmatically. Query:
SELECT
`ph`.`Site` AS 'Site',
`pht`.`Name` AS 'Type Name',
COUNT(`ph`.`PostHistoryTypeId`) AS 'Instances'
FROM `PostHistory` AS `ph`
INNER JOIN `PostHistoryTypes` AS `pht` ON `ph`.`PostHistoryTypeId` = `pht`.`Id`
GROUP BY `ph`.`PostHistoryTypeId`, `ph`.`Site`
ORDER BY COUNT(`ph`.`PostHistoryTypeId`) DESC
LIMIT 1000;
Initial Body
contains not only answers but also tag wikis. And I'd also bet that Rollbacks are split by whether they affect various parts of the post.