WITH raw AS

(

  SELECT CONCAT('User:', REPLACE(page_title, '_', ' ')) AS page_name,

         TO_CHAR(rev_timestamp) AS pages_last_edit,

         page_len,

         page_is_redirect,

         SUBSTRING_INDEX(REPLACE(page_title, '_', ' '), '/', 1) AS username

  FROM page

  JOIN revision ON rev_id = page_latest

  WHERE page_namespace = 2

    AND page_title LIKE '%/%'

  ORDER BY revision.rev_timestamp ASC

  LIMIT 1000

),

usernames AS

(

  SELECT DISTINCT username

  FROM raw

),

user_last_edits AS

(

  SELECT username,

         (SELECT TO_CHAR(MAX(rev_timestamp))

          FROM revision_userindex

          JOIN actor_revision ON actor_id = rev_actor

          WHERE actor_name = username) AS users_last_edit

  FROM usernames

)

SELECT page_name,

       pages_last_edit,

       users_last_edit,

       page_len,

       page_is_redirect

FROM raw

LEFT JOIN user_last_edits ON user_last_edits.username = raw.username;