قائمة المستخدمين حسب التركيز

SQL

use arwiki_p;
select count(*)/(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;

SQL

Checking query status...