Autopatroll candidates on zhwiki

SQL

SELECT actor_name, COUNT(page_id) AS articles_created
FROM user_groups
JOIN actor ON actor_user = ug_user
JOIN revision_userindex ON rev_actor = actor_id
JOIN page ON page_id = rev_page
WHERE not exists (select 1 from user_groups where ug_user = actor_user and (ug_group="autoreviewer" || ug_group="patroller" || ug_group="sysop" || ug_group="bot"))
AND rev_parent_id = 0
AND page_namespace = 0
AND page_is_redirect = 0
GROUP BY actor_name
HAVING articles_created > 25
ORDER BY articles_created DESC

SQL

Checking query status...