Most prolific template maintainers

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

SQL

use hewiki_p;

select
  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
  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
  revision.rev_timestamp > 20190900000000
group by
  revactor_actor
order by
  edit_count desc
limit
  10;

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...