Ellenőrzésre váró átirányító lapok

SQL

SELECT rev_id as "# pending revisions"
FROM revision
INNER JOIN page ON rev_page = page_id
INNER JOIN flaggedpage_pending ON page_id = fpp_page_id
WHERE rev_id > fpp_rev_id;

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

SELECT COUNT(*) as "# pages with pending revisions"
FROM flaggedpage_pending;

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

Checking query status...
