Most prolific template maintainers

SQL

-- Choose the wiki!
-- English Wikipedia can take several minutes per day.
-- Smaller wikis take a few seconds per day.
use ptwiki_p;

select
  -- revision_actor_temp will some day be deprecated
  revision_actor_temp.revactor_actor,
  count(revision_actor_temp.revactor_actor) as edit_count,
  actor.actor_name
from
  page,
  actor,
  revision,
  revision_actor_temp
where
  -- Template is 10
  -- Module is 828
  page.page_namespace = 10 and
  revision.rev_page = page.page_id and
  revision.rev_id = revision_actor_temp.revactor_rev and
  revision_actor_temp.revactor_actor = actor.actor_id and
  -- Adjust the date
  revision.rev_timestamp > 20190806000000
group by
  revactor_actor
order by
  edit_count desc
limit
  20;
SQL

Checking query status...
