activity_of_bureaucrats

SQL

SELECT
    user_name,
    SUM(CASE WHEN log_type = "delete" AND log_action NOT IN ("delete_redir", "restore") THEN 1 ELSE 0 END) AS delete_count,
    SUM(CASE WHEN log_type = "delete" AND log_action = "restore" THEN 1 ELSE 0 END) AS restore_count
FROM
    logging, user, actor, user_groups
    where actor_id = log_actor 
    and user_id = ug_user
    AND actor_user = user_id
	AND ug_group = "sysop"
	AND user_name NOT IN ("مرشح الإساءة")
	and user_name = 'Nehaoua'
#GROUP BY user_name
ORDER BY
    user_name ASC,
    delete_count DESC,
    restore_count DESC
    limit 1
    ;
SQL

Checking query status...
