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'
LEFT JOIN logging AS sixmonth (SELECT
    log_user_text, COUNT(*)
    WHERE log_type in ('block', 'delete', 'protect','rights')
    AND log_timestamp BETWEEN 20170201000000 AND 20170701000000 
    AND ug_group = 'sysop')
GROUP BY log_user_text;
SQL

Checking query status...
