Untitled query #60271

SQL

With uid(user_n) As
(SELECT actor.actor_user 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
ORDER BY COUNT(revision.rev_actor) DESC
limit 100
),
un As
(SELECT distinct(actor.actor_name) AS user_name
FROM revision
JOIN actor
ON revision.rev_actor = actor.actor_id
 WHERE actor.actor_user in (SELECT actor.actor_user
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 COUNT(revision.rev_actor) DESC)
limit 100
)

Select user_name from un
SQL

Checking query status...
