Most frequent editors of my posts

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
  ph.UserId AS [User Link], ph.UserDisplayName,
  COUNT(DISTINCT RevisionGUID) AS [Count]
FROM PostHistory ph INNER JOIN Posts p ON ph.PostId=p.Id
WHERE (p.OwnerUserId=##userid?8297##)
GROUP BY ph.UserId, ph.UserDisplayName
ORDER BY COUNT(DISTINCT RevisionGUID) DESC

Enter Parameters

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