SQL
AخA
select
rev_id, rev_timestamp, page_namespace, actor_name#,
#count(rev_id) as edit_count
from revision
inner join actor on rev_actor = actor_id
inner join page on rev_id = page_id
where
rev_timestamp >= 20000101000000 and
#rev_timestamp >= 20210101000000 and
#rev_timestamp < 20220101000000 and
page_namespace = 828
#order by edit_count desc
limit 20;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.