Untitled query #21823

SQL

USE arwiki_p;
SELECT
    log_user_text, COUNT(*)
    FROM logging
    JOIN user_groups ON ug_user = log_user
    WHERE log_action in ('approve-ia', 'approve', 'approve-a','approve2-i','approve-i','approve2','unapprove','unapprove2')
    AND log_timestamp BETWEEN 20100701000000 AND 20170730000000
	AND ug_group = 'editor'
    AND ug_user NOT IN (SELECT ug_user FROM user_groups WHERE user_groups.ug_group='bot')
    AND log_namespace = 0
    group by logging.log_user
    having COUNT(*)>1
    GROUP BY log_user_text
    ORDER BY COUNT(*) DESC
    LIMIT 10;
SQL

Checking query status...
