CKB Users by Articles !Bot

SQL

USE ckbwiki_p;
SELECT actor.actor_id AS user_n,
COUNT(revision.rev_actor) AS creates
FROM revision
INNER JOIN page
ON page.page_id = revision.rev_page
JOIN actor
ON revision.rev_actor = actor.actor_id
WHERE page.page_is_redirect = 0
	  AND page.page_namespace = 0
      AND revision.rev_parent_id = 0
      AND actor.actor_id not in ((select distinct(ug_user) from user_groups where ug_group like '%bot%')) AND  user_n not in(select user_id from user where lower(Convert(user_name using utf8)) like ('%bot')))
GROUP BY revision.rev_actor
ORDER BY creates DESC
LIMIT 100
SQL

Checking query status...
