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;

​