Meta global renamers - latest actions

SQL

SELECT
  ptp.*,
  ptpt.*,
  u.user_name,
  u.user_id,
  GROUP_CONCAT(ug.ug_group),
  gu.gu_id,
  gug.*
FROM
  pagetriage_page ptp
  JOIN pagetriage_page_tags ptpt ON ptpt.ptrpt_page_id = ptp.ptrp_page_id
  JOIN user u ON ptpt.ptrpt_value = u.user_name
  LEFT JOIN user_groups ug ON u.user_id = ug.ug_user
  JOIN centralauth_p.globaluser gu ON gu.gu_name = u.user_name
  JOIN centralauth_p.global_user_groups gug ON gug.gug_user = gu.gu_id
WHERE
  ptp.ptrp_reviewed = 3
  AND ptpt.ptrpt_tag_id = 10
  AND NOT EXISTS (
    SELECT 1
    FROM user_groups ug
    WHERE ug.ug_user = u.user_id
    AND ug.ug_group IN ('bot', 'autoreviewer', 'sysop')
  )
GROUP BY
  ptp.ptrp_page_id
LIMIT
  100;
SQL

Checking query status...
