How many edits of each type did I make?
Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS
-- Number of edits
-- How many edits of each type did I make?
SELECT T.Name, Count(*)
FROM PostHistory H
INNER JOIN PostHistoryTypes T ON H.PostHistoryTypeId = T.Id
WHERE H.UserId = ##user##
GROUP BY T.Name