use arwiki_p;

SELECT

log_user_text, COUNT(*)

FROM logging

JOIN user_groups ON ug_user = log_user

WHERE log_type RLIKE '.*(delete|block|reblock|protect|unblock|unprotect|rights|restore).*'

AND log_action RLIKE '.*(delete|block|reblock|protect|unblock|unprotect|rights|restore).*'

AND log_timestamp BETWEEN 20170612000000 AND 20170619000000 

AND ug_group = 'sysop'

GROUP BY log_user_text

ORDER BY COUNT(*) DESC

LIMIT 6;