Untitled query #21823

SQL

USE arwiki_p;
SELECT user.user_name AS pusername, p_count FROM (SELECT log_user AS p_user, COUNT(log_user) AS p_count FROM logging AS up join revision r
 WHERE up.log_action='approve' or up.log_action='approve-ia' or up.log_action='approve-a' or up.log_action='approve2-i'
 or up.log_action='approve-i' or up.log_action='approve2' or up.log_action='unapprove' or up.log_action='unapprove2'
and r.rev_timestamp between 20170729000000 and 20170730000000
 GROUP BY log_user ORDER BY COUNT(log_user) DESC LIMIT 200) AS patrol, user
 WHERE p_user=user_id AND p_user NOT IN (SELECT ug_user FROM user_groups WHERE user_groups.ug_group='bot') LIMIT 100;
SQL

Checking query status...
