trwiki: users by edit count in main namespace last month

SQL

#set @interval = 30;  -- in days
/*
select
	rev_actor,
    count(*)
from revision
join page on rev_page = page_id
where
    page_namespace = 0 and
    revision.rev_timestamp >= 20220822000000 and
    rev_actor not in (select ug_user from user_groups where ug_group = 'bot')
group by rev_actor
order by count(*) desc

#set @interval = 30;  -- in days

select
	actor_name, ug_group, actor_user, user_id, rev_actor,
    count(*)
from revision, actor, page, user_groups, user
where
	rev_page = page_id and
    page_namespace = 0 and
    revision.rev_timestamp >= 20220912000000 and
    rev_actor not in (select ug_user from user_groups where ug_group = 'bot')
    
group by rev_actor
order by count(*) desc
*/

select distinct
	actor_name, actor_user, user_id, user_name, rev_actor
    from actor, user_groups, user, revision
where
#    user_name = actor_name and
#    revactor_actor = actor_id and
limit 5;
SQL

Checking query status...
