Untitled query #67698

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,
  ug.user_ia as user_ia,
  ug.user_patroller as user_patroller,
  ug.user_checkuser as user_checkuser
FROM
  user
  LEFT JOIN (
    SELECT
      ug_user,
      SUM(ug_group = "sysop") AS user_admin,
      SUM(ug_group = "bot") AS user_bot,
      SUM(ug_group = "interface-admin") AS user_ia,
      SUM(ug_group = "patroller") AS user_patroller,
      SUM(ug_group = "checkuser") AS user_checkuser,
    FROM
      user_groups ug
    GROUP BY
      ug_user
  ) AS ug ON user.user_id = ug.ug_user
ORDER BY
  user_editcount DESC,
  user_id
LIMIT
  500;

SQL

Checking query status...