Untitled query #72278

SQL

SET @rev = (SELECT MIN(rev_id)
            FROM revision
            WHERE rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -30 DAY), "%Y%m%d%H%i%s"));


SELECT COUNT(*) AS Edits,
       actor_name AS User,
       ug_group AS Rights
FROM revision_userindex
JOIN actor_revision ON rev_actor = actor_id
JOIN revision ON rev_id = rev_parent_id -- join with the revision table to access rev_comment
LEFT JOIN user_groups ON ug_user = actor_user
WHERE rev_id >= @rev
AND NOT ug_group = 'bot'
AND revision.rev_comment LIKE '%en%' -- include only edits that have 'en' in the edit summary (assuming it's an indication of English)
GROUP BY User
ORDER BY Edits DESC
LIMIT 350
SQL

Checking query status...
