use arwiki_p;

select user_name, count(*)/user_editcount as average

from user

inner join revision

on rev_user = user_id

inner join page

on page_id = rev_page

where (20180413000000 -  user_registration) < 200000000

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

having average > 0.333333

group by user_name

limit 50;