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 actor_name, COUNT(*) FROM page
JOIN revision AS rv ON page_latest = rv.rev_id
JOIN actor_revision ON actor_id = rv.rev_actor
LEFT JOIN user_groups ON actor_user = ug_user AND ug_group IN ('sysop', 'autopatrolled' )
WHERE page_is_redirect = 1
AND page_namespace = 0
AND rev_parent_id = 0
AND ug_group IS NULL
GROUP BY rv.rev_actor;
SQL

Checking query status...
