Orphaned file talk pages

SQL

SELECT
  user_name,
  user_editcount
FROM
  user
WHERE
  user_editcount > 300
  AND user.user_id NOT IN (
    SELECT
      ug_user
    FROM
      user_groups
    WHERE
      user_groups.ug_group = "bot"
  )
  AND user.user_id NOT IN (
    SELECT
      ufg_user
    FROM
      user_former_groups
    WHERE
      user_former_groups.ufg_group = "bot"
  )
  AND user_name NOT REGEXP '.*?(?:(?:[Rr][Oo]|)[Bb][Oo][Tt]|[Aa][Ww][Bb]|[Ss][Cc][Rr][Ii][Pp][Tt][Dd][Aa][Ee][Mm][Oo][Nn])\s*(?:!|[0-9]+||(?=[MDCLXVI])M*(C[MD]|D?C{0,3})(X[CL]|L?X{0,3})(I[XV]|V?I{0,3}))$'
GROUP BY
  user.user_id
ORDER BY
  user.user_editcount DESC;
SQL

Checking query status...
