Untitled query #29153

SQL

USE svwiki_p; #wiki to use

SELECT
  page.page_title,
  rev_timestamp,
  CONCAT("Användare:", rev_user_text) as username,
  rev_comment
FROM revision
INNER JOIN page ON
  rev_page = page_id
WHERE page_namespace IN (0)
AND rev_timestamp > '20180101000000' # timestamp FROM
AND rev_timestamp < '20190101000000'; # timestamp TOS

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
# for multiple users, use:
# AND rev_user_text in ('Vesihiisi', 'Annika64')
GROUP BY rev_id
ORDER BY rev_timestamp DESC
LIMIT 10;
SQL

Checking query status...
