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 rev_actor, COUNT(page_id) FROM page
JOIN revision ON rev_page = page_id
#JOIN actor ON actor_id = rev_actor
WHERE page_is_redirect = 1
AND (
  SELECT COUNT(rev_id)
  FROM revision
  WHERE rev_page = page_id
  GROUP BY rev_page
  LIMIT 2
) = 1
GROUP BY rev_actor
LIMIt 100;
SQL

Checking query status...
