Edits by specific user in specific category

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

LEFT JOIN categorylinks
ON cl_from = username.page_id AND
  cl_to = "Användare_Göteborg"

# 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...