Untitled query #33880

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 not like '%5::newgroups%"bot"%'
                  and log_params not like '%::oldgroups"%"bot"%5::newgroups%'
                  and log_params not like '%5::newgroups%"sysop"%'
                  and log_params not like '%::oldgroups"%"sysop"%5::newgroups%'
                  and log_params not like '%5::newgroups%"interface-admin"%'
                  and log_params not like '%::oldgroups"%"interface-admin"%5::newgroups%'
                  and log_params not like '%5::newgroups%"bureaucrat"%' 
                  and log_params not like '%::oldgroups"%"bureaucrat"%5::newgroups%'
                  and log_params not like '%5::newgroups%"accountcreator"%'
                  and log_params not like '%::oldgroups"%"accountcreator"%5::newgroups%'
                  and log_params not like '%5::newgroups%"import"%'
                  and log_params not like '%::oldgroups"%"import"%5::newgroups%'
                  AND log_timestamp BETWEEN 20180901000000 AND 20190301000000) as "rights"
from user
inner join user_groups 
on ug_user = user_id
where ug_group = 'sysop';
SQL

Checking query status...
