use arwiki_p;

select user_name, count(*)

from user

inner join revision on rev_user = user_id

inner join page on page_id = rev_page

where (20240725000000 -  user_registration) < 200000000

and ((page_namespace%2 =1) or (page_namespace = 4))

group by user_name

order by count(*) desc

limit 50;