Untitled query #42073

SQL

USE arwiki_p;
SELECT
  DATE_FORMAT(rev_timestamp, "%Y-%m-%d") AS day,
  COUNT(rev_timestamp) AS revisions, actor_name, user_editcount
FROM revision_userindex
JOIN actor on rev_actor = actor_id
INNER JOIN user
WHERE rev_timestamp BETWEEN 20200509000000 AND 20200510000000
AND user_editcount > 998
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')
and user_id > 0
GROUP BY actor_name
HAVING revisions > 0
ORDER BY revisions DESC;
#LIMIT 30
SQL

Checking query status...
