Untitled query #36734

SQL

use arwiki_p;
SELECT log_title, COUNT(*)
FROM logging
join user
WHERE log_type in ('block', 'delete', 'protect','rights')
AND log_timestamp BETWEEN 20190601000000 AND 20190607000000
AND 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 (log_title) not like ucase (_utf8"%BOT") COLLATE utf8_general_ci
AND log_title not like _utf8"بوت %" collate utf8_general_ci
AND log_title not like _utf8"بوت %" collate utf8_general_ci
GROUP BY log_title
ORDER BY COUNT(*) DESC
LIMIT 50;
SQL

Checking query status...
