Untitled query #19175

SQL

USE itwiki_p;

USE itwiki_p;

SELECT distinct(user_name)
FROM user u
WHERE u.user_editcount > 300
AND user_id NOT IN (SELECT ug_user
    FROM user_groups
    WHERE ug_group = 'bot' )
AND user_name NOT IN
    (SELECT gu_name
     FROM centralauth_p.globaluser JOIN centralauth_p.localuser ON lu_name=gu_name AND lu_wiki="itwiki"
     JOIN centralauth_p.global_user_groups ON gug_user=gu_id
     WHERE gug_group="global-bot")
AND (SELECT COUNT(rev_id) FROM revision_userindex WHERE rev_user=user_id AND rev_timestamp BETWEEN 20161001000000 AND 20170331000000) > 20
AND user_name NOT LIKE '%Bot%'
AND user_name NOT LIKE '%bot%'
ORDER BY user_editcount DESC;
SQL

Checking query status...
