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
WHERE user.user_editcount > 100
AND user.user_id NOT IN (
    SELECT user_id FROM (
        SELECT user_id 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 bot_users
)
ORDER BY user_editcount DESC, user_id
LIMIT 1500;

SQL

Checking query status...