USE svwiki_p; #wiki to use

​

SELECT

  rev_user_text,

  rev_timestamp

FROM revision

JOIN (SELECT

        page_title

      FROM page

      JOIN categorylinks

      ON cl_from = page_id

      WHERE cl_to = 'Användare_Göteborg'

      AND page_namespace = 2

      AND page_title NOT LIKE '%/%') AS cltmp

ON REPLACE(cltmp.page_title, '_', ' ') = rev_user_text

WHERE rev_timestamp = (SELECT

                         MAX(rev_timestamp)

                       FROM revision

                       WHERE rev_user_text = REPLACE(cltmp.page_title, '_', ' '));