Linked pages w/edits by specific user since date

Pages linked from [[Wikipedia:WikiProject Academic Journals/Journals cited by Wikipedia/Sandbox]] with at least one edit by [[User:Citation bot]] on 2023 July 20 or later.

For [[WP:RAQ#Articles not edited by Citation bot]] (which first asks for articles that were edited, despite the section name) circa 2023 July 8.

SQL

SELECT pl_namespace, pl_title, MAX(rev_timestamp) AS 'most recent edit'
FROM pagelinks
JOIN page AS sourcepage ON sourcepage.page_id = pl_from
JOIN page AS targetpage ON targetpage.page_namespace = pl_namespace AND targetpage.page_title = pl_title
JOIN revision ON rev_page = targetpage.page_id
JOIN actor ON actor_id = rev_actor
WHERE sourcepage.page_namespace = 4
  AND sourcepage.page_title = 'WikiProject_Academic_Journals/Journals_cited_by_Wikipedia/Sandbox'
  AND actor_name = 'Citation bot'
  AND rev_timestamp >= '20230720'
GROUP BY rev_page;

SQL

Checking query status...