Pending changes by users with autoreview right

SQL

SELECT COUNT(DISTINCT rev_id) as "# pending revisions by users with autoreview right"
FROM revision
INNER JOIN flaggedpage_pending ON fpp_rev_id = rev_id
INNER JOIN actor ON actor_id = rev_actor
LEFT OUTER JOIN user_groups ON ug_user = actor_user
WHERE ug_group IN ('editor','trusted','sysop','bot');
SELECT COUNT(*) as "# pending revisions"
FROM flaggedpage_pending

SELECT COUNT(DISTINCT page_id) as "# pages with pending revisions"
FROM page
INNER JOIN flaggedpage_pending ON fpp_page_id = page_id

SQL

Checking query status...