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
LEFT JOIN user_groups ON ug_user = actor_user
WHERE rev_id >= @rev
AND NOT ug_group = 'bot'
AND 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...
