Untitled query #20939

SQL

use arwiki_p;
SELECT
log_user_text
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 20170601000000 AND 20170701000000 
AND ug_group = 'sysop'
and (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 20170601000000 AND 20170701000000 
    AND ug_group = 'sysop')
GROUP BY log_user_text;
SQL

Checking query status...
