Untitled query #20542

SQL

USE arwiki_p;
SELECT
          user_name,
          COUNT(log_timestamp)
        FROM logging
        JOIN user
        ON user_id = log_user
       AND log_type = 'abusefilter'
       OR  log_type = 'block'
       OR  log_type = 'delete'
       OR  log_type = 'protect'
       OR  log_type = 'rights'
       OR  log_type = 'restore'
       OR  log_type = 'revision'
       OR  log_type = 'reblock'
       OR  log_type = 'unblock'
       OR  log_type = 'unprotect'
       OR  log_type = 'modify'
              
              
        AND log_timestamp BETWEEN  20160101000000 AND 20160731235959
        AND user_name IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'sysop')
        GROUP BY log_user
        ORDER BY  COUNT(log_timestamp) DESC;
SQL

Checking query status...
