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
	actor_user = user_id and
	rev_page = page_id and
    page_namespace = 0 and
    revision.rev_timestamp >= 20220921000000 and
    actor_user 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 actor_user = user_id
#user_name = actor_name 
# and    
limit 5;
*/


SELECT  actor_name, rev_actor, COUNT(*)
FROM
	revision, user, actor
    JOIN page ON rev_page = page_id
    JOIN actor ON rev_actor = actor_id
    JOIN actor_user = user_id
WHERE
	page_namespace = 0 AND
    revision.rev_timestamp >= 20220822000000 AND
    actor_user not in (select ug_user from user_groups where ug_group = 'bot')
group by rev_actor
order by count(*) desc
SQL

Checking query status...
