Most prolific module maintainers in wikidata

Fork of Most prolific template maintainers in hewiki by Amire80

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

SQL

-- Choose the wiki!
-- English Wikipedia can take several minutes per day.
-- Smaller wikis take a few seconds per day.
use hewiki_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 like '2020%'
group by
  revactor_actor
order by
  edit_count desc
limit
  50;

SQL

Checking query status...