نشاط البيروقراط

SQL

use arwiki_p;
select concat ("{{مس|",user_name,"}}") as "اسم المستخدم", 
				  (select count(*) from logging where log_user = user_id and log_type = "rights" and 
                  log_params like '%5::newgroups%"bot"%'
                  and log_params not like '%::oldgroups"%"sysop"%5::newgroups%'
                  and log_params not like '%::oldgroups"%"bot"%5::newgroups%') as "+بوت",
                  
                  (select count(*) from logging where log_user = user_id and log_type = "rights" and 
                  log_params like '%5::newgroups%"sysop"%'
                  and log_params not like '%::oldgroups"%"sysop"%5::newgroups%') as "+إداري",
                  
                  (select count(*) from logging where log_user = user_id and log_type = "rights" and 
                  log_params like '%5::newgroups%"bureaucrat"%' 
                  and log_params not like '%::oldgroups"%"bureaucrat"%5::newgroups%') as "+بيروقراط",
                  
                  (select count(*) from logging where log_user = user_id and log_type = "rights" and 
                  log_params like '%5::newgroups%"accountcreator"%'
                  and log_params not like '%::oldgroups"%"accountcreator"%5::newgroups%') as "+منشئ حسابات",
                  
                  (select count(*) from logging where log_user = user_id and log_type = "rights" and 
                  log_params like '%5::newgroups%"import"%'
                  and log_params not like '%::oldgroups"%"import"%5::newgroups%') as "+مستورد",
                  
                  (select count(*) from logging where log_user = user_id and log_type = "rights" and 
                  log_params like '%::oldgroups"%"import"%5::newgroups%' 
                  and log_params not like '%5::newgroups%"import"%' ) as "-مستورد",
                  
                  (select count(*) from logging where log_user = user_id and log_type = "rights" and 
                  log_params like '%::oldgroups"%"accountcreator"%5::newgroups%' 
                  and log_params not like '%5::newgroups%"accountcreator"%') as "-منشئ حسابات",
                  
                  (select count(*) from logging where log_user = user_id and log_type = "rights" and 
                  log_params like '%::oldgroups"%"bot"%5::newgroups%' 
                  and log_params not like '%::oldgroups"%"sysop"%5::newgroups%'
                  and log_params not like '%5::newgroups%"bot"%') as "-بوت",
                  
                  (select count(*) from revision where rev_user = user_id and rev_page = 213729 and
                  rev_minor_edit = 0) as "وب:طصب"
                  
from user
inner join user_groups 
on ug_user = user_id
where ug_group = "bureaucrat";
SQL

Checking query status...
