Untitled query #70431

SQL

SELECT
  user_name,
  page_len,
  page_id
FROM
  user
  JOIN page
  ON page_title = REPLACE(user_name, ' ', '_')
  AND page_namespace = 3
WHERE (
    SELECT
      COUNT(*)
    FROM
      revision_userindex
      JOIN page ON rev_page = page_id
    WHERE
      page_namespace = 3
      AND page_title = REPLACE(user_name, ' ', '_')
  ) = 1
AND (
    SELECT
      actor_name
      FROM
      revision_userindex
      JOIN page
      ON rev_page = page_id
      JOIN actor
      ON rev_actor = actor_id
    WHERE
      page_namespace = 3
      AND page_title = REPLACE(user_name, ' ', '_')
  ) = user_name
AND user_editcount = 1
LIMIT 500;
SQL

Checking query status...
