List of viwiki sysops by last log action and edit

Fork of List of viwiki patroller by last log action and edit by Hide on Rosé

This query is marked as a draft This query has been published by Hide on Rosé.

SQL

WITH groups AS (
  SELECT ug_user, GROUP_CONCAT(ug_group) AS memberships 
  FROM user_groups 
  WHERE ug_group = 'sysop'
  GROUP BY ug_user)
SELECT
  actor.actor_name AS thành_viên,
  memberships AS nhóm,
-- https://www.mediawiki.org/wiki/Manual:Revision_table
  MAX(rev_timestamp) AS lần_sửa_đổi_cuối,
-- https://www.mediawiki.org/wiki/Manual:Logging_table
  MAX(log_timestamp) AS nhật_trình_cuối
FROM revision
  LEFT JOIN actor ON revision.rev_actor = actor.actor_id
  LEFT JOIN logging ON logging.log_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 ASC, nhật_trình_cuối;

SQL

Checking query status...