articles by number of contributors

Fork of unreviewed articles by number of contributors by Vexations

This query is marked as a draft This query has been published by Vexations.

SQL

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

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 page_namespace = 0
      AND page_is_redirect = 0
    )
    # EXCLUDE IPSs
    AND actor_user IS NOT NULL
    AND rev_timestamp < (NOW() - INTERVAL 30 DAY)
    #AND rev_timestamp > (NOW() - INTERVAL 3650 DAY)
    AND page.page_namespace = 0
GROUP BY rev_page
ORDER BY editors DESC
LIMIT 10;

SQL

Checking query status...