Replicas browser and optimizer
Most-edited pages containing the name of a WikiProject
This query is marked as a draft
This query has been published
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.
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;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in