Edits by specific user in specific category

SQL

USE svwiki_p;

SELECT
  page.page_title,
  rev_timestamp,
  rev_user_text,
  rev_comment
FROM revision
INNER JOIN page ON
  rev_page = page_id
INNER JOIN categorylinks ON
  cl_from = page.page_id AND
  cl_to = "Personer_verksamma_vid_Uleåborgs_universitet"
  # for multiple categories, use:
  # cl_to in ("Personer_verksamma_vid_Uleåborgs_universitet", "Personer_verksamma_vid_Helsingfors_universitet")
WHERE page_namespace IN (0)
AND rev_timestamp > '20180101000000'
AND rev_timestamp < '20190101000000'
AND rev_user_text in ('Vesihiisi', 'Annika64')
GROUP BY rev_id
ORDER BY rev_timestamp DESC
LIMIT 200;

SQL

Checking query status...