Untitled query #42073

SQL

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

Checking query status...
