Kuwiki users no bots, sorted by edit count

This takes into account bots that don't have official bot status, but are nonetheless members of Categorie:Roboți Wikipedia. It also tells whether an account is an admin or a bot.

SQL

SELECT user.user_id AS user_id, user.user_name AS user_name, user.user_editcount AS user_editcount
FROM user
LEFT JOIN (
    SELECT user_id, 1 AS user_bot FROM user
    INNER JOIN (
        SELECT REPLACE(page_title, "_", " ") AS user_name FROM categorylinks
        INNER JOIN page ON categorylinks.cl_from = page.page_id
        WHERE (page_namespace = 2 AND cl_to = "Roboți_Wikipedia")
        UNION
        SELECT user_name FROM user
        INNER JOIN pagelinks ON user.user_name = REPLACE(pagelinks.pl_title, "_", " ")
        WHERE (pl_namespace = 2 AND pl_from = 1995229)
    ) AS user_exceptions ON user.user_name = user_exceptions.user_name
) AS ue ON user.user_id = ue.user_id
WHERE user.user_editcount > 100 AND ue.user_bot IS NULL
ORDER BY user_editcount DESC, user_id
LIMIT 1500;

SQL

Checking query status...