Users by number of article creations

SQL

SELECT actor_name, COUNT(*) as articles_created
FROM revision r
         INNER JOIN actor ON r.rev_actor = actor.actor_id
         INNER JOIN page p on r.rev_page = p.page_id
WHERE p.page_namespace = 0
  and p.page_is_redirect = 0
  and r.rev_parent_id = 0
  and ucase(actor_name) not like ucase("%BOT")
  and actor_name not like "%بوت%"
  and actor_name Not IN (SELECT user_name
                         FROM user_groups
                                  INNER JOIN user ON user_id = ug_user
                         WHERE ug_group = "bot")
GROUP BY actor_name
having COUNT(*) > 1
ORDER BY COUNT(*) DESC
LIMIT 500;
SQL

Checking query status...
