SQL
x
set @dbname=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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.