Most active WikiProjects in past year

Fork of Most-edited pages containing the name of a WikiProject by Jmorgan (WMF)

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

Last run September 5, 2016

List of WikiProjects by number of changes to all its pages in the last 365 days. From: https://en.wikipedia.org/wiki/Wikipedia:Database_reports/WikiProjects_by_changes/Configuration

Note that these are edits to the WikiProject pages, subpages, and talkpages, NOT edits to articles claimed by the WikiProject.

SQL

USE enwiki_p;
SELECT page_title AS project, 
(SELECT rev_id #COUNT(*) 
 FROM revision 
 WHERE page_id = rev_page 
 AND rev_timestamp > (NOW() - INTERVAL 1 MONTH)) 
 AS countall,
(SELECT rev_id # COUNT(*) 
 FROM revision 
 LEFT JOIN actor ON rev_actor = actor_id 
 LEFT JOIN user_groups ON actor_user = ug_user 
 WHERE page_id = rev_page 
 #AND ug_user NOT IN (SELECT DISTINCT user_groups.ug_user FROM user_groups WHERE ug_group = 'bot') 
 AND rev_timestamp > (NOW() - INTERVAL 1 MONTH)) AS countnobot
 FROM page
WHERE page_title = 'WikiProject_Visual_arts'
AND page_namespace = 5 
AND page_is_redirect = 0;

SQL

Checking query status...