Untitled query #26802

SQL

USE metawiki_p;
SELECT
 user_name AS sysop,
 admin_actions
FROM user_groups
LEFT JOIN
  (
SELECT log_user_text,
log_user,
count(log_id) AS admin_actions
FROM logging
WHERE log_type IN ("block","delete","import","protect","rights", "merge", "massmessage", "abusefilter")
AND log_type != "5"
AND log_timestamp > 2017100100000
GROUP BY log_user_text
 ) AS sysc
ON log_user = ug_user
INNER JOIN user
ON user_id = ug_user
WHERE ug_group = "sysop"
AND ( admin_actions < 11 OR admin_actions IS NULL)
ORDER BY admin_actions DESC;
SQL

Checking query status...
