Q&A about the site for Joomla! administrators, users, developers and designers
SELECT eomonth(CreationDate), COUNT(DISTINCT RevisionGUID) AS Count FROM PostHistory WHERE (PostHistoryTypeId in (4,5,6)) GROUP BY eomonth(CreationDate) ORDER BY eomonth(CreationDate) ASC