talk pages categories

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 page 
			WHERE page_title LIKE '%Articles_for_deletion%'
			AND rev_parent_id = 0
      AND page_namespace = 4
      AND page_is_redirect = 0
    )
    # EXCLUDE IPSs
    AND actor_user IS NOT NULL
    AND rev_timestamp < (NOW() - INTERVAL 30 DAY)
    
    AND page.page_namespace = 4
GROUP BY rev_page
ORDER BY editors DESC
LIMIT 10;
SQL

Checking query status...
