Replicas browser and optimizer
Users with most edits in the past month with bots and IPs filtered
This query is marked as a draft
This query has been published
List of a user's edit times.
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 memberships IS NOT NULL -- Group by user. GROUP BY thành_viên ORDER BY lần_sửa_đổi_cuối;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in