Untitled query #42073

SQL

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

Checking query status...
