Untitled query #60271

SQL

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
order by c10 desc
limit 100
SQL

Checking query status...
