unreviewed articles by number of contributors

SQL

SELECT
  page_title,
  rev_page                  AS page_id,
  count(*)                  AS revisions,
  count(distinct rev_actor) AS editors,
  sum(rev_len)              AS size
FROM revision 
INNER JOIN page ON page_id = rev_page
INNER JOIN pagetriage_page ON rev_page = ptrp_page_id

INNER JOIN actor ON actor_id = rev_actor
WHERE 
	rev_page IN (
      SELECT rev_page FROM revision INNER JOIN pagetriage_page ON rev_page = ptrp_page_id INNER JOIN page ON page_id = rev_page
      WHERE rev_parent_id = 0
      AND ptrp_reviewed = 0
      AND page_namespace = 0
      AND page_is_redirect = 0
    )
    # EXCLUDE IPSs
    AND actor_user IS NOT NULL
    AND rev_timestamp < (NOW() - INTERVAL 365 DAY)
    #AND rev_timestamp > (NOW() - INTERVAL 3650 DAY)
    AND page.page_namespace = 0
GROUP BY rev_page
ORDER BY editors DESC
LIMIT 100;
SQL

Checking query status...
