Untitled query #63838

SQL

use arwiki_p;
select actor_name, count(rev_id)
from revision
inner join actor
on actor_id = rev_actor
inner join page p1
on p1.page_id = rev_page
where (select p2.page_id from page p2 
       where p2.page_title = p1.page_title 
       and p2.page_namespace = (p1.page_namespace+1) 
       and p2.page_is_redirect = 0)  
and p1.page_is_redirect = 0
and rev_timestamp like "2021%"
AND actor_name NOT IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
group by actor_name
order by count(rev_id) desc 
limit 500;
SQL

Checking query status...
