Untitled query #36738

SQL

use arwiki_p;
SELECT user_name
FROM user
inner join actor
on actor_user = user_id
inner join logging 
ON log_id = user_id
WHERE user_id in (select ug_user from user_groups where ug_user = user_id and ug_group = "sysop")
AND user_id not in (select ug_user from user_groups where ug_user = user_id and ug_group = "bot")
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 like _utf8"بوت %" collate utf8_general_ci
AND log_timestamp BETWEEN 20190601000000 AND 20190607000000
GROUP BY user_name
LIMIT 50;
SQL

Checking query status...
