Untitled query #67698

SQL

SELECT
  user.user_id AS user_id,
  user.user_name AS user_name,
  user.user_editcount AS user_editcount,
  ug.groups as groups
  CASE
    WHEN (
      ug.user_admin > 0
      OR ue.user_admin > 0
    ) THEN 1
    ELSE 0
  END AS user_admin,
  CASE
    WHEN (
      ug.user_bot > 0
      OR ue.user_bot > 0
    ) THEN 1
    ELSE 0
  END AS user_bot
FROM
  user
  LEFT JOIN (
    SELECT
      ug_user,
      SUM(ug_group = "sysop") AS user_admin,
      SUM(ug_group = "bot") AS user_bot
    FROM
      user_groups
    GROUP BY
      ug_user
    HAVING
      (
        user_admin = 1
        OR user_bot = 1
      )
  ) AS ug ON user.user_id = ug.ug_user
  LEFT JOIN (
    SELECT
      user_id,
      0 AS user_admin,
      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 = "บอตวิกิพีเดีย"
          )
      ) AS user_exceptions ON user.user_name = user_exceptions.user_name
  ) AS ue ON user.user_id = ue.user_id
ORDER BY
  user_editcount DESC,
  user_id
LIMIT
  500;
SQL

Checking query status...
