Tewiki:Admin actions count -DONT MODIFY

SQL

use mlwiki_p;
SELECT actor_name,count(actor_name)
FROM logging,actor,user
WHERE 
-- log_type = 'delete'
-- 	AND log_action = 'revision'
    actor_id=log_actor
    and user_id=actor_user
    and (user_id in (select ug_user from user_groups where ug_group="sysop") or user_id in (select ufg_user from user_former_groups
                                                                                            where ufg_group="sysop"))
--    actor_name=@userr and
--    concat(log_type,"-",log_action) in ("abusefilter-modify","block-block","block-modify","block-reblock","block-unblock","delete-delete","delete-event","delete-restore","delete-revision","import-interwiki","protect-modify","protect-move_prot","protect-protect","protect-unprotect","renameuser-renameuser","rights-rights")
-- actor_name in ("Veeven","Rajasekhar1961","B.K.Viswanadh","రవిచంద్ర","Arjunaraoc","T.sujatha","K.Venkataramana","రహ్మానుద్దీన్","Pavan santhosh.s","Pranayraj1985","యర్రా రామారావు","Dev","Vnagarjuna","Gsnaveen","Mpradeep","S172142230149","Trivikram","JVRKPRASAD","Chavakiran","Ahmed Nisar","వైజాసత్య","కాసుబాబు","C.Chandra Kanth Rao","స్వరలాసిక","Chaduvari")
group by actor_name
ORDER BY count(actor_name) desc;
SQL

Checking query status...
