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 SUBSTRING_INDEX(page_title, '/', 1) AS project, 
#SUM((SELECT COUNT(*) FROM revision WHERE page_id = rev_page AND DATEDIFF(NOW(), rev_timestamp) <= 30)) AS count,
FROM page
WHERE page_title = 'WikiProject_Visual_arts'
AND page_namespace = 5 
AND page_is_redirect = 0
GROUP BY project
ORDER BY count DESC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...