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 (20180415000000 -  user_registration) < 200000000

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

group by user_name

order by count(*) desc

limit 50;