Untitled query #70825

SQL

SELECT
  concat("[[User:", user_name, "]]"),
  page_len,
  page_id,
  (SELECT COUNT(*) FROM externallinks WHERE el_from = page_id) as ecount
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 
) > 10
AND user_editcount < 10
AND page_id < 35000000
LIMIT 5000;
SQL

Checking query status...
