Untitled query #69609

SQL

# Pseudocode SELECT * from contribs WHERE actor = "A1Cafel" AND "Meetings at the Estonian Foreign Ministry" in summary
# SELECT * FROM actor WHERE actor_name = "A1Cafel" # actor_id = 278; actor_user = 3726108
SELECT DISTINCT CONCAT("https://commons.wikimedia.org/wiki/File:", page_title)
FROM revision
INNER JOIN comment_revision ON comment_id = rev_comment_id
INNER JOIN page ON rev_page = page_id
INNER JOIN categorylinks ON cl_from = page_id
WHERE rev_actor = 278
	AND rev_timestamp > 20221200000000
    AND comment_text LIKE "Removing from [[Category:Meetings at the Estonian Foreign Ministry]]"
    AND page_id NOT IN (SELECT cl_from FROM categorylinks WHERE cl_to = "Meetings_at_the_Estonian_Foreign_Ministry")
	;
SQL

Checking query status...
