use arwiki_p;

select sum(rev_len)/(select count(distinct page_title) from page

                             inner join revision

                             on rev_page = page_id

                             where page_namespace = 0

                             and page_is_redirect = 0

                             and rev_user = user_id) as "density", user_name

from revision

inner join comment

on comment_id = rev_comment_id

inner join page

on page_id = rev_page

inner join user

on user_id = rev_user

where comment_text not like "%رجوع%" and comment_text not like "%استرجاع%"

and page_namespace = 0

and page_is_redirect = 0

and user_editcount > 20000

group by rev_user

order by density desc

limit 100;