List of bots by last edit

Fork of Users with most edits in the past month with bots and IPs filtered by DHN

This query is marked as a draft This query has been published by DHN.

SQL

WITH groups AS (
  SELECT ug_user, GROUP_CONCAT(ug_group) AS memberships 
  FROM user_groups 
  WHERE ug_group = 'bot'
  GROUP BY ug_user)
SELECT
  actor.actor_name AS thành_viên,
  memberships AS nhóm,
  MAX(rev_timestamp) AS lần_sửa_đổi_cuối
FROM revision LEFT JOIN actor ON (revision.rev_actor = actor.actor_id)
  LEFT JOIN groups ON (actor.actor_user = groups.ug_user)
-- Lọc ra IP
WHERE DATEDIFF(CURDATE(), rev_timestamp) < 30
  AND memberships IS NOT NULL
-- Group by user.
GROUP BY thành_viên
ORDER BY lần_sửa_đổi_cuối;

SQL

Checking query status...