أكثر المساهمين إنشاءً للمقالات في كهوف سين

SQL

use arwiki_p;
SET @rank=0;
SELECT @rank:=@rank+1 as "م", s.*
FROM ( select concat('[[مستخدم:',actor_name,'|',actor_name,']]') AS "المستخدم", COUNT(rev_id) AS "عدد المقالات"
from revision r
inner join actor
on actor_id = rev_actor
inner join page p1
on p1.page_id = rev_page
where (select p2.page_id from page p2 
       where p2.page_title = p1.page_title 
       and  p2.page_namespace = 0
       #and p2.page_namespace = (p1.page_namespace+1) 
       and p2.page_is_redirect = 0)  
in
(select cl_from from categorylinks 
 where cl_to = "مقالات_كهوف_سين")
and p1.page_is_redirect = 0
and r.rev_parent_id =0
       and  r.rev_timestamp  > 20210502000000

              AND actor_name NOT IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
group by actor_name
order by count(rev_id) desc) s;

SQL

Checking query status...