Tewiki:Admin actions count -DONT MODIFY

SQL

-- set @userr="Chaduvari";
SELECT actor_name,count(actor_name)
FROM logging,actor,user,user_groups
WHERE 
-- log_type = 'delete'
-- 	AND log_action = 'revision'
    actor_id=log_actor
    and user_id=actor_user
    and ug_user=user_id
    and ug_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...
