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

SQL

use arwiki_p;
select user_name, count(addbot), count(removebot), count(addsysop), count(addcreate), count(removecreate), count(addimport)
,count(removeimport), count(addbure)
from user
inner join user_groups 
on ug_user = user_id
inner join logging
on log_user = user_id
where ug_group = "bureaucrat"
and ((log_params like '%5::newgroups%"bot"%' as addbot) or
    log_params like '%5::newgroups%"sysop"%' as addsysop or
    log_params like '%5::newgroups%"bureaucrat"%' as addbure or
    log_params like '%5::newgroups%"accountcreator"%' as addcreateor
    log_params like '%5::newgroups%"import"%' as addimport or
    log_params like '%::oldgroups"%"import"5::newgroups%' as removeimport or
    log_params like '%::oldgroups"%"accountcreator"5::newgroups%' as removecreate or
    log_params like '%::oldgroups"%""5::newgroups%' as removebot or
    )
group by user_id;
SQL

Checking query status...
