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 AS rv ON page_latest = rv.rev_id
JOIN actor_revision ON actor_id = rv.rev_actor
WHERE page_is_redirect = 1
AND NOT EXISTS (
  SELECT 1
  FROM user_groups
  WHERE ug_user = actor_user
  AND ug_group IN ( 'sysop', 'autopatrolled' )
)
AND NOT EXISTS (
  SELECT 1
  FROM user_former_groups
  WHERE ufg_user = actor_user
  AND ufg_group IN ( 'sysop', 'autopatrolled' )
)
AND NOT EXISTS (
  SELECT 1
  FROM revision AS rv2
  WHERE rv2.rev_id != page_latest
  AND rv2.rev_page = page_id
)
#GROUP BY actor_name
LIMIT 100;
SQL

Checking query status...
