Untitled query #72273

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
JOIN page ON rev_page = page_id
JOIN langlinks ON page_title = ll_title
WHERE rev_id >= @rev AND NOT ug_group = 'bot' AND ll_lang = 'en'
GROUP BY `User`
ORDER BY Edits DESC
LIMIT 100;
SQL

Checking query status...
