Untitled query #44796

SQL

USE arwiki_p;
SELECT user_editcount, user_name, COUNT(rev_timestamp) AS revisions
FROM user
INNER JOIN revision_userindex on user_id = rev_actor
WHERE rev_timestamp BETWEEN 20200509000000 AND 20200510000000
AND user_editcount > 998
AND ucase (user_name) NOT LIKE ucase (_utf8"%BOT") COLLATE utf8_general_ci
AND user_name NOT LIKE _utf8"بوت %" COLLATE utf8_general_ci
AND user_name Not IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
GROUP BY user_name
ORDER BY user_editcount DESC;
#LIMIT 30
SQL

Checking query status...
