SQL
AخA
# 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("[[: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")
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.