Untitled query #36739

SQL

use arwiki_p;
SELECT user_name,  COUNT(*), actor_user
FROM actor
inner join user
on user_id = actor_user
inner join logging
on actor_user = log_actor
WHERE log_type in ('block', 'delete', 'protect','rights')
AND actor_user in (select ug_user from user_groups where ug_user = actor_user and ug_group = "sysop")
AND actor_user not in (select ug_user from user_groups where ug_user = actor_user 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
GROUP BY user_name
ORDER BY COUNT(*) DESC
LIMIT 50;
SQL

Checking query status...
