Total edits per month (without counting tags,title,body separately)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results