CKB Users by Articles !Bot

SQL

SELECT  actor.actor_user, CONCAT('[[Special:Contributions/',actor.actor_name,'|',actor.actor_name,']]') ActName,
COUNT(revision.rev_actor) AS c0
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_user not in ((select distinct(ug_user) from user_groups where ug_group like '%bot%')) AND  actor.actor_user not in(select user_id from user where lower(Convert(user_name using utf8)) like ('%bot'))
GROUP BY revision.rev_actor
ORDER BY c0 DESC
limit 100
SQL

Checking query status...
