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`,
    GROUP_CONCAT(DISTINCT ug_group) AS `Rights`,
    ll_lang AS `Language`
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_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -30 DAY), "%Y%m%d%H%i%s")
    AND NOT ug_group = 'bot'
GROUP BY `User`, `Language`
ORDER BY `Language`, `Edits` DESC
LIMIT 100
SQL

Checking query status...
