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")
AND rev_page_namespace = 0 -- only include edits in the main namespace
AND rev_minor_edit = 0 -- exclude minor edits
AND rev_len > 10 -- exclude very short edits
AND rev_parent_id = 0); -- exclude edits that are not the first revision of a page

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...
