Latest properties

SQL

SELECT rc_actor, COUNT(rc_id), actor.* FROM recentchanges_userindex
JOIN actor ON rc_actor = actor_id
WHERE rc_type = 1
AND rc_namespace = 0
AND rc_patrolled <> 2
AND EXISTS (
  SELECT 1
  FROM page
  WHERE page_id = rc_cur_id
  AND page_is_redirect = 1
)
GROUP BY rc_actor
ORDER BY COUNT(rc_id) DESC
LIMIT 100;

SELECT * FROM page
JOIN revision ON rev_page = page_id
JOIN actor ON actor_id = rev_actor
JOIN (
  SELECT rev_page rpg, COUNT(rev_id) cnt
  FROM revision
  GROUP BY rev_page
) revisions ON rpg = page_id
WHERE page_is_redirect = 1
AND cnt = 1
AND NOT EXISTS (
  SELECT 1
  FROM user_groups
  WHERE ug_user = actor_user
  AND ug_group IN ( 'sysop', 'autopatrolled' )
)
GROUP BY actor_name
LIMIT 100;
SQL

Checking query status...
