Untitled query #70431

SQL

SELECT
  concat("[[user:", user_name, "]]"),
  page_len,
  page_id
FROM
  user
  JOIN page
  ON page_title = REPLACE(user_name, ' ', '_')
  AND page_namespace = 2
WHERE (
    SELECT
      COUNT(*)
    FROM
      revision_userindex
      JOIN page ON rev_page = page_id
    WHERE
      page_namespace = 2
      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 = 2
      AND page_title = REPLACE(user_name, ' ', '_')
  ) = user_name
AND (
  SELECT COUNT(*) FROM externallinks WHERE el_from = page_id 
) > 0
AND user_editcount = 1
AND page_id < 15000000
AND page_len > 700
LIMIT 1;
SQL

Checking query status...
