CKB Users by Articles !Bot

SQL

With Articles As
(SELECT actor.actor_id AS user_n, actor.actor_name AS 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
),
Templates As
(SELECT COUNT(revision.rev_actor) AS c10
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 = 10
      AND revision.rev_parent_id = 0
 AND actor.actor_id in (SELECT actor.actor_id AS user_n,
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)
GROUP BY revision.rev_actor
)

Select Articles.ActName, Articles.c0, c10 from Templates
limit 100
SQL

Checking query status...
