List of rollback actions performed by RC patroller

SQL

USE viwiki_p;
SELECT actor.actor_name AS "Tên tài khoản", GROUP_CONCAT(DISTINCT user_groups.ug_group) AS "Nhóm người dùng", COUNT(DISTINCT revision.rev_id) AS "Số tác vụ"
FROM
  revision
  INNER JOIN change_tag ON change_tag.ct_rev_id = revision.rev_id
  INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
  INNER JOIN actor ON revision.rev_actor = actor.actor_id
  INNER JOIN user_groups ON user_groups.ug_user = actor.actor_user
WHERE change_tag_def.ctd_name IN ("mw-rollback", "mw-undo")
AND user_groups.ug_group IN ("rollbacker", "patroller", "autopatrolled", "eliminator", "sysop")
GROUP BY actor.actor_id
ORDER BY `Số tác vụ` DESC
LIMIT 200

SQL

Checking query status...